Senior Data Engineer

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

Job summary

Ethereum Technologies is seeking a Senior Data Engineer to architect scalable data platforms using Snowflake, Python, SQL, and dbt for analytics, self-service reporting, and AI-powered applications.

The role focuses on designing data solutions, implementing Snowflake Cortex components, building LLM-based agents, and managing CI/CD with GitHub Actions and Snowflake tooling in a containerized, cloud-based environment.

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

Snowflake Cortex Agents

Snowflake Cortex Analyst

Snowflake Cortex Search

Snowflake MCP

Snowpark

Python

LLM AI Agent Development

SQL

dbt

Dimensional Modeling

Star Schema

GitHub

GitHub Actions

Snowflake CLI

CI/CD

Dev to Production

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.