Data Engineer

tastytrade, Inc.; Chicago (IL); Hybrid; USD 130,000 - 150,000; Full time

Benefits offered by this job

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

Job summary

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.

Qualifications

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

Responsibilities

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

Skills

SQL

dbt

Python

Airflow

Git

Tools

Snowflake

BigQuery

Redshift

Kubernetes

Job description

Location: Chicago, IL (Hybrid, 3 days/week)

About the Role

We’re looking for a Data Engineer to join our Analytics team. You’ll own data pipeline architecture, upskill those around you, and have real influence on how we build our data platform.

You’ll be part of a full stack data team of data scientists, data engineers, and analysts who take full ownership of our data pipelines and feature generation. This is a full-scope role: you’ll design systems, make tech decisions, ship, and iterate. If you have a good idea and can execute it, we’d love to learn from you.

Our team works with Snowflake, dbt, Airflow, Tableau, Python, AWS (S3, ECR, EKS), GitHub, ArgoCD, Elementary, and Grafana.

What You’ll Do

• Design and build scalable data pipelines using dbt, Python, Airflow, and Snowflake to support business processes, such as our executive reporting dashboards
• Own pipeline architecture and performance, and drive strategic initiatives to improve our data platform
• Make architectural decisions, including schema design, tool selection, and trade-offs
• Own data quality and observability, and build the infrastructure that keeps our data right
• Write ELT code using modern data engineering practices, including Git and automated testing and deployments
• Debug production data issues when they break (and they will)
• Process, clean, and validate data from a variety of external sources and internal data pipelines
• Lead ad-hoc analysis using internal and external data sources to help teams understand how customers interact with our products
• Collaborate with upstream data producers (Software Engineering/DevOps) and downstream data consumers (Marketing, Product, and Leadership)
• Contribute to data visualization and reporting efforts in Tableau
• Upskill those around you through code review, design collaboration, and knowledge sharing
• Optimize performance, improve processes, and level up team practices

Who You Are

• You have 2-5 years of professional data engineering experience
• You have expert SQL skills: you think in queries and optimize ruthlessly
• You have real dbt experience, meaning actual production work and not just exposure
• You write solid Python, with production code rather than scripts
• You have hands‑on experience with Airflow (or Prefect/Dagster)
• You have experience with a cloud data warehouse (Snowflake, BigQuery, or Redshift)
• You understand the data product lifecycle, standards, and practices
• You know your way around data quality functions like cleansing, standardization, parsing, and validation
• You can design systems and lead projects
• You communicate clearly with non-engineers and engineers alike
• You’re proficient with version control (Git/GitHub) and command line interfaces

Preferred Qualifications

• Kubernetes or infrastructure-as-code experience
• CI/CD and DevOps practices
• Advanced Airflow patterns and custom operators
• Experience with agile development practices and the project lifecycle

Company Perks + Benefits

• Performance Bonuses
• Stock Purchase Options
• 401k Plan
• 20 Paid Vacation Days (plus anadditionalpaid vacationdaythe month of your birthday!)
• 10 Paid Sick Days
• Pet Insurance
• Wellness & Mental Health Programs
• Charitable Donation Matching
• Daily catered lunch when in the office
• Full kitchen with snacks and beverages
• Shuttle to/from Metra

Base Salary Range

$130,000-$150,000 The actual salary offered will be based on the candidate's level of experience and qualifications.

Discretionary Performance Bonus

8-12% of base salary based on individual and company performance.

About IGNA+ tasty

IG North America is home to tastytrade,tasty live & tastyfx—a family of brands built to democratize trading and empower individual investors. Founded in Chicago by the creators ofthinkorswim,acquiredby London-based IG Group in 2021, we combine startup innovation with the backing ofaFTSE 100 fintechoperatingacross five continents serving over 1.3m customers and handling billions of dollars in transactions – built on scale, trust, and proof.

From our headquarters in Chicago's Fulton Market, our team builds award-winning trading platforms, produces live financial education content daily, and creates technology that makes complex markets accessible. tastytrade is our retail brokerage for self-directed investing and trading, withtasty live providing content to educate our customers. tastyfx is the fastest-growing forex broker in the US.tastycryptoprovides self-custody digital wallets for decentralized finance.

We'rea lean, collaborative team that values autonomy, pragmatism, and impact. Whetheryou'rebuilding technology, creating content, serving customers, or supporting operations,you'llwork alongside people who are passionate about disrupting traditional finance and genuinely care about helping traders succeed. Our culture rewards initiative, embraces experimentation, and measures success by the value we create for our users.The bar is high – bring a curious and forward-thinkingmindsetandwe'llgive you the platform to define what comes next. Join us at IG|tasty – the future gets built here.

Location:

Our office is in the West Loop - Chicago's growing center of tech, great cuisine, and high-end bars.