Senior Snowflake Data Engineer: Scale Data Warehouses

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

Job summary

Valiant Technologies LLC in Chicago, IL seeks an experienced Snowflake Data Engineer to develop, manage, and optimize Snowflake data solutions across the lifecycle. You will work with engineers to design scalable data pipelines, ensure performance, and maintain data quality in fast-paced projects.

The role requires 5+ years of Snowflake experience, strong SQL/Python skills, and familiarity with data warehousing, metadata, and orchestration tools.

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

Responsibilities

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

Skills

Snowflake Platform

SQL

Python

Data Warehousing

Azure Data Factory

Airflow

Informatica

Atomic

Git

Confluence

Jira

Shell Scripting

Java Scripting

Tools

Airflow

Informatica

Atomic

Git

Confluence

Jira

Job description

Valiant Technologies LLC in Chicago, IL seeks an experienced Snowflake Data Engineer to develop, manage, and optimize Snowflake data solutions across the lifecycle. You will work with engineers to design scalable data pipelines, ensure performance, and maintain data quality in fast-paced projects.

The role requires 5+ years of Snowflake experience, strong SQL/Python skills, and familiarity with data warehousing, metadata, and orchestration tools.