Data Engineer - Hybrid Chicago: Build Scalable Pipelines

tastytrade, Inc.; Chicago (IL); Ibrido; USD 130.000 - 150.000; Tempo pieno

Vantaggi offerti da questo lavoro

Performance Bonuses

Stock Purchase Options

401k Plan

20 Paid Vacation Days

10 Paid Sick Days

Pet Insurance

Wellness & Mental Health Programs

Charitable Donation Matching

Daily catered lunch

Full kitchen with snacks and beverages

Shuttle to Metra

Descrizione del lavoro

tastytrade, Inc. in Chicago is seeking a Data Engineer to own data pipeline architecture within the Analytics team.

You will design scalable pipelines using dbt, Python, Airflow, and Snowflake, and drive data quality and observability across our data platform. You will collaborate with data scientists, engineers, and analysts to ship, iterate, and upskill peers, while interfacing with Tableau visuals and upstream/downstream teams.

Competenze

• 2-5 years of professional data engineering experience.
• Expert SQL skills with ruthless query optimization.
• Real dbt production work experience.
• Solid Python written for production use.
• Hands-on Airflow experience (or Prefect/Dagster).
• Experience with a cloud data warehouse (Snowflake/BigQuery/Redshift).
• Strong communication with engineers and non-engineers.
• Proficient with Git and CLI.

Mansioni

• Design and build scalable data pipelines with dbt, Python, Airflow, and Snowflake.
• Own pipeline architecture, performance, and data quality observability.
• Make architectural decisions including schema design and tool selection.
• Write ELT code with modern best practices and automated tests.
• Collaborate with upstream/downstream teams and contribute to Tableau visuals.
• Lead projects and upskill teammates through code reviews and design collaboration.
• Improve performance and processes within the data platform.

Conoscenze

SQL

dbt

Python

Airflow

Git

Strumenti

Snowflake

BigQuery

Redshift

Kubernetes

Descrizione del lavoro

tastytrade, Inc. in Chicago is seeking a Data Engineer to own data pipeline architecture within the Analytics team.

You will design scalable pipelines using dbt, Python, Airflow, and Snowflake, and drive data quality and observability across our data platform. You will collaborate with data scientists, engineers, and analysts to ship, iterate, and upskill peers, while interfacing with Tableau visuals and upstream/downstream teams.