Data Engineer

tastytrade; 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

Donation matching

Daily catered lunch

Kitchen with snacks & beverages

Metra shuttle

Job summary

tastytrade is seeking a Data Engineer to join the Analytics team in Chicago. You will own data pipeline architecture, mentor teammates, and influence how we build our data platform.

You’ll collaborate with data scientists, engineers, analysts, and leadership to design scalable pipelines and deliver actionable insights. You will work with Snowflake, dbt, Airflow, Tableau, Python, and AWS, contributing to data quality, observability, and production-grade code.

Qualifications

• 2-5 years of professional data engineering experience.
• Expert SQL skills and query optimization.
• Real dbt production experience.
• Python production-grade coding, not scripts.
• Hands-on Airflow experience (or Prefect/Dagster).
• Experience with Snowflake, BigQuery, or Redshift.
• Knowledge of data product lifecycle and data quality.
• Ability to design systems and lead projects.
• Strong communication with engineers and non-engineers.
• Git/GitHub and CLI proficiency.

Responsibilities

• Design and build scalable data pipelines with dbt, Python, Airflow, and Snowflake to support executive dashboards.
• Own pipeline architecture and performance; drive initiatives to improve the data platform.
• Make architectural decisions including schema design and tool selection.
• Own data quality and observability; build reliable data infrastructure.
• Write ELT code with modern practices and automated deployments.
• Debug production data issues as they arise.
• Process, clean, and validate data from diverse sources.
• Lead ad-hoc analyses to help teams understand product usage.

Skills

SQL

dbt

Python

Airflow

Data modeling

Git

Cloud data warehouse

Tools

Snowflake

BigQuery

Redshift

Tableau

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 an additional paid vacation day the 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 of thinkorswim, acquired by London-based IG Group in 2021, we combine startup innovation with the backing of a FTSE 100 fintech operating across 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, with tasty live providing content to educate our customers. tastyfx is the fastest-growing forex broker in the US. tasty crypto provides self-custody digital wallets for decentralized finance.

We're a lean, collaborative team that values autonomy, pragmatism, and impact. Whether you're building technology, creating content, serving customers, or supporting operations, you'll work 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-thinking mindset and we'll give 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.