Power BI Engineer (Microsoft BI Stack
Role details
Job location
Tech stack
Job description
-
Data Modeling & Semantic Layer o Design and maintain scalable data models and semantic layers to ensure consistent KPI definitions and trusted reporting.
-
ETL / Data Preparation o Build robust ETL pipelines using Power Query / M to ingest, clean, transform, and integrate data from multiple sources (e.g., ERP, cloud databases, flat files).
-
Power BI Dashboard Engineering o Develop interactive dashboards using advanced DAX measures, slicers, bookmarks, and navigation patterns to support diverse user personas (Ops, Finance, Exec).
-
Azure / Cloud Data Platform Enablement o Implement and maintain scalable back-end architectures leveraging Azure SQL, Azure Synapse, and Data Lake (Gen2) for reliable data processing and analytics workloads.
-
Performance & Reliability o Apply optimization techniques to improve dataset/report performance, refresh reliability, and overall user experience in high-volume environments.
-
Paginated / Operational Reporting o Build paginated reports (SSRS / Power BI Paginated) for detailed operational reporting consumed by large teams on a recurring cadence.
-
Dataflows & Reusability o Create and maintain Power BI Dataflows to centralize ingestion logic and streamline refresh cycles.
-
Stakeholder Management & Adoption o Lead requirements discovery with business stakeholders; deliver training, documentation, and onboarding to drive adoption and data literacy.
-
Operational Excellence o Create SOPs and automate recurring workflows for refreshes, QA, and deployment processes.
Requirements
-
Power BI Expertise o 7+ years in BI / analytics engineering, with deep hands-on expertise in Power BI delivery. o Possess strong expertise in Power BI development, dashboard design, data modeling, DAX, reporting architecture, and overall business intelligence best practices. o Advanced DAX (measures, calculated columns, time intelligence, performance patterns) and strong Power Query/M skills.
-
SQL & Data Modeling o Strong SQL for extraction, joining, and shaping data; solid dimensional modeling fundamentals (star schema, grain, surrogate keys, conformed dimensions).
-
Cloud Data Platforms o Proven experience with Azure SQL and/or Azure Synapse and lake-based architectures.
-
Reporting at Scale o Experience supporting executive and operational reporting for large user bases, including deployment and enablement.
-
Communication o Strong written and verbal communication skills; able to translate business questions into data products and explain metrics clearly to non-technical audiences.
Preferred (Nice-to-Have) Qualifications
- Microsoft Fabric exposure and/or modern Lakehouse patterns.
- Experience with SSRS / paginated reporting and governance for enterprise reporting.
- Experience with additional platforms (e.g., Snowflake, RDS, Salesforce, NetSuite) and integrating multi-source environments.
- Prior experience delivering investor/board-level reporting and metric storytelling (cohorts, CAC, churn, LTV).
Core Competencies (Behavioral)
- Strong ownership mindset; can take ambiguous requirements and drive to a high-quality deliverable.
- Detail-oriented with high standards for data quality, documentation, and usability.
- Collaborative and consultative-comfortable partnering with Finance, Operations, Sales, and Leadership.