> Markdown version of [/jobs/ext/4564088-lead-data-modeller](https://www.wearedevelopers.com/jobs/ext/4564088-lead-data-modeller). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead Data Modeller - **Company:** Capgemini - **Location:** United States - **Experience:** Expert - **Salary:** $125,000 - $135,000 - **Contract:** Permanent contract - **Skills:** Data Analysis, Continuous Integration, Data Architecture, Information Engineering, Data Governance, Data Integration, Data Systems, Data Warehousing, Database Queries, Python (Programming Language), Performance Tuning, Query Optimization, Standard Sql, Snowflake, Data Layers, Semantic Modeling - **Published:** November 4, 2026 - **Apply:** https://www.capgemini.com/jobs/591243-en_US_SAPBTP/x/ ## About the Role * 8 years of overall experience including Data Modeling Data Architecture or Data Engineering * 5 years of handson experience designing dimensional models StarSnowflake schemas Semantic models for data consumption * 3 years of experience with Snowflake in enterprisescale environments * Proven experience designing and implementing GoldConsumption layer solutions within a Medallion Architecture * Strong SQL skills with experience developing and optimizing complex analytical datasets * Experience integrating data from multiple source systems into unified businessready models * Demonstrated ability to work directly with business stakeholders to define metrics dimensions hierarchies and semantic models Preferred Qualifications * 2 years of Python development experience * Experience with DevOpsCICD practices and versioncontrolled deployments * Experience with YAMLbased semantic modeling frameworks * Knowledge of Snowflake query tuning and performance optimization Must Have Skills * Semantic Data Modeling * MultiDimensional Modeling * Data Architecture * Medallion Architecture Gold Layer * Snowflake * SQL * Business Data Consumption Analytics Ideal Candidate * A handson data architectmodeler with a proven track record of delivering businessready semantic models and consumption layers capable of transforming complex data ecosystems into intuitive trusted and scalable analytical assets ## Description * Seeking an experienced Data ModelerData Architect to design businessready data solutions with a strong focus on semantic modeling multidimensional modeling and consumptionlayer architecture The ideal candidate will excel at integrating stitching data from multiple sources into scalable trusted and analyticsready data models, * Design and implement semantic and dimensional data models supporting enterprise analytics and reporting * Develop and maintain GoldConsumption layer data products within a Medallion Architecture * Translate business requirements into scalable reusable data models and semantic layers * Collaborate with business analytics and engineering teams to enable selfservice reporting and data consumption * Support data governance quality and CICD deployment processes for semantic models