Data Engineer

tastytrade is hiring a Data Engineer for its Analytics team. The role owns data pipeline architecture and performance, builds and maintains data infrastructure, and supports analytics and reporting across the business.

Responsibilities

• 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

Preferred

• Kubernetes or infrastructure-as-code experience
• CI/CD and DevOps practices
• Data quality frameworks (Elementary, Great Expectations, Monte Carlo)
• Financial services background
• Advanced Airflow patterns and custom operators
• Experience with agile development practices and the project lifecycle
• Kubernetes
• Infrastructure as Code
• CI/CD
• DevOps
• Data Quality Frameworks
• Elementary
• Great Expectations
• Monte Carlo
• Financial Services
• Apache Airflow
• Custom Operator Development
• Agile Development
• Project Lifecycle

Benefits

• Hybrid work, 3 days/week
• Performance Bonuses
• Stock Purchase Options
• Medical/Vision/Dental Benefits
• 401k Plan
• 20 Paid Vacation Days (plus an additional paid vacation day the month of your birthday!)
• 10 Paid Sick Days
• Gym Membership Reimbursement
• Commuter Benefits
• Pet Insurance
• Wellness & 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

Company

• Live financial network for active options and futures traders
• Chicago, Illinois, USA
• https://www.tastylive.com/
• Founded in 2011
• 51-200 employees

Qualifications

• 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
• Kubernetes or infrastructure-as-code experience
• CI/CD and DevOps practices
• Data quality frameworks (Elementary, Great Expectations, Monte Carlo)
• Financial services background
• Advanced Airflow patterns and custom operators
• Experience with agile development practices and the project lifecycle

Required skills

• Apache Airflow, CI/CD, Command-Line Interfaces, Data Quality, DevOps, Financial Services, Git, GitHub, Infrastructure as Code, Kubernetes, Python, SQL, Snowflake, dbt

Preferred skills

• Advanced Airflow patterns and custom operators, CI/CD and DevOps practices, Financial services background, Kubernetes or infrastructure-as-code experience

Experience

• 2-5 years