Senior Snowflake Data & AI Engineer — Governed AI Pipelines

CGI Group, Inc.; Minneapolis (MN); On-site; USD 150,000 - 190,000; Full time

Job summary

CGI Group, Inc. in Minneapolis is seeking a Senior Snowflake Data and AI Engineer for a billable client‑facing engagement. You will design scalable data pipelines and governance strategies on the Snowflake AI Data Cloud, focusing on secure, efficient ELT and AI‑powered data applications.

You will work with Snowflake Cortex AI, Cortex Search, and Cortex Analyst, leveraging Snowpark and dbt to deliver governed data insights for diverse data sets in a consulting context.

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering, or equivalent experience.
• 5+ years of data engineering experience, including 3+ years hands‑on with Snowflake.
• Advanced SQL development with performance tuning; strong Python and Snowpark experience preferred.
• Hands‑on experience with Snowflake pipeline capabilities: Dynamic Tables, Streams, Tasks, Snowpipe/Snowpipe Streaming, Openflow.
• Experience with AI-powered data tools and Cortex family is a plus.
• Consulting or client-facing experience with strong communication skills.

Responsibilities

• Design scalable incremental data pipelines using Snowflake features like Dynamic Tables, Streams, Tasks, Snowpipe Streaming, and Openflow.
• Develop and optimize ELT workloads with Snowpark, dbt Projects, and SQL.
• Build AI-powered data apps using Cortex AISQL functions, Cortex Search, and Cortex Analyst for diverse data forms.
• Use Snowflake Cortex Code to accelerate SQL/Python development, debugging and optimization.
• Implement governance and security: RBAC, row-level security, dynamic data masking, and tagging.
• Performance tuning and cost optimization across warehouses and ingestion; migrate client workloads to Snowflake.
• Provide technical mentorship and code reviews for client and internal teams.

Skills

5+ years data engineering

3+ years Snowflake

Advanced SQL

Python

Snowpark

consulting/client-facing

excellent communication

Cloud platforms (AWS/Azure/GCP)

Education

Bachelor’s or Master’s degree in CS/IS/Data Eng

Tools

Snowflake

dbt

Snowpipe

Matillion

Informatica

Talend

Snowpark

Job description

CGI Group, Inc. in Minneapolis is seeking a Senior Snowflake Data and AI Engineer for a billable client‑facing engagement. You will design scalable data pipelines and governance strategies on the Snowflake AI Data Cloud, focusing on secure, efficient ELT and AI‑powered data applications.

You will work with Snowflake Cortex AI, Cortex Search, and Cortex Analyst, leveraging Snowpark and dbt to deliver governed data insights for diverse data sets in a consulting context.