Lead Data Engineer - Snowflake

Capgemini • Atlanta, GA

3d • $165,000 - $190,000

About The Position

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.

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, 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.
• 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.

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.

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: Senior