MS/Fabric Solution Architect & Technical Lead Data Lakehouse,Data acquisition,Microsoft Fabric,Microsoft Power BI,agile methodology,analytics architecture,business intelligence,business reporting,code review,data analysis,data architecture,data engineering,data factory,data governance,data lineage,d US D1 ID-FSNA 'Solution Architecture & Design Lead end-to-end architecture and implementation of Microsoft Fabric solutions.Design scalable, secure, and high-performing enterprise data platforms. Develop data architecture standards, best practices, and governance frameworks. Create enterprise data models, data lakehouse architectures, and semantic layer strategies. Provide technical leadership for large-scale data transformation initiatives. Establish architecture roadmaps aligned to business objectives and digital transformation strategies. Microsoft Fabric Platform Leadership Architect and implement solutions utilizing: Fabric Data Factory Fabric Data Engineering Fabric Data Warehouse Fabric Lakehouse Fabric Real-Time Analytics Fabric Data Science Fabric Power BI OneLake Copilot in Fabric Optimize workloads for scalability, performance, and cost efficiency. Lead Fabric adoption and modernization programs. Data Engineering & Integration 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. Analytics & Reporting 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. Technical Leadership 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. Data Governance & Security 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. 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 base compensation range listed for this position reflects the minimum and maximum target compensation Capgemini, in good faith, believes it may pay for the role at the time of this posting. This range may be subject to change as permitted by law. The actual compensation offered to any candidate may fall outside of the posted range and will be determined based on multiple factors legally permitted in the applicable jurisdiction. These may include, but are not limited to: Geographic location, Education and qualifications, Certifications and licenses, Relevant experience and skills, Seniority and performance, Market and business consideration, Internal pay equity. It is not typical for candidates to be hired at or near the top of the posted compensation range. In addition to base salary, this role may be eligible for additional compensation such as variable incentives, bonuses, or commissions, depending on the position and applicable laws. Capgemini offers a comprehensive, non-negotiable benefits package to all regular, full-time employees. In the U.S. and Canada, available benefits are determined by local policy and eligibility and may include: Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, 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