Senior Data Engineer

Robotic Process Automation LLC; United States; Remote; USD 102,000 - 146,000; Full time

Job summary

Robotic Technologies Automation seeks a Senior Data Engineer to design and maintain scalable data infrastructure for analytics, self-service reporting, and AI-powered applications.

You will work with Snowflake, Python, SQL, and dbt, building robust data pipelines and dimensional models. Responsibilities include implementing Cortex components, developing AI agents, and managing CI/CD through GitHub Actions and Snowflake CLI. Remote role for US-based candidates.

Qualifications

• 8+ years of Senior Data Engineering experience.
• Experience with Snowflake Cortex Agents, Analyst, and Search.
• Proficiency in Python, SQL, and dbt with AI/LLM agent development.

Responsibilities

• Design and develop scalable data solutions using Snowflake, SQL, and dbt.
• Implement Snowflake Cortex Agents, Cortex Analyst, and Cortex Search.
• Develop LLM-based agents and integrate AI solutions using Snowflake MCP.

Skills

Snowflake Cortex Agents

Python programming

SQL

dbt

LLM/AI agent development

Star Schema

GitHub Actions

Snowflake MCP

Snowpark

CI/CD

Tools

Snowflake CLI

Snowpark Container Services

Docker

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title: Senior Data Engineer
Location: Remote (USA)
Duration: 6+ Months Contract
Bill Rate: $90/hr
Job Type: W-2, 1099, C2C
Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Summary:

We are seeking an experienced Senior Data Engineer with strong expertise in Snowflake, Python, SQL, and dbt. The candidate will develop and maintain scalable data infrastructure supporting analytics, self-service reporting, and AI-powered applications.

Key Responsibilities:

• Design and develop scalable data solutions using Snowflake, SQL, and dbt.
• Implement Snowflake Cortex Agents, Cortex Analyst, and Cortex Search.
• Develop LLM-based agents and integrate AI solutions using Snowflake MCP.
• Build and maintain Snowpark Python stored procedures.
• Develop dimensional data models using Star Schema and Kimball methodologies.
• Create and maintain semantic models and database views.
• Manage CI/CD pipelines and deployments using GitHub Actions and Snowflake CLI.
• Work with Docker, Snowpark Container Services, and compute pools.
• Handle Jira stories from requirements gathering through development, testing, code review, and production deployment.
• Troubleshoot production issues and maintain data quality.

Required Skills:

• 8+ years of Senior Data Engineering experience.
• Strong hands‑on experience with Snowflake Cortex Agents, Analyst, and Search.
• Knowledge of Snowflake MCP and Snowpark.
• Strong Python programming and LLM/AI agent development experience.Advanced SQL and dbt development skills.
• Experience with dimensional modeling, facts, dimensions, and Star Schema.
• GitHub, GitHub Actions, and Snowflake CLI.
• CI/CD and Dev-to-Production deployment experience.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.