Data Engineer / GCP / Snowflake / Airflow / DBT / Hybrid / Chicago IL

Data Engineer / GCP / Snowflake / Airflow / DBT / Hybrid / Chicago IL

A PE-backed leader in supplier intelligence is seeking a Data Engineer to support a major technology modernization initiative. With 170 employees across the U.S., the organization is growing rapidly and making strategic investments in its data infrastructure. The platform drives procurement and supply chain decisions for some of the world's largest enterprises, leveraging more than 11 million supplier profiles, 350+ million data attributes, and $9 trillion in historical spend. Tech stack includes Snowflake, GCP, Python, SQL, Airflow, DBT, PySpark, Docker, MySQL, and PostgreSQL.

This is an exciting opportunity to play a key role in transforming how enterprise-scale supplier data is processed and delivered. You'll join a forward-thinking engineering team spearheading the migration from legacy systems to Snowflake and architecting scalable, automated data ingestion pipelines on GCP to power the company's accelerating growth. The role is primarily hands-on, with opportunities to influence architectural decisions and mentor junior engineers. This is an ideal opportunity for a mid-level data engineer who wants ownership over impactful projects, direct exposure to modern cloud-native tools, and a clear path to career growth.

Responsibilities

• Hands-on development of data pipelines, ingestion, and automation (approximately 80%).
• Contribute to architecture, design decisions, and data infrastructure improvements (approximately 10%).
• Mentor junior engineers and collaborate with cross-functional teams (approximately 10%).
• Work with Snowflake, GCP, Python, SQL, Airflow, DBT, PySpark, Docker, MySQL, and PostgreSQL as part of daily tasks.

Required Skills & Experience

3–5 years of professional data engineering experience

Expertise in Snowflake

Proficiency in Python and SQL

Experience with Airflow and DBT

PySpark knowledge for distributed data processing

Docker and containerization experience

Familiarity with MySQL or PostgreSQL

Cloud experience (GCP preferred; AWS / Azure acceptable)

Ability to troubleshoot and resolve issues independently

Strong communication skills for cross-functional collaboration

Preferred / Desired Skills & Experience

Experience with SSIS or legacy ETL tools (helpful but not required)

Background in distribution, supply chain, or supplier-related industries

Mentorship experience with junior engineers

Exposure to orchestration strategy design and optimization

Agile team experience with Jira

What You Will Be Doing

Tech Breakdown :

40% Python

25% SQL and relational databases (MySQL, PostgreSQL)

20% Orchestration (Airflow, DBT)

15% Distributed processing (PySpark)

Daily Responsibilities

80% Hands-On Development (data pipelines, ingestion, automation)

10% Architectural input and design

10% Mentorship and team collaboration

Benefits

Medical, Dental, and Vision Insurance

PTO / Vacation time

Hybrid work model

Career growth and promotion potential

Applicants must be currently authorized to work in the US on a full-time basis now and in the future.

J-18808-Ljbffr