MS Fabric Solution Architect

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.

About the Role

As the Solution Architecture & Design Lead, you will drive the end-to-end architecture and implementation of Microsoft Fabric solutions. Your role will include designing scalable, secure, and high-performing enterprise data platforms, developing data architecture standards, best practices, and governance frameworks, and creating enterprise data models, data lakehouse architectures, and semantic layer strategies. You will provide technical leadership for large-scale data transformation initiatives and establish architecture roadmaps aligned to business objectives and digital transformation strategies.

Responsibilities

• Architect and implement solutions utilizing Microsoft Fabric components: Data Factory, Data Engineering, Data Warehouse, Lakehouse, Real-Time Analytics, Data Science, Power BI, OneLake, and Copilot in Fabric.
• Optimize workloads for scalability, performance, and cost efficiency.
• Lead Microsoft Fabric adoption and modernization programs.
• Design and oversee enterprise ETL/ELT frameworks.
• Build and optimize data ingestion, transformation, and orchestration pipelines.
• Integrate structured, semi-structured, and unstructured data sources.
• Develop data migration strategies from legacy platforms to Microsoft Fabric.
• Implement data quality, validation, and reconciliation processes.
• Define enterprise reporting and analytics architectures.
• Design semantic models and business-friendly data marts.
• Enable self-service BI through Power BI and Fabric.
• Establish KPI frameworks, executive dashboards, and enterprise reporting standards.
• Optimize data models and reporting performance.
• Lead and mentor teams of Data Engineers, BI Developers, Data Analysts, and Data Scientists.
• Conduct architecture reviews and code reviews.
• Define development standards and engineering best practices.
• Drive Agile delivery and technical governance activities.
• Act as the primary technical escalation point for complex Fabric solutions.
• Implement enterprise data governance frameworks.
• Define metadata management and data lineage strategies.
• Ensure regulatory and compliance requirements are met.
• Implement security controls, role-based access, and data protection policies.
• Support audit and regulatory requirements.

Qualifications

Proven experience as a Solution Architect or Technical Lead in Microsoft Fabric, data lakehouse, data acquisition, and related technologies. Strong expertise in Microsoft Power BI, agile methodology, analytics architecture, business intelligence, and business reporting. Deep knowledge in data analysis, data architecture, data engineering, data factory, data governance, and data lineage.

Pay

The base compensation range for this role in the posted location is $125,000 - $135,000. Capgemini provides compensation range information in accordance with applicable national, state, provincial, and local pay transparency laws. The actual compensation offered may vary based on factors such as geographic location, education, certifications, relevant experience, skills, seniority, performance, market considerations, and internal pay equity.

Benefits

• Paid time off based on employee grade (12-25 days vacation, company paid holidays, personal days, sick leave).
• Medical, dental, and vision coverage (or provincial healthcare coordination in Canada).
• Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada).
• Life and disability insurance.
• Employee assistance programs.
• Other benefits as provided by local policy and eligibility.