MSR Technology Group · 18 hours ago
Business Intelligence Solutions Architect
Foster City, CA
Full-time
Onsite
Senior LevelMSR Technology Group is seeking a Business Intelligence Solutions Architect with expertise in Power BI. The role involves designing and implementing business intelligence solutions, developing data models, and ensuring data integration across systems while collaborating with stakeholders to meet strategic BI goals.
Management Consulting
Hiring Manager
Shweta Sharma
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
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
Qualification
Required
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
Preferred
Experience with MicroStrategy to Power BI migration
Company
MSR Technology Group
As a leader in professional services, MSR Technology Group ignites growth for businesses across diverse industries.
1001-5000 employees
H1B Sponsorship
MSR Technology Group has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (233)
2024 (175)
2022 (2)
Funding
Current Stage
Late StageCompany data provided by crunchbase