Business Intelligence Developer

eNGINE; Pennsylvania; On-site; USD 120,000 - 180,000; Full time

Job summary

eNGINE is seeking a Senior Power BI Developer to own the semantic model design, data integrity, and reporting performance across the organization. You will take ownership of the BI stack and collaborate with stakeholders to deliver reliable BI solutions.

Responsibilities include designing advanced Power BI reports, optimizing data models, and resolving production incidents in Fabric or Power BI Premium environments. This role requires expert DAX and SQL skills and strong communication.

Qualifications

• Expert-level Power BI development with complex DAX and measures.
• Deep knowledge of semantic data models, star schema, and row-level security.
• Broad understanding of the three BI layers: Data, Semantic, Visualization.
• Experience optimizing reports and models through query folding and aggregations.
• Advanced SQL across platforms (SQL Server, Azure SQL, Synapse, Databricks).
• Ability to write, debug, and optimize complex queries, procedures, and views.
• Experience with Microsoft Fabric or Power BI Premium capacity management.
• Familiar with Fabric alerts, capacity issues, and production incident triage.

Responsibilities

• Design, develop, and optimize Power BI reports and dashboards with advanced DAX.
• Architect and maintain semantic models ensuring data consistency and single source of truth.
• Own full BI layer from data to visualization to drive integrity.
• Write and optimize complex SQL queries for data extraction and analysis.
• Monitor and resolve performance issues and capacity constraints.
• Respond to incidents in Fabric or Power BI Premium environments.
• Collaborate with stakeholders to translate requirements into BI solutions.
• Document data models, metrics, and architectural decisions.

Skills

Power BI development

DAX

Semantic model design

SQL performance tuning

Fabric/Power BI Premium capacity

incident triage in BI environments

communication with stakeholders

Tools

SQL Server

Azure SQL

Synapse

Databricks

Power Query / M language

Microsoft Fabric

Job description

eNGINE builds Technical Teams. We are a Solutions and Placement firm shaped by decades of interaction with Technical professionals. Our inspiration is continuous learning and engagement with the markets we serve, the talent we represent, and the teams we build. Our Consulting Workforce is encouraged to enjoy career fulfillment in the form of challenging projects, schedule flexibility, and paid training/certifications. Successful outcomes start and finish with eNGINE.

eNGINE is hiring a Senior Power BI Developer who goes beyond building dashboards — someone who deeply understands the full BI stack, from raw data to the final visualization layer. In this role, you will take ownership of semantic model design, data integrity, and reporting performance across the organization. You will be a trusted voice when things break and a creative force when building something new.

Key Responsibilities:

• Design, develop, and optimize advanced Power BI reports and dashboards using complex DAX measures and calculations.
• Architect and maintain semantic models that ensure metric consistency and a single source of truth across all reporting.
• Own the full BI layer — Data, Semantic, and Visualization — to drive data integrity end-to-end.
• Write and optimize complex SQL queries for data extraction, transformation, and analysis.
• Monitor and troubleshoot report performance issues, including slow-loading visuals, query bottlenecks, and capacity constraints.
• Respond to and resolve critical incidents in Microsoft Fabric or Power BI Premium capacity environments.
• Collaborate with stakeholders to translate business requirements into reliable, scalable BI solutions.
• Document data models, metric definitions, and architectural decisions to support team knowledge-sharing.
• Continuously evaluate and improve BI processes, tooling, and personal skillset.

Required Qualifications:

• Expert-level Power BI development experience, including complex DAX formulas, calculated tables, and measures.
• Deep knowledge of semantic (data) model design — including table relationships, star schema architecture, aggregations, and role-level security.
• Strong understanding of the three BI layers: Data layer (ingestion/transformation), Semantic layer (business logic), and Visualization layer (reporting).
• Experience optimizing report and model performance through query folding, aggregations, and incremental refresh.
• Advanced SQL skills across one or more platforms (e.g., SQL Server, Azure SQL, Synapse, Databricks).
• Ability to write, debug, and optimize complex queries, stored procedures, and views.
• Experience with Microsoft Fabric or Power BI Premium capacity management.
• Familiarity with troubleshooting Fabric/capacity alerts, including resource contention, refresh failures, and gateway issues.
• Comfortable working in high-urgency situations and triaging production incidents with a calm, structured approach.

Preferred Qualifications:

• Experience with Microsoft Fabric (Lakehouses, Pipelines, Notebooks, or Direct Lake mode).
• Familiarity with Power Query / M language for data transformation.
• Exposure to Azure Data Factory, Synapse Analytics, or Databricks.
• Experience working in Agile or scrum-based development environments.
• Strong communication skills — you can explain a complex data model to a non-technical executive clearly and confidently.

No C2C, relocation, or sponsorship.