Job title: Power BI Tech Lead

Location: Oaks, PA (3 days onsite in a week)

Position Overview

seeking a highly skilled and experienced Power BI Technical Lead to design, develop, and lead enterprise-grade business intelligence and analytics solutions.

The ideal candidate will combine strong technical expertise in Power BI and data engineering concepts with leadership capabilities to guide development teams, engage stakeholders, and deliver scalable BI solutions aligned to business strategy.

This role requires hands-on development, architecture design, performance optimization, and team mentorship.

Key Responsibilities

Technical Leadership

Lead end-to-end design and implementation of Power BI solutions (reports, dashboards, data models).

Define BI architecture standards, best practices, and governance frameworks.

Provide technical direction to BI developers and ensure adherence to coding and design standards.

Conduct design reviews, code reviews, and performance optimization sessions.

Solution Design & Development

Design scalable semantic data models using Power BI datasets and Azure/SQL-based data sources.

Develop complex DAX calculations, measures, and KPIs.

Implement Row-Level Security (RLS) and data access strategies.

Integrate Power BI with Azure Data Factory, Synapse, Databricks, Snowflake, or other enterprise platforms.

Optimize performance of large datasets and enterprise reports.

Stakeholder & Client Engagement

Translate business requirements into technical BI solutions.

Work closely with business stakeholders, product owners, and data engineers.

Provide effort estimations, solution architecture documentation, and technical proposals.

Present dashboards and analytics insights to executive leadership.

Delivery & Governance

Lead sprint planning, backlog refinement, and technical task allocation.

Ensure adherence to SDLC, DevOps, and CI/CD best practices.

Manage Power BI Service environments (workspaces, deployment pipelines, gateways).

Ensure data governance, security compliance, and documentation standards.

Required Qualifications

Bachelor’s degree in Computer Science, Information Systems, or related field.

8+ years of experience in BI/Data Analytics.

5+ years of hands-on experience with Power BI development.

Strong expertise in:

DAX (advanced calculations, time intelligence, optimization)

Power Query (M language)

Data modeling (star schema, snowflake schema)

SQL (advanced querying, performance tuning)

Experience with Azure Data Platform (ADF, Synapse, Azure SQL, ADLS).

Strong understanding of BI architecture, governance, and security models.

Experience leading technical teams (onshore/offshore model preferred).