Data Engineer
Active online brokerage and trading platform for self-directed investors, offering stocks, options, futures, crypto and related financial products.
About tastytrade
tastytrade, Inc. is a Chicago-based financial-services company and online broker for self-directed traders. Its platform provides web, desktop and mobile trading, market-analysis tools, educational content and an Open API. tastytrade, Inc. was formerly known as tastyworks, Inc.
Skills
Candidate Availability
Required and preferred rules are kept separate and reflect the wording in the original posting.
About the Role
You will design, build, and operate scalable data pipelines and help shape the data platform. You will make architectural decisions, write and test ELT code, resolve production data issues, process and validate data, and contribute to analysis and Tableau reporting. You will collaborate with data producers and consumers, improve platform performance and practices, and share knowledge through reviews and design collaboration.
Requirements
- 2–5 years of professional data engineering experience
- Expert SQL skills
- Production dbt experience
- Production Python development experience
- Hands-on experience with Airflow, Prefect, or Dagster
- Experience with Snowflake, BigQuery, Redshift, or another cloud data warehouse
- Knowledge of the data product lifecycle, standards, and practices
- Experience with data cleansing, standardization, parsing, and validation
- System design and project leadership skills
- Clear communication with technical and non-technical stakeholders
- Proficiency with Git, GitHub, and command-line interfaces
- Kubernetes or infrastructure-as-code experience preferred
- CI/CD and DevOps practices preferred
- Experience with data quality frameworks preferred
- Financial services background preferred
- Advanced Airflow patterns and custom operators preferred
- Agile development and project lifecycle experience preferred
Responsibilities
- Design and build scalable data pipelines using dbt, Python, Airflow, and Snowflake
- Own pipeline architecture, performance, and data-platform improvement initiatives
- Make architectural decisions on schema design, tool selection, and trade-offs
- Own data quality and observability infrastructure
- Write ELT code using Git, automated testing, and deployment practices
- Debug production data issues
- Process, clean, and validate data from internal and external sources
- Lead ad hoc analysis of customer product interactions
- Collaborate with upstream data producers and downstream data consumers
- Contribute to Tableau data visualization and reporting
- Upskill colleagues through code reviews, design collaboration, and knowledge sharing
- Optimize performance, improve processes, and strengthen team practices
Benefits
- Performance bonuses
- Stock purchase options
- Medical, vision, and dental benefits
- 401(k) plan
- 20 paid vacation days plus a paid birthday-month vacation day
- 10 paid sick days
- Gym membership reimbursement
- Commuter benefits
- Pet insurance
- Wellness and mental health programs
- Charitable donation matching
- Two paid volunteer days
- Daily catered lunch in the office
- Kitchen snacks and beverages
- In-building gym
- Metra shuttle