Lead Data Engineer - Snowflake

Capgemini; Atlanta (GA); On-site; USD 165,000 - 190,000; Full time

Benefits offered by this job

Paid time off

Health insurance

Retirement savings plan

Life and disability insurance

Employee assistance program

Job summary

Capgemini is seeking a Lead Data Engineer to spearhead enterprise-scale Data and AI platform engineering on Snowflake in Atlanta, GA. The role focuses on designing, building, and optimizing unified platform capabilities, governed data environments, and Snowflake-powered AI and ML enablement.

The candidate will design and implement enterprise-wide data platforms, develop scalable data models, and build high-performance ELT pipelines.

Qualifications

• Bachelor's degree in Computer Science, Engineering, Information Systems, or a 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.

Responsibilities

• Design and implement enterprise-wide Unified Data & AI Platforms leveraging Snowflake.
• Architect and develop scalable Medallion Layer data models across Bronze, Silver, and Gold.
• Build and maintain high-performance ELT pipelines using Snowflake Dynamic Tables, dbt, Tasks & Stored Procedures, Snowpipe, and Snowflake Openflow Connect.
• Develop AI-powered solutions using Snowflake Cortex ecosystem including Cortex Analyst, Cortex Search, Cortex Agents, Snowpark ML, Python, Streamlit, and MLOps frameworks.
• Design and implement secure, governed data environments using Snowflake Horizon.
• Establish and maintain RBAC and ABAC frameworks.

Skills

Data engineering

Data architecture

Analytics engineering

Stakeholder mgmt

Education

Bachelor's degree

Tools

Snowflake

dbt

Snowpipe

Tasks & Stored Procedures

Snowflake Openflow Connect

Cortex Analyst

Cortex Search

Cortex Agents

Snowpark ML

Python

Streamlit

MLOps

Git

AWS

CI/CD

Job description

Capgemini is seeking a Lead Data Engineer to spearhead enterprise-scale Data and AI platform engineering on Snowflake. This onsite role in Atlanta, GA focuses on designing, building, and optimizing unified platform capabilities, governed data environments, and Snowflake-powered AI and ML enablement.

Responsibilities

• Design and implement enterprise-wide Unified Data & AI Platforms leveraging Snowflake.
• Architect and develop scalable Medallion Layer data models and frameworks across Bronze, Silver, and Gold.
• Build and maintain high-performance ELT pipelines using Snowflake Dynamic Tables, dbt, Tasks & Stored Procedures, Snowpipe, and Snowflake Openflow Connect.
• Develop AI-powered solutions using the Snowflake Cortex ecosystem, including Cortex Analyst, Cortex Search, Cortex Agents, Snowpark ML, Python, Streamlit, and 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, 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.

Requirements

• Bachelor's degree in Computer Science, Engineering, Information Systems, or a 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.
• Proven expertise in Medallion architecture implementation.
• Proven expertise in ELT/ETL pipeline development.
• Proven expertise in data warehousing and data lake concepts.
• Deep experience with Snowflake Dynamic Tables, dbt, Snowpipe, Tasks, and Stored Procedures.
• Deep experience with Openflow Connect.
• Hands-on experience with Snowflake AI and ML capabilities: Cortex Analyst, Cortex Search, Cortex Agents, Snowpark ML, Streamlit, Python, and MLOps practices.
• Strong understanding of Snowflake security and governance capabilities, including Horizon.
• Experience implementing RBAC and ABAC security models.
• Experience with Git-based source control and modern ELT frameworks.
• Strong cloud platform experience with AWS.
• Excellent communication, stakeholder management, and problem-solving skills.

Key Technologies

• Snowflake
• Snowflake Dynamic Tables
• dbt
• Tasks, Stored Procedures, Snowpipe
• Snowflake Openflow Connect
• Snowflake Cortex ecosystem (Cortex Analyst, Cortex Search, Cortex Agents)
• Snowpark ML, Python, Streamlit
• MLOps frameworks
• Snowflake Horizon
• RBAC, ABAC
• CI/CD, Git
• AWS

Compensation and Location

Location: Atlanta, GA (onsite). Salary: USD 165,000 - 190,000 per year.

Benefits

• Paid time off based on employee grade (A-F): Vacation 12-25 days depending on grade, plus company paid holidays, personal days, and sick leave.
• Medical, dental, and vision coverage (or provincial healthcare coordination in Canada).
• Retirement savings plans (for example, 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.