Sr. AI & Data Engineer – Snowflake

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 is collaborating with Accenture to connect them with exceptional professionals for this role.

We Are

The Advanced Technology Centers (ATCs) is the engine for reinvention in our clients’ transformation journey. Powered by more than 255,000* people across 24 countries, ATCs will provide our clients seamless access to industry insights and innovative technology solutions.

Stronger together!

The Advanced Technology Centers (ATCs) make tremendous impact in solving our clients’ business problems leveraging Innovation, Intelligence, Industry insights, new IT and new technology skills. Now, with the global environment changing at a faster pace, our clients are facing unprecedented challenges and they need us more than ever before. As a Network, ATCs are positioned to unlock greater opportunities and exponential value for our clients.

The value for our clients and our people

For our clients, the Network provides the strength of our geographic diversity, greater resilience, and seamless access to the deepest industry knowledge, the latest in Gen AI solutions, and tech expertise from around the world.

For our people, it brings an opportunity to shape truly boundaryless career paths in a highly collaborative team of experts where they can learn from each other and solve the world’s most complex client challenges.

You Are

A best in class, hands -on Snowflake Data & Analytics Engineer with deep expertise in building modern, cloud native data solutions. You will design, build, and operationalise enterprise-grade data and agentic AI solutions on the Snowflake AI Data Cloud. You will own the full lifecycle of Snowflake-native data products and agentic AI systems — from architecture and ingestion through to production deployment, governance, and continuous improvement.

You are curious, detail oriented, and passionate about writing clean, efficient code. You thrive in fast paced environments and are motivated by solving hard data problems that unlock business value.

The Work

There will never be a typical day and that’s why people love it here. The opportunities to make a difference within exciting client initiatives are unlimited in the ever-changing technology landscape. You will be part of a highly collaborative and growing network of technology and data experts, who are taking on today’s biggest, most complex business challenges using the latest data and analytics technologies. We will nurture your talent in an inclusive culture that values diversity. You will have an opportunity to work in a variety of roles covering all aspects of Data Engineering including Data Modelling, Data Integration, Data Analytics, Pipeline Development, Agentic AI, RAG, Cloud and Infrastructure integration, Data Quality, Observability & Governance.

Key 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

This is a hybrid role and will require three days per week in the office. Hiring locations: Dallas, TX; Houston, TX; Columbus, OH; Atlanta, GA or Tampa, FL.

What You Need

• A minimum of three years of professional experience in data engineering including experience building agentic AI or LLM-powered applications — including RAG pipelines, tool-use agents, and prompt engineering — in an enterprise context.
• A minimum of three years of professional experience with Snowflake-native features: Snowpark (Python), Dynamic Tables, Streams & Tasks, Snowpipe, Cortex AI suite, and performance tuning.
• A minimum of three years of experience with Python (data engineering and ML workloads) and advanced SQL.
• Bachelor's degree or equivalent (minimum 12 years) work experience. (If Associate Degree, must have minimum 6 years work experience)

Preferred

• Experience with data modelling methodologies and dbt for transformation layer management.
• Familiarity with at least one major cloud platform (AWS, Azure, or GCP) and associated services (object storage, IAM, networking, managed compute).
• Experience implementing data governance, security policies, and compliance frameworks on cloud data platforms.
• Bachelor's degree in Computer Science, Software Engineering, Data Science, or a related quantitative discipline; equivalent experience considered.
• Strong problem solving skills, attention to detail, and the ability to work effectively in agile, cross functional teams.
• Snowflake SnowPro Advanced certification (Data Engineer or Architect) or Cortex AI practitioner credentials.
• Experience with vector databases (e.g., Snowflake Vector Search, Pinecone, Weaviate) and embedding models (e.g., Snowflake Arctic Embed).
• Hands-on experience with MLOps tooling: model registries, evaluation pipelines, experiment tracking, and monitoring in production.
• Familiarity with MCP (Model Context Protocol) and enterprise agentic control plane architectures.
• Exposure to streaming technologies (Apache Kafka, Kinesis) integrated with Snowflake ingestion pipelines.

Benefits

Accenture offers a market competitive suite of benefits including medical, dental, vision, life, and long-term disability coverage, a 401(k) plan, bonus opportunities, paid holidays, and paid time off. See more information on our benefits here:

U.S. Employee Benefits | Accenture

Role Location Annual Salary Range

California $70,350 to $205,800

Colorado $63,800 to $177,800

Connecticut $63,800 to $177,800

District of Columbia $68,000 to $189,300

Illinois $59,100 to $177,800

Maine $54,400 to $151,400

Maryland $63,800 to $177,800

Massachusetts $63,800 to $189,300

Minnesota $63,800 to $177,800

New York $66,300 to $205,800

New Jersey $68,000 to $205,800

Ohio $59,100 to $164,600

Virginia $59,100 to $189,300

Washington $80,200 to $189,300

About Accenture

Accenture is a leading global professional services company that helps the world’s leading businesses, governments and other organizations build their digital core, optimize their operations, accelerate revenue growth and enhance citizen services—creating tangible value at speed and scale. We are a talent- and innovation-led company with approximately 791,000 people serving clients in more than 120 countries. Technology is at the core of change today, and we are one of the world’s leaders in helping drive that change, with strong ecosystem relationships. We combine our strength in technology and leadership in cloud, data and AI with unmatched industry experience, functional expertise and global delivery capability. Our broad range of services, solutions and assets across Strategy & Consulting, Technology, Operations, Industry X and Song, together with our culture of shared success and commitment to creating 360° value, enable us to help our clients reinvent and build trusted, lasting relationships. We measure our success by the 360° value we create for our clients, each other, our shareholders, partners and communities.

What We Believe

We have an unwavering commitment to diversity with the aim that every one of our people has a full sense of belonging within our organization. As a business imperative, every person at Accenture has the responsibility to create and sustain an inclusive environment.

Inclusion and diversity are fundamental to our culture and core values. Our rich diversity makes us more innovative and more creative, which helps us better serve our clients and our communities.

Read more here

Requesting An Accommodation

Accenture is committed to providing equal employment opportunities for persons with disabilities or religious observances, including reasonable accommodation when needed. If you are hired by Accenture and require accommodation to perform the essential functions of your role, you will be asked to participate in our reasonable accommodation process. Accommodations made to facilitate the recruiting process are not a guarantee of future or continued accommodations once hired.

If you would like to be considered for employment opportunities with Accenture and have accommodation needs such as for a disability or religious observance, please call us toll free at 1 [phone] or send us an email or speak with your recruiter.

Equal Employment Opportunity Statement

We believe that no one should be discriminated against because of their differences.All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, military veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by applicable law.Our rich diversity makes us more innovative, more competitive, and more creative, which helps us better serve our clients and our communities.

Other Employment Statements

Applicants for employment in the US must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the United States.

Candidates who are currently employed by a client of Accenture or an affiliated Accenture business may not be eligible for consideration.

Job candidates will not be obligated to disclose sealed or expunged records of conviction or arrest as part of the hiring process. Further, at Accenture a criminal conviction history is not an absolute bar to employment.

The Company will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. Additionally, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the Company’s legal duty to furnish information.

California requires additional notifications for applicants and employees. If you are a California resident, live in or plan to work from Los Angeles County upon being hired for this position, please click here for additional important information.

Please read Accenture’s Recruiting and Hiring Statement for more information on how we process your data during the Recruiting and Hiring process.