Senior Snowflake Data/AI Engineer

Senior Snowflake Data and AI Engineer role in a billable, client-facing consulting engagement in Minneapolis, focused on building governed AI and data solutions on the Snowflake AI Data Cloud.

Responsibilities

Design and implement scalable

incremental data pipelines

using Snowflake features such as

Dynamic Tables ,

Streams ,

Tasks ,

Snowpipe Streaming , and

Openflow .

Develop and optimize

ELT workflows

with

Snowpark ,

dbt Projects on Snowflake , and

SQL , emphasizing declarative, serverless transformations.

Build

AI-powered data applications

using

Cortex AISQL functions ,

Cortex Search , and

Cortex Analyst

to work with structured, unstructured, and multimodal data.

Use

Snowflake Cortex Code

to accelerate development, debugging, and optimization for SQL and Python.

Implement

data governance and security , including

role-based access control ,

row-level security ,

dynamic data masking , and

tags .

Perform

performance tuning

and

cost optimization

across queries, warehouses, and ingestion; support migration of client workloads into Snowflake.

Provide

technical mentorship

and

code reviews ; serve as a trusted advisor to client and internal teams.

Requirements

Bachelor’s or Master’s degree

in Computer Science, Information Systems, Data Engineering, or a related field, or

equivalent experience .

5+ years

of data engineering experience, including

3+ years hands‑on

with

Snowflake .

Advanced

SQL development

with strong

performance tuning ; strong proficiency in

Python

and

Snowpark

experience strongly preferred.

Hands‑on experience with modern Snowflake pipeline capabilities:

Dynamic Tables ,

Streams and Tasks ,

Snowpipe

and

Snowpipe Streaming , and

Openflow

or comparable tooling.

Practical experience with

Snowflake Cortex AI , including

Cortex AISQL functions ,

Cortex Search , or

Cortex Analyst , or demonstrated ability to rapidly build

LLM and RAG

solutions.

Experience using

AI-assisted development tools

to accelerate engineering work.

Experience with

ELT

and transformation tooling such as

dbt ,

Matillion ,

Informatica , or

Talend .

Solid understanding of at least one cloud platform:

AWS ,

Azure , or

GCP , plus strong

data modeling

skills.

Consulting or client-facing experience

with

excellent communication skills .

Technologies

Snowflake; Snowflake Cortex AI; Snowflake Cortex AISQL; Cortex Search; Cortex Analyst; Snowflake Cortex Code

Dynamic Tables; Streams; Tasks; Snowpipe Streaming; Openflow; Snowpark

dbt Projects on Snowflake; SQL; Python

LLM; RAG; ELT

dbt; Matillion; Informatica; Talend

AWS; Azure; GCP

Role-based access control; Row-level security; Dynamic data masking; Tags

Incremental data pipelines; Data ingestion; Warehouses

Position details

Based in the

CGI Minneapolis office .

Onsite

work location: Minneapolis, MN.

Billable, client-facing consulting role .

Pairs deep data engineering expertise with hands‑on use of

Snowflake Cortex AI

to bring

generative AI to governed client data .

#J-18808-Ljbffr