Snowflake Data Engineer

Ethereum Technologies; Chicago (IL); On-site; USD 88,000 - 125,000; Full time

Job summary

Ethereum Technologies in Chicago, IL seeks a Snowflake Data Engineer to own data management and Snowflake solutions. You will work with the engineering team to design, implement, test and maintain data pipelines, warehouses and analytics workflows.

The role requires 5+ years of Snowflake and SQL/Python experience, strong troubleshooting, and collaboration across teams. Knowledge of pharma data or omni‑channel data is a plus. This contract role is based in Chicago with a 10-month duration.

Qualifications

• At least 5+ years' experience working on Snowflake Platform.
• Strong hands-on SQL and Python development.
• Experience with designing and development data warehouses in Snowflake.
• Ability to diagnose and tune SQL queries - Azure Data Framework (Azure Data Factory, etc.) knowledge is needed.
• Strong hands-on experience with Orchestration Tools e.g. Airflow, Informatica, Atomic.
• Good understanding on Metadata and data lineage.
• Hands-on knowledge on SQL Analytical functions.
• Shell scripting and Java Scripting experience.
• Familiarity with Git, Confluence and Jira.
• Good problem solving and troubleshooting skills.
• Team player with collaborative communication.

Responsibilities

• Develop, oversee, organize, store, and analyze data and data systems.
• Participate in all phases of the software development lifecycle for Snowflake solutions.
• Collaborate with engineering to implement optimal data solutions.
• Ensure platform performance, uptime and scalable design.
• Troubleshoot incidents, identify root causes, and document fixes.
• Manage deliverables in fast-paced environments.
• Pharma domain and omni-channel data experience is a plus.

Skills

Snowflake platform

SQL development

Python development

Metadata and data lineage

Shell scripting

Java scripting

Tools

Airflow

Informatica

Atomic

Job description

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

Job Title: Snowflake Data Engineer
Location: Chicago, IL
Duration: 10 Months
Bill Rate: $77/hour (C2C)
Job Type: W-2, 1099, C2C
Client: To Be Discussed Later
Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Description

Experienced Data management specialist responsible for developing, overseeing, organizing, storing, and analyzing data and data systems

Participate in all aspects of the software development lifecycle for Snowflake solutions, including planning, requirements, development, testing, and quality assurance

Work in tandem with our engineering team to identify and implement the most optimal solutions

Ensure platform performance, uptime, and scale, maintaining high standards for code quality and thoughtful design

Troubleshoot incidents, identify root causes, fix and document problems, and implement preventive measures

Able to manage deliverables in fast paced environments

Experience with Pharma domain and Omni-channel data is a plus.

Required Skills and Experience

At least 5+ years' experience working on Snowflake Platform

Strong hands-on SQL and Python development

Experience with designing and development data warehouses in Snowflake

Ability to diagnose and tune SQL queries - Azure Data Framework (azure data factory, etc.) knowledge is needed

Strong hands-on experience with Orchestration Tools e.g. Airflow, Informatica, Atomic

Good understanding on Metadata and data lineage

Hands-on knowledge on SQL Analytical functions

Strong knowledge and hands-on experience in Shell scripting, Java Scripting

Good understanding and exposure to Git, Confluence and Jira

Good problem solving and troubleshooting skills.

Team player, collaborative approach and excellent communication skills

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.