Power BI Architect

Job Description: This role is responsible for designing, implementing, and supporting enterprise-grade Power BI solutions that enable data-driven decision-making across the organization. The Principal I, Power BI Architect will lead the development of scalable data models, enforce governance standards, and optimize performance across the Power BI ecosystem. This role requires deep expertise in Power BI architecture, DAX, SQL, and cloud platforms such as Azure and Snowflake. The ideal candidate will also support Power BI Embedded implementations and CI/CD practices, ensuring seamless integration with web applications and backend systems. Familiarity with Direct Lake and Delta Table integration, Power BI capacity unit (CU) consumption, and Power Apps is highly desirable.

Required Experience & Skill:
• 8+ 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.
• rcGIS ESRi knowledge

RESPONSIBILITIES:
Power BI Architecture & Solution Design:
• Lead the design and implementation of end-to-end Power BI solutions including reports, dashboards, and semantic models.
• rchitect 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.
Deployment & Administration:
• Implement CI/CD pipelines using Git, TMDL, and Tabular Editor.
• Manage Power BI tenant settings, workspace governance, and user access controls.