Tata Consultancy Services · 1 day ago
Power BI Architect
Foster City, CA
Full-time
Onsite
Mid, Senior Level
$110K/yr - $150K/yrTata Consultancy Services is seeking a Power BI Architect to lead BI architecture and migration projects. The role involves designing and implementing data models and warehouses to support business intelligence solutions, ensuring data integration and guiding strategic BI initiatives.
Business Information SystemsConsultingInformation TechnologyIT Management
Hiring Manager
Sejal Ejanthkar
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
Tata Consultancy Services
Tata Consultancy Services is a business solutions company that specializes on information technology services and consulting.
Founded in 1968
10001+ employees
H1B Sponsorship
Tata Consultancy Services 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 (7880)
2024 (9690)
2023 (8537)
2022 (11159)
2021 (9813)
2020 (11984)
Funding
Current Stage
Public CompanyTotal Funding
unknown2004-08-25IPO
Leadership Team
K. Krithivasan
Chief Executive Officer & Managing Director
Aarthi Subramanian
President and Chief Operating Officer
Recent News
Trak.in - Indian Business of Tech, Mobile & Startups
2026-01-06
Business News Americas
2026-01-06
Company data provided by crunchbase