Business Intelligence Developer — Greater Pittsburgh Region

79ucPw 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 79ucPw.

79ucPw 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.

For finer details on how 79ucPw can impact your career, apply today!