Lead Data Modeller

Capgemini • New York, NY

6d • $125,000 - $135,000

About The Position

Capgemini is seeking an experienced Data Modeler/Data Architect to design business-ready data solutions, with a strong focus on semantic modeling, multidimensional modeling, and consumption-layer architecture. The role involves integrating data from multiple sources into scalable, trusted, analytics-ready models and delivering business-ready semantic models and consumption layers.

Requirements

• At least 8 years of overall experience in Data Modeling, Data Architecture, or Data Engineering.
• At least 5 years of hands-on experience designing dimensional models, including star/snowflake schemas, and semantic models for data consumption.
• At least 3 years of experience with Snowflake in enterprise-scale environments.
• Proven experience designing and implementing Gold/Consumption layer solutions within a Medallion Architecture.
• Strong SQL skills, including experience developing and optimizing complex analytical datasets.
• Experience integrating data from multiple source systems into unified business-ready models.
• Demonstrated ability to work directly with business stakeholders to define metrics, dimensions, hierarchies, and semantic models.

Nice To Haves

• At least 2 years of Python development experience.
• Experience with DevOps/CI/CD practices and version-controlled deployments.
• Experience with YAML-based semantic modeling frameworks.
• Knowledge of Snowflake query tuning and performance optimization.

Responsibilities

• Design and implement semantic and dimensional data models that support enterprise analytics and reporting.
• Develop and maintain Gold/Consumption 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 self-service reporting and data consumption.
• Support data governance, data quality, and CI/CD deployment processes for semantic models.
• Integrate data from multiple source systems into unified, business-ready models.
• Work with business stakeholders to define metrics, dimensions, hierarchies, and semantic models.

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed