Lead Data Engineer - Snowflake

About the role

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. About The Job You're Considering We are seeking an experienced Senior Snowflake Data & AI Platform Engineer to design, build, and optimize enterprise-scale Data & AI platforms on Snowflake. The ideal candidate will possess deep expertise in modern data architecture, Medallion data modeling, data engineering, AI/ML enablement, governance, and cloud-native platform development. This role will be instrumental in delivering scalable, secure, and business-centric data products while leveraging Snowflake's latest AI, analytics, and governance capabilities.

Responsibilities

• Design and implement enterprise-wide Unified Data & AI Platforms leveraging Snowflake.
• Architect and develop scalable Medallion Layer (Bronze, Silver, Gold) data models and frameworks.
• Build and maintain high-performance ELT pipelines utilizing: Snowflake Dynamic Tables, dbt, Tasks & Stored Procedures, Snowpipe, Snowflake Openflow Connect.
• Develop AI-powered solutions using the Snowflake Cortex ecosystem, including: Cortex Analyst, Cortex Search, Cortex Agents, Snowpark ML, Python, Streamlit, MLOps frameworks.
• Design and implement secure, governed data environments using Snowflake Horizon.
• Establish and maintain Role-Based Access Control (RBAC) and Attribute-Based Access Control (ABAC) frameworks.
• Collaborate with business and technology teams to develop customer-centric and domain-oriented data products.
• Implement CI/CD processes and Git-integrated development workflows.
• Monitor, optimize, and improve platform performance, scalability, and cost efficiency.
• Partner with architects, data scientists, analysts, and business stakeholders to deliver data-driven solutions.
• Ensure adherence to security, governance, compliance, and data quality standards.

Skills

• Bachelor's degree in Computer Science, Engineering, Information Systems, or related field.
• 7+ years of experience in Data Engineering, Data Architecture, or Analytics Engineering.
• Strong hands-on experience designing and implementing data platforms on Snowflake.
• Proven expertise in: Unified Data & AI platform architecture, Medallion architecture implementation, ELT/ETL pipeline development, Data warehousing and data lake concepts.
• Deep experience with: Snowflake Dynamic Tables, dbt, Snowpipe, Tasks, Stored Procedures, Openflow Connect.
• Hands-on experience with Snowflake AI and ML capabilities: Cortex Analyst, Cortex Search, Cortex Agents, Snowpark ML, Streamlit, Python, MLOps practices.