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 bulletsPower 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)- NoneJob 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.EducationBachelor's degree in Computer Science, Information Systems, or related field.