Data Engineer

Company: tastytrade
Role: Data Engineer
Location: Chicago IL Hybrid 4 days/week in office

Were looking for a Data Engineer to join our Analytics team. Youll own data pipeline architecture. Youll upskill those around you. Youll have a real influence on how we build our data platform. We need an experienced data engineer who can own their projects while being a member of a full stack data teamdata scientists data engineers and analysts who take full ownership of our data pipelines and feature generation. This is a full-scope role. You design systems. You make tech decisions. You ship. You iterate. If you have a good idea and can execute it wed love to learn.

What Youll Do

• Lead ad-hoc analysis using both internal and external data sources for a variety of different teams to understand how our customers interact with our products
• Design and build scalable data pipelines using dbt Python Airflow and Snowflake to support various business processes (such as our executive reporting dashboards)
• Own data quality and observabilityyoure the one who cares about data being right
• Make architectural decisions: schema design tool selection trade-offs
• Write ELT code using modern data engineering practices (Git automated testing and deployments)
• Debug production data issues when they break (and they will)
• Collaborate with multiple teams including upstream data producers (Software Engineering/DevOps teams) and downstream data consumers (Marketing/Product/Leadership teams)
• Upskill those around you through code review design collaboration and knowledge sharing
• Contribute to data visualization and reporting efforts in Tableau
• Optimize performance improve processes level up team practices
• Process clean and validate data from a variety of external sources and internal data pipelines

What You Are:

• 2-5 years of professional data engineering experience
• Expert SQL skillsyou think in queries optimize ruthlessly
• Real dbt experiencenot just exposure actual production work
• Solid Pythonproduction code not scripts
• Hands-on Airflow (or Prefect/Dagster)
• Cloud data warehouse experience (Snowflake BigQuery Redshift)
• Understanding of data product lifecycle standards and practices
• Knowledge of quality data functions like cleansing standardization parsing and validation
• Proven ability to design systems and lead projects
• You communicate clearly with non-engineers and engineers alike
• Proficiency with version control systems (Git/GitHub) and command line interfaces

Nice to Have

• 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 custom operators
• Experience with agile development practices and project lifecycle

Youll Own

• Pipeline architecture and performance
• Data quality infrastructure and observability
• Strategic initiatives to improve our data platform

Our Stack

• Snowflake
• Dbt
• Airflow
• Tableau
• Python
• AWS (S3 ECR EKS)
• Github
• ArgoCD
• Elementary
• Grafana

Team Perks/Benefits:

• Performance Bonuses
• Stock Purchase Options
• 401k Plan
• Medical/Dental/Vision Benefits
• 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
• Office located in the West Loop - Chicagos growing center of tech great cuisine and high-end bars

Salary Range: $110000 - $130000
The actual salary offered will be based on the candidates level of experience and qualifications

Discretionary performance bonus:8-12% of base salary based on individual and company performance

About Us:

The tastyhouse of brands empowers individual traders differently. tastylive founded in 2011 is an online financial media networktastytrade (previously known as tastyworks) is a self-directed retail brokerage firm that launched in 2017 tasty Software Solutions and tastyfx is a registered Forex 2021 London-based IG Group acquired tastylive Inc. (previously known as tastytrade) and assigned it to lead business in North is the fastest-growing forex broker in the US over the past few years. Changing the IG US name to tastyfx marks the next chapter in aligning with the tasty brand family and offering a more forex-focused experience. This combined team has years of experience like institutional brokers but also a passion for disrupting the entire trading industry.

Our dream is simple: we want more people to find more success witha bettertrading experience. Thats why were investing heavily in the right people technology and media to make that happen in the US and across the globe.

Location:Our office is in the West Loop - Chicagos growing center of tech great cuisine and high-end bars.

tastytrade tastylive tastyfx tastycrypto
1330 W Fulton Market Chicago IL 60607

*Dont meet every single requirement Studies have shown that women and people of color are less likely to apply to jobs unless they have every single qualification. Our team is dedicated to building a diverse inclusive and authentic workplace so if youre excited about this role but your experience doesnt align perfectly we encourage you to apply anyway. You may be just the right candidate for this or other roles!