Senior Data Modeller

Capgemini • New York, NY

3d

About The Position

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.Job DescriptionResponsibilities:
· Lead the design, development, and implementation of enterprise-scale data warehouse, reporting, and analytics solutions, preferably on cloud platforms such as Snowflake.· Drive the adoption and integration of GenAI, LLMs, and modern AI/ML techniques for ETL automation, data enrichment, reporting commentary, and intelligent data distribution across the enterprise.· Provide technical leadership and mentorship to a high-performing team of data engineers, fostering a culture of innovation, collaboration, and continuous improvement.· Collaborate with business stakeholders, technology partners, and cross-functional teams to define data strategy, requirements, and deliverables aligned with organizational goals.· Champion modern SDLC practices, including automated testing, CI/CD, and agile methodologies, to ensure high-quality, scalable, and maintainable solutions.· Drive automation, data quality, and best practices across all data engineering processes and solutions.· Ensure robust data governance, security, and compliance throughout the data lifecycle.· Manage stakeholder relationships, communicate project status, and proactively address risks and challenges.· Champion the adoption of new technologies and methodologies to enhance data capabilities and business value.

Requirements

• 10+ years of experience in data engineering, data architecture, or related roles, with a proven track record of delivering enterprise-level solutions.
• Deep expertise in SQL, data modelling, ETL, and building scalable data pipelines.
• Strong hands-on experience with cloud data platforms (preferably Snowflake) and modern data engineering tools.
• Strong hands-on experience with Python, Shell scripting, and workflow automation.
• Demonstrated experience leveraging GenAI, LLMs, or AI/ML solutions for enterprise data, reporting, and analytics use cases.
• Proven ability to lead, motivate, and develop high-performing teams.
• Strong domain and functional knowledge in finance, investment banking, or related industries.
• Excellent problem-solving, analytical, and communication skills.
• Experience managing stakeholder relationships and delivering complex projects in a global environment.
• Strong understanding of modern SDLC, agile delivery, and innovation in data engineering.

Nice To Haves

• Familiarity with Power BI, Apache Airflow, and OLAP tools.
• Exposure to regulatory and financial reporting requirements.
• Demonstrated track record of driving innovation and GenAI adoption in data engineering projects.
• Passion for continuous learning, business impact, and solution-oriented leadership.

Responsibilities

• Lead the design, development, and implementation of enterprise-scale data warehouse, reporting, and analytics solutions, preferably on cloud platforms such as Snowflake.
• Drive the adoption and integration of GenAI, LLMs, and modern AI/ML techniques for ETL automation, data enrichment, reporting commentary, and intelligent data distribution across the enterprise.
• Provide technical leadership and mentorship to a high-performing team of data engineers, fostering a culture of innovation, collaboration, and continuous improvement.
• Collaborate with business stakeholders, technology partners, and cross-functional teams to define data strategy, requirements, and deliverables aligned with organizational goals.
• Champion modern SDLC practices, including automated testing, CI/CD, and agile methodologies, to ensure high-quality, scalable, and maintainable solutions.
• Drive automation, data quality, and best practices across all data engineering processes and solutions.
• Ensure robust data governance, security, and compliance throughout the data lifecycle.
• Manage stakeholder relationships, communicate project status, and proactively address risks and challenges.
• Champion the adoption of new technologies and methodologies to enhance data capabilities and business value.

Benefits

• 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

What This Job Offers

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