Power BI Architect - Foster City, CA USA

Overview

Hybrid
$100,000 - $140,000
Full Time

Skills

Power BI Expertise
Power BI Migration
BI Architect

Job Details

Hi,

We are hiring

Power BI Architect

Foster City, CA 94404

No of roles: 2

Must Have Technical/Functional Skills

  • Power BI Expertise
  • Advanced data modeling (star schema, snowflake, composite models)
  • DAX proficiency for complex measures and KPIs
  • Performance tuning (aggregations, incremental refresh, query folding)
  • Data Warehousing & Modeling
  • Design and implement dimensional models and data marts
  • Strong understanding of relational and analytical databases (SQL Server, Synapse, Snowflake, etc.)
  • Handling Slowly Changing Dimensions (SCD), surrogate keys, and conformed dimensions
  • ETL/ELT & Integration
  • Build and optimize ETL/ELT pipelines using tools like Azure Data Factory, SSIS, or Databricks
  • Implement incremental refresh and CDC strategies
  • Integrate Power BI with enterprise systems (IAM, catalogs, CI/CD)
  • Migration Expertise
  • Experience migrating legacy BI platforms (e.g., MicroStrategy, SSRS) to Power BI
  • Report inventory analysis, semantic layer redesign, and KPI parity validation
  • Governance & Security
  • Implement RLS (Row-Level Security) and OLS (Object-Level Security)
  • Workspace governance, certified datasets, and deployment pipelines
  • Metadata and lineage management using tools like Purview or Collibra
  • DevOps & Automation
  • Automate deployments with Power BI REST APIs and PowerShell
  • CI/CD pipelines for PBIX, datasets, and parameters
  • Version control and rollback strategies
  • Performance & Capacity Planning
  • Optimize large-scale models for Premium capacities
  • Monitor and manage capacity utilization and cost
  • Cloud & Identity Management
  • Azure AD/Entra ID for authentication and role synchronization
  • Service principals and token-based authentication for embedding scenarios

Roles & Responsibilities

Lead BI Architect with experience in Power BI Migration . Able to design and implement the architecture for business intelligence solutions, creating data models and data warehouses to support an organizations reporting and data analysis needs. Key responsibilities include developing data models, ensuring data integration across systems, guiding strategic BI goals, and overseeing the technical aspects of BI projects. This role requires strong technical expertise in areas like data warehousing, ETL processes, and analytics tools, as well as collaboration with stakeholders to translate business requirements into technical solutions.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About INUIX Consulting