Data Engineering Tech Lead

The Snowflake Data Lead will design and implement enterprise-scale data solutions on Azure using Snowflake as the core data platform and Informatica IDMC CDI as the data integration platform. This role is central to enabling a modern data mesh or data product strategy, ensuring high-quality data products can be created, managed, and consumed efficiently for core business domains. The architect will collaborate with business domain owners, data engineers, product owners, analysts, and cloud teams to define standards and best practices for scalable, secure, and performant data architecture.

• Design and architect end-to-end Snowflake data solutions hosted on Microsoft Azure.
• Implement data product–oriented architectures leveraging domain-driven design and data mesh principles.
• Establish best practices for data acquisition, modeling, integration, governance, and consumption.
• Create and maintain data pipelines using Informatica IDMC - Cloud Data Integration (CDI, Snowflake Native ELT scripts, and other orchestration tools.
• Ensure data solutions align with governance frameworks, security policies, and compliance standards.
• Define reusable patterns, frameworks, and architectures for data products across business domains.
• Collaborate with data engineering teams to build performant ELT processes and optimize Snowflake compute usage.
• Collaborate closely with business and analytics teams to translate needs into scalable data models.
• Drive continuous improvement through automation, monitoring, and performance tuning.
• Use Generative AI and agentic solutions to accelerate data product development on Snowflake

• 10+ years in data architecture, data engineering and BI solution design roles.
• 5+ years of hands-on experience with Snowflake, including schema design, performance optimization, and security configuration.
• Strong Azure ecosystem experience as well as expertise in using Informatica IDMC CDI for building data integration pipelines
• Experience with Informatica Power Center, SSIS, SSRS platforms
• Life and Annuities industry domain experience
• Expertise in SQL, ELT/ETL design patterns, data modeling (dimensional and normalized), and CI/CD for data pipelines.
• Deep understanding of data mesh or data product principles and practical implementation experience.
• Proven ability to design solutions integrating structured, semi-structured, and unstructured data.
• Experience with Python, Spark is a plus.
• Experience with usage of Generative AI - Agentic and copilot solutions to accelerate data product development
• Strong cross-team communication and stakeholder alignment skills.
• Experience in Agile or product-driven data delivery environments.

Sogeti supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:

• Flexible work options
• 401(k) with 150% match up to 6%
• Employee Share Ownership Plan
• Life Insurance
• Adoption, Surrogacy & Cryopreservation Assistance
• Career Planning & Coaching
• $5,250 Tuition Reimbursement & 20,000+ Online Courses
• Employee Resource Groups
• Counseling & Support for Physical, Financial, Emotional & Spiritual Well-being
• Disaster Relief Programs

Part of the Capgemini Group, Sogeti makes business value through technology for organizations that need to implement innovation at speed and want a local partner with global scale. With a hands-on culture and close proximity to its clients, Sogeti implements solutions that will help organizations work faster, better, and smarter. By combining its agility and speed of implementation through a Dev Ops approach, Sogeti delivers innovative solutions in quality engineering, cloud and application development, all driven by AI, data and automation.

Become Your Best | (Use the "Apply for this Job" box below)..us

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.

This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.

Capgemini is committed to providing reasonable accommodation during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.

Please be aware that Capgemini may capture your image (video or screenshot) during the interview process and that…