PowerBI Developer

Must Haves

• 5 years hands-on experience in Data Analytics, BI, or Data Engineering roles.
• Advanced Power BI skills (DAX, star schema modeling, governance, dataflows, incremental refresh).
• Strong SQL (Intermediate–Advanced) for data extraction and transformation.
• Python or other scripting languages for automation and API integration.
• Advanced Excel for QC, reconciliation, and cross-validation.
• Experience with Smartsheet, SharePoint, MS365 ecosystem.
• Excellent documentation skills (data lineage, logic definitions, version control).
• Strong communication skills for technical and non-technical audiences.
• Ability to operate autonomously with minimal technical learning curve.

Plusses

• Experience integrating data from SAP and ServiceNow.
• Familiarity with Power Automate and Power Query (M).
• Background in dashboard governance and KPI implementation.
• Exposure to enterprise-scale reporting frameworks and QA processes.

Day to day

In this role, you will acquire and integrate data from multiple sources, including Smartsheet, Excel, SharePoint, SAP, ServiceNow, and APIs, while designing and executing complex data transformations and modeling with full traceability. You will develop and maintain Power BI dashboards for executive, tactical, and operational reporting, implement and validate KPIs, and ensure all metric definitions and documentation are accurate. A key part of the job involves automating workflows using Python, Power Automate, or MS365 tools to reduce manual effort, applying QA validation checks, and maintaining governance standards such as cutoff dates and version control. You will collaborate closely with Delivery Leads, Program Managers, Finance, and QA teams to clarify requirements and resolve data issues, provide periodic updates and data quality reports, and present actionable insights and recommendations to leadership and cross-functional teams.

Responsibilities:

• Acquire and integrate data from multiple sources (Smartsheet, Excel, SharePoint, SAP, ServiceNow, APIs).
• Design and execute complex data transformations and modeling with full traceability.
• Develop and maintain Power BI dashboards for executive, tactical, and operational reporting.
• Implement and validate KPIs; maintain metric definitions and documentation.
• Automate workflows using Python, Power Automate, or MS365 tools to reduce manual effort.
• Apply QA validation checks and ensure governance standards (cutoff dates, version control).
• Collaborate with Delivery Leads, Program Managers, Finance, and QA teams to clarify requirements and resolve data issues.
• Provide periodic updates, refresh summaries, and data quality reports.
• Present insights and recommendations to leadership and cross-functional teams.