INUIX LLC ยท 1 day ago
Power BI Architect
Foster City, CA
Full-time
Onsite
Senior LevelINUIX LLC is seeking a Power BI Architect to lead the design and implementation of business intelligence solutions. The role involves creating data models, ensuring data integration, and overseeing technical aspects of BI projects while collaborating with stakeholders to meet business objectives.
AnalyticsConsultingIT Management
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
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
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
Developing data models, ensuring data integration across systems
Guiding strategic BI goals, and overseeing the technical aspects of BI projects
Architect and design data models, data warehouses, and ETL (Extract, Transform, Load) processes
Understand current reports and develop new using Power BI
Provide technical guidance and leadership for BI projects
Ensuring the scalability, security, and efficiency of data systems
Collaborate with stakeholders to define and implement strategic BI goals and initiatives that align with business objectives
Lead the integration of BI platforms with other enterprise systems and applications
Ensure the quality and accessibility of data, while also managing metadata, data lineage, and data security
Company
INUIX LLC
IT consulting company focused on CRM and ERP space , We provide consulting services as well as provide qualified CRM & ERP resources to our customer .
Founded in 2018
51-200 employees
H1B Sponsorship
INUIX LLC 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 (5)
2024 (3)
2023 (1)
2022 (1)
Funding
Current Stage
Growth StageCompany data provided by crunchbase