Lead Data Engineer - Snowflake

Capgemini is seeking an experienced Lead Data Engineer to help design and deliver enterprise-scale Data & AI platforms on Snowflake. In this onsite Atlanta role, you will take a lead role in building unified platform capabilities, improving performance and cost efficiency, and enabling data products that teams can use to power analytics and AI use cases.

Location: Atlanta, GA (onsite)
Compensation: USD 165,000 - 190,000 per year
Experience: 7+ years
Education: Bachelor’s degree in Computer Science, Engineering, Information Systems, or related field

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 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 RBAC (Role-Based Access Control) and ABAC (Attribute-Based Access Control) frameworks.
• Collaborate with business and technology teams to build 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 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, Stored Procedures, and 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, governance, and data management 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.

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

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., RRSP in Canada)
• Life and disability insurance
• Employee assistance programs
• Other benefits as provided by local policy and eligibility