Data Engineer
Orangetheory Fitness
- Washington
- $127,945 per year
- Permanent
- Full-time
- Design, implement and maintain stable data ingestion pipelines using ETL best practices.
- Responsible for transforming and optimizing raw data sets into modeled datasets tailored to business needs.
- Collaborate with BI Analysts and Data Scientists to ensure data availability for analysis and reporting.
- Adhere to Data Engineering best practices, including data security and privacy protocols.
- Monitor and troubleshoot data pipelines, quickly identifying and remedying weaknesses, lapses, or bugs.
- Participate in code reviews and testing to ensure accurate, scalable, and maintainable output.
- Act as a mentor to junior team members, providing guidance and support for their professional development.
- Lead projects involving complex data pipelines and design systems to meet internal and external stakeholder needs.
- Cultivate a culture of excellence and continuous improvement within the team.
- Highly optimized and efficient SQL
- Snowflake data warehouse
- Big data environments and processing large volumes of data
- DAG orchestration tools such as Airflow, Astronomer or Dagster
- Free workouts at corporate studios & discounted classes at franchise owned studios
- Healthcare Benefits: Medical, Dental, Vision among many other supplemental benefits
- Employer Paid Benefits: Long-Term Disability and Life Insurance
- 4 weeks of Paid Time Off + Designated Birthday & Charity PTO
- 11 Paid Holidays
- Up to 12 Weeks of Fully Paid Parental Leave
- Education & Tuition Reimbursement
- State-of-the-Art Wellness Center at The Grove which includes 2 complimentary professional massages per year
- 401k Plan with Employer Contribution
- Discounts on Orangetheory Fitness Retail
- Employee Resource Groups (ERGS)
- Flexible, Hybrid Work Schedules
- Team Building, Employee Engagement activities and so much more
- Remote optional: Mondays and Fridays
- On-site days: Tuesdays, Wednesdays, and Thursdays