Principal I, Power BI Architect

Overview:
THE ROLE: (Small summary of what you are looking for)

HOW YOU WOULD CONTRIBUTE: (Responsibilities and tasks associated with the job) *limit to 8-10 bullets

Power BI Architecture & Solution Design:

- Lead the design and implementation of end-to-end Power BI solutions including reports, dashboards, and semantic models.
- Architect scalable and performant data models tailored to business needs.
- Define and enforce Power BI development standards, governance, and best practices.
- Guide the use of advanced Power BI features such as calculation groups, field parameters, and bookmarks.

Data Integration & Backend Connectivity:

- Integrate Power BI with Snowflake, Azure SQL, and other cloud/on-prem data sources.
- Leverage Direct Lake and Delta Table integration for high-performance data access and real-time analytics.
- Collaborate with data engineering teams to ensure efficient data pipelines and refresh strategies.

Embedded Analytics & Web Integration:

- Design and implement Power BI Embedded solutions for web-based analytics delivery.
- Ensure secure and scalable embedding practices aligned with enterprise architecture.

Performance Optimization & Advanced Analytics:

- Write and optimize complex DAX expressions for performance and maintainability.
- Develop and maintain Power Query (M) scripts for advanced data transformation.
- Monitor and tune report performance, dataset refreshes, and query execution.

Deployment & Administration:

- Implement CI/CD pipelines using Git, TMDL, and Tabular Editor.
- Manage Power BI tenant settings, workspace governance, and user access controls.
- Support version control, automated deployment, and rollback strategies.

Collaboration & Leadership:

- Partner with business stakeholders to translate requirements into technical solutions.
- Mentor junior developers and contribute to a culture of continuous learning and innovation.
- Document architecture, data models, and deployment processes for maintainability.
- Other duties as assigned.

WHAT’S SPECIAL ABOUT THE TEAM: (Give insight to the team dynamic and environment)

The Principal I, Power BI Architect role designing and implementing enterprise-grade Power BI solutions to drive data-driven decision-making. It requires deep expertise in Power BI architecture, DAX, SQL, and cloud platforms like Azure and Snowflake. The position also emphasizes leadership in Power BI Embedded implementations, CI/CD practices, and governance standards.

SUPERVISORY RESPONSIBILITIES: (Share supervisory duties, if applicable)
- None

Job Qualifications:
SKILLS AND BACKGROUND REQUIRED TO BE SUCCESSFUL: (List requirements, including education and experience needed for the job) *limit 6-7 bullets
- 7 years of experience in Power BI development and business intelligence.
- 3 years of experience in a Power BI architect or similar leadership role.
- Proven track record of delivering scalable, high-performance BI solutions in enterprise environments.
- Expert-level proficiency in Power BI, DAX, Power Query, and M.
- Strong SQL skills for data extraction, transformation, and analysis.
- Deep understanding of semantic modeling and table design for analytics.
- Experience with Snowflake and Azure Data Services (e.g., Azure Data Factory, Synapse).
- Familiarity with Direct Lake and Delta Table integration.
- Hands-on experience with Power BI Embedded and web integration.
- Proficiency in CI/CD tools including Git, Tabular Editor, and TMDL.
- Understanding of Power BI capacity unit (CU) consumption and optimization.
- Knowledge of Power BI governance, security, and tenant administration.
- Familiarity with Power Apps for extending analytics workflows.

Education

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