Data Engineer

tastylive•Chicago, IL

3d•$130,000 - $150,000•Hybrid

About The Position

tastytrade is hiring a Data Engineer to join its Analytics team. The role owns data pipeline architecture and performance, contributes to strategic improvements to the data platform, and works across the full data lifecycle—from system design and technical decisions through delivery and iteration. The Data Engineer will work with a full-stack data team of data scientists, engineers, and analysts, taking ownership of data pipelines and feature generation. The role uses Snowflake, dbt, Airflow, Tableau, Python, AWS (S3, ECR, and EKS), GitHub, ArgoCD, Elementary, and Grafana. It involves designing scalable pipelines to support business processes and executive reporting, ensuring data quality and observability, and collaborating with upstream software engineering and DevOps teams and downstream Marketing, Product, and Leadership stakeholders. The position is hybrid, based in Chicago, with three office days per week.

Requirements

2–5 years of professional data engineering experience.
Expert SQL skills, including query optimization.
Production experience with dbt.
Solid Python skills and experience writing production code.
Hands-on experience with Airflow or Prefect or Dagster.
Experience with a cloud data warehouse such as Snowflake, BigQuery, or Redshift.
Understanding of the data product lifecycle, standards, and practices.
Knowledge of data quality functions such as cleansing, standardization, parsing, and validation.
Ability to design systems and lead projects.
Clear communication with technical and nontechnical colleagues.
Proficiency with version control (Git/GitHub) and command-line interfaces.

Nice To Haves

Kubernetes or infrastructure-as-code experience.
CI/CD and DevOps practices.
Experience with data quality frameworks such as Elementary, Great Expectations, or Monte Carlo.
Financial services background.
Advanced Airflow patterns and custom operators.
Experience with agile development practices and the project lifecycle.

Responsibilities

Design and build scalable data pipelines using dbt, Python, Airflow, and Snowflake to support business processes, including executive reporting dashboards.
Own pipeline architecture and performance, and drive strategic initiatives to improve the data platform.
Make architectural decisions, including schema design, tool selection, and trade-offs.
Own data quality and observability, and build infrastructure that keeps data accurate.
Write ELT code using modern data engineering practices, including Git, automated testing, and deployments.
Debug production data issues.
Process, clean, and validate data from external sources and internal data pipelines.
Lead ad-hoc analysis using internal and external data sources to help teams understand customer interactions with products.
Collaborate with upstream data producers in Software Engineering and DevOps and downstream consumers in Marketing, Product, and Leadership.
Contribute to data visualization and reporting efforts in Tableau.
Upskill colleagues through code review, design collaboration, and knowledge sharing.
Optimize performance, improve processes, and advance team practices.

Benefits

Performance bonuses.
Stock purchase options.
Medical, vision, and dental benefits.
401(k) plan.
20 paid vacation days, plus an additional paid vacation day during the employee's birthday month.
10 paid sick days.
Gym membership reimbursement.
Commuter benefits.
Pet insurance.
Wellness and mental health programs.
Charitable donation matching.
Two paid volunteer days off.
Daily catered lunch when in the office.
Full kitchen with snacks and beverages.
In-building gym.
Shuttle to and from Metra.