Business Intelligence Solutions Architect

Job Title: Power BI Architect

Location: Foster City, CA Onsite

Full Time

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

Nice to Have:

Experience with MicroStrategy to Power BI migration.

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.

• Design and development: Architect and design data models, data warehouses, and ETL (Extract, Transform, Load) processes, Understand current reports and develop new using Power BI

• Technical leadership: Provide technical guidance and leadership for BI projects, ensuring the scalability, security, and efficiency of data systems.

• Strategic planning: Collaborate with stakeholders to define and implement strategic BI goals and initiatives that align with business objectives.

• Integration: Lead the integration of BI platforms with other enterprise systems and applications.

• System oversight: Ensure the quality and accessibility of data, while also managing metadata, data lineage, and data security.

Regards,

Shweta Sharma

shweta.sharma@msrtechnologies.com