Power BI Architect, Foster , CA, onsite

Job Title:
Power BI Architect, Foster City, CA, 5 days a week onsite
- Up to 180K

We are seeking a highly skilled Power BI Architect with deep expertise in data modeling, ETL/ELT processes, and Power BI migrations. The ideal candidate will design, implement, and optimize business intelligence architectures, ensuring scalable, secure, and high-performance reporting solutions that meet strategic business objectives.

• Architect and design data models, dimensional models, and data warehouses to support reporting and analytics needs.
• Lead migration of legacy BI platforms (e.g., Micro Strategy, SSRS) to Power BI, including report inventory analysis, semantic layer redesign, and KPI parity validation.
• Develop and optimize ETL/ELT pipelines using tools such as Azure Data Factory, SSIS, or Databricks.
• Implement incremental refresh, CDC strategies, and performance tuning for large-scale Power BI models.
• Ensure governance, security, and compliance through RLS, OLS, workspace governance, certified datasets, deployment pipelines, and metadata management.
• Automate deployments using Power BI REST APIs, Power Shell, and CI/CD pipelines.
• Provide technical leadership and guidance for BI projects, collaborating with stakeholders to translate business requirements into technical solutions.
• Oversee integration with enterprise systems, cloud identity management, and capacity planning for Premium environments.

• Proven experience as a BI Architect with extensive Power BI expertise.
• Strong knowledge of advanced data modeling (star schema, snowflake, composite models), DAX, and data warehousing concepts.
• Hands‑on experience with relational and analytical databases (SQL Server, Synapse, Snowflake).
• Experience handling Slowly Changing Dimensions (SCD), surrogate keys, and conformed dimensions.
• Familiarity with Micro Strategy to Power BI migrations is a plus.
• Strong understanding of ETL/ELT processes, CI/CD pipelines, Dev Ops automation, and cloud/identity management (Azure AD/Entra ).

• 150,000 – 180,000 per year

Apply with your CV to be considered for this position. You can also get in touch at or

Power BI, Data Modeling, DAX, ETL/ELT, Azure Data Factory, SSIS, Databricks, Micro Strategy, Data Warehouse, Dimensional Models, CI/CD, RLS, OLS, Metadata Management, Cloud Identity