Senior Snowflake AI & Data Engineer - Hybrid

Archer; Irving (TX); Hybrid; USD 140,000 - 190,000; Full time

Benefits offered by this job

Medical, dental, vision, life

401(k)

Bonus opportunities

Paid holidays

Paid time off

Job summary

Archer, in collaboration with Accenture, is seeking a Snowflake Data & Analytics Engineer to design, build, and operate enterprise-grade data solutions on the Snowflake AI Data Cloud. You will own end-to-end data products, governance, and AI workflows in a hybrid environment.

You will work across data modelling, integration, and analytics, using Snowflake, Cortex, and orchestration tools to deliver scalable pipelines and AI-enabled insights for complex client initiatives.

Qualifications

• Three years of professional data engineering experience including agentic AI or LLM-powered apps.
• Experience with Snowflake-native features: Snowpark (Python), Dynamic Tables, Streams & Tasks, Snowpipe, Cortex AI suite, and performance tuning.
• Three years of experience with Python (data engineering and ML workloads) and advanced SQL.
• Bachelor's degree or equivalent (minimum 12 years) work experience.

Responsibilities

• Architect and maintain a scalable, governed Snowflake AI Data Cloud environment including compute optimisation, warehouse sizing, and cost management.
• Design and implement ELT/ETL frameworks using Snowflake SQL, Snowpark Python, Dynamic Tables, Streams, Tasks, and Snowpipe for batch, streaming, CDC, and event-driven ingestion patterns.
• Build reusable, AI-ready data products with clear ownership, semantic context, data quality SLAs, and lineage tracking.
• Implement enterprise security controls: RBAC/ABAC, column- and row-level security, dynamic data masking, classification tags, and audit logging.
• Integrate Snowflake with upstream source systems, orchestration platforms (e.g., dbt, Apache Airflow), governance tools, and downstream analytics consumers.
• Design and build multi-step agentic AI workflows using Snowflake Cortex Agents, Cortex AI Functions, Cortex Search, and Cortex Analyst.
• Develop production-grade Retrieval-Augmented Generation (RAG) pipelines with vector search, semantic retrieval, and hybrid search capabilities over governed Snowflake datasets.
• Implement tool-use orchestration, prompt engineering, and evaluation frameworks (LLMOps) for reliable, auditable AI agent behaviour.
• Apply agentic automation to operational use cases including anomaly detection, data quality remediation, query diagnosis, documentation generation, and incident summarisation.
• Integrate AI agents with enterprise systems via MCP (Model Context Protocol) connectors, REST APIs, and event-driven messaging architectures.
• Define and enforce data modelling standards (Kimball dimensional, Data Vault 2.0) to support analytics, ML feature stores, and AI consumption layers.
• Build and maintain semantic data models that expose governed, business-ready datasets to Cortex Analyst and BI tools

Skills

Agentic AI

RAG pipelines

Tool-use agents

Prompt engineering

Python

Advanced SQL

Snowflake

Snowpark

Dynamic Tables

Snowpipe

Cortex AI

Education

Bachelor's degree or equivalent (12+ years)

Tools

dbt

Apache Airflow

Job description

Archer, in collaboration with Accenture, is seeking a Snowflake Data & Analytics Engineer to design, build, and operate enterprise-grade data solutions on the Snowflake AI Data Cloud. You will own end-to-end data products, governance, and AI workflows in a hybrid environment.

You will work across data modelling, integration, and analytics, using Snowflake, Cortex, and orchestration tools to deliver scalable pipelines and AI-enabled insights for complex client initiatives.