Senior Data Engineer

Valiant Technologies LLC; United States; Remote; USD 102,000 - 146,000; Full time

Job summary

Valiant Technologies LLC is seeking a Senior Data Engineer to design and operate scalable data platforms using Snowflake, Python, SQL, and dbt. You will implement Cortex components, develop LLM-based agents, and integrate AI solutions with Snowflake MCP.

Responsibilities include building dimensional models, semantic layers, and managing CI/CD with GitHub Actions, Snowflake CLI, and container tooling. Strong SQL/DBT skills and an 8+ year track record are required.

Qualifications

• 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.

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.

Skills

Senior Data Engineering experience

Python programming

LLM/AI agent development

SQL

dbt development

Dimensional modeling

CI/CD deployment

Tools

Snowflake Cortex Agents

Snowflake Cortex Analyst

Snowflake Cortex Search

Snowflake MCP

Snowpark

Snowpark Python stored procedures

GitHub

GitHub Actions

Snowflake CLI

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.