Data Engineer

tastylive•Chicago, IL

2d•Hybrid

About The Position

tastytrade is seeking 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 helps develop the skills and practices of teammates. The engineer will work within a full-stack data team of data scientists, data engineers, and analysts, with responsibility for data pipelines and feature generation from design through delivery and iteration. The role involves building and maintaining scalable data pipelines and ELT systems, supporting business processes such as executive reporting dashboards, and making architectural decisions involving schema design, tools, and trade-offs. It also includes data quality and observability, production debugging, data preparation and validation, ad-hoc analysis, and contributions to Tableau visualization and reporting. The engineer collaborates with upstream Software Engineering and DevOps teams and downstream partners in Marketing, Product, and Leadership. The team works with Snowflake, dbt, Airflow, Tableau, Python, AWS (S3, ECR, EKS), GitHub, ArgoCD, Elementary, and Grafana. The position is based in Chicago, Illinois, with a hybrid schedule of three days per week in the office. The posted base salary range is $130,000–$150,000, with a discretionary performance bonus of 8–12% of base salary based on individual and company performance.

Requirements

2–5 years of professional data engineering experience.
Expert SQL skills, including the ability to optimize queries.
Production experience with dbt.
Ability to write production-quality Python code.
Hands-on experience with Airflow or Prefect/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 both technical and non-technical colleagues.
Proficiency with version control, including 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 to maintain data accuracy.
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 how customers interact with products.
Collaborate with upstream data producers in Software Engineering and DevOps and downstream data consumers in Marketing, Product, and Leadership.
Contribute to data visualization and reporting efforts in Tableau.
Upskill teammates 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/from Metra.