Job Title:
Role Overview
We are seeking a high-performing Senior Power BI Analyst / Developer to design, build, and optimize our next-generation enterprise analytics platform. In this role, you will be the core architect of our data visualization layer, turning complex data streams into actionable executive insights.
The ideal candidate bridges the gap between traditional business intelligence and modern cloud data engineering. You will be responsible for building highly performant, scalable data models on Azure and creating seamless, near real-time reporting solutions utilizing streaming data and Change Data Capture (CDC) pipelines.
Key Responsibilities
• Advanced Data Modeling & Performance Tuning
Design, implement, and maintain enterprise-grade, highly scalable data models (Star and Snowflake schemas) within Power BI and Azure Analysis Services/Fabric.
Optimize complex DAX queries, M code, and data loading processes to ensure sub-second dashboard responsiveness on large-scale datasets.
Implement advanced performance-tuning strategies, including aggregations, incremental refreshing, and hybrid tables (combining Import and DirectQuery).
• Streaming Analytics & Real-Time Reporting
Architect and implement near real-time dashboards utilizing Power BI streaming datasets, push datasets, and automatic page refreshes.
Integrate reporting front-ends with modern Change Data Capture (CDC) architectures to surface low-latency transactional updates.
Partner with data engineering teams to ingest and model fast-moving event data coming from cloud streams into analytical reporting structures.
• Azure Architecture Integration
Leverage the Azure data stack (Azure Synapse Analytics, Azure Data Lake Storage Gen2, Azure Databricks, and Azure SQL DB) to build robust downstream reporting layers.
Participate in the orchestration of data pipelines (using Azure Data Factory or Synapse pipelines) to align with dashboard refresh schedules.
Embrace modern Power BI developer workflows using Tabular Editor, ALM Toolkit, DAX Studio, and Git integration for version control.
Required Technical Skills & Qualifications
Experience: 3-5+ years of dedicated experience developing, modeling, and tuning enterprise Power BI solutions, with at least 2+ years operating within an Azure cloud ecosystem.
Expert DAX & Power Query: Mastery of complex DAX computations (time-intelligence, advanced filtering) and optimized M-code data transformations.
Modern Data Paradigms: Proven experience handling Streaming Data or CDC (Change Data Capture) patterns (e.g., streaming from Debezium, Azure Event Hubs, Kafka, or Synapse Link) into Power BI.
Azure Stack Expertise: Solid working knowledge of Azure data resources (Synapse, Data Factory, Azure SQL, or Azure Fabric Lakehouses).
Data Engineering Concepts: Deep understanding of data warehousing concepts, including slowly changing dimensions (SCDs), partitioning, and indexing strategies.
Education: Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related quantitative field (or equivalent practical experience).
Preferred (Nice-to-Have) Skills
Microsoft Certifications: PL-300 (Power BI Data Analyst) or DP-600 (Fabric Analytics Engineer).
Experience with CI/CD deployment pipelines for Power BI deployment pipelines or Azure DevOps.
Familiarity with SQL performance tuning (analyzing execution plans, optimizing views, and indexing).