Basic Information

Location: Seattle, Washington, United States

Corporate or Franchise

Corporate

Employer Name

Ultimate Fitness Group, LLC

Department

Information Technology

Working Time

Full-time

Studio #

0000

Ref #

5968

Job Posting Details:

 

Orangetheory® Fitness is one of the fastest-growing global fitness franchises with studios located throughout the United States as well as internationally.  We are a scientifically designed, one-of-a-kind, group personal training workout broken into intervals of cardiovascular and strength training. Led by highly skilled coaches, each Orangetheory Fitness workout incorporates endurance, strength and power elements through a variety of equipment including treadmills, rowing machines, TRX® suspension training and free weights.   We have over 1,200 locations open in the US. We currently operate 150+ International studios in 22 countries with more than 400 new fitness studios under development across the nation and internationally.

 

SUMMARY/OBJECTIVE

 

We are looking for a passionate and determined Business Intelligence Engineer to join the Business Intelligence team at Orangetheory® Fitness. This is an entry to mid-level position perfect for someone looking for an opportunity to join a leader in the fitness space. The BI team is part of the broader ML and Analytics organization which is is a rapidly growing part of Orangetheory® Fitness and is focused on delivering tangible and transformative data driven use cases to business stakeholders across the company. As part of the Business Intelligence team, this experienced data professional will help surface key metrics and unlock vital insights that allow the business to make data driven decisions. This position will require deep expertise in the design, creation, management, and business use of large datasets. An ideal candidate will have excellent communication skills to be able to work with analysts and business owners to develop and define key business questions and to build data sets that answer those questions. This will require expertise in designing, implementing, and operating stable, scalable, low cost solutions to flow data from production systems into the data warehouse and into end-user facing applications. This position will be the bridge between the data engineering and analytical space and have the ability to understand business use cases and identify appropriate datasets and upstream sources to cater to those needs.

 

ESSENTIAL JOB FUNCTIONS

·       Develop data orchestration pipelines, data sourcing, cleansing and augmentations and quality control processes

·       Extracting and combining data from various heterogeneous data sources

·       Optimizing the performance of business-critical queries and dealing with ETL job related issues

·       Coordinate with analysts and business units to identify key metrics and underlying data requirements

·       Recommend enhancements and modifications to optimize business intelligence processes

·       Identifying the data quality issues across the various platforms

·       Modelling data and metadata to support ad-hoc and pre-built reporting

·       Supporting data architects during dataset design phases

·       Bridge the gap between Data Engineers and Business Analysts by creating modular and resuable last mile datasets

 

 

 REQUIRED EDUCATION/EXPERIENCE

·       B.S. in Computer Science, Software Engineering, Data Science, Applied mathematics or equivalent experience.

·       3-5 years of experience as an analyst or engineer in the data/BI space

·       Experience in one of the following areas: Data engineering, database engineering, or business intelligence

·       Hands-on experience in writing complex, highly-optimized queries across large data sets

·       Experience with AWS services including S3, Redshift, EMR and RDS

·       Experience working in a snowflake heavy environment a plus

·       Experience with Big Data Technologies

·       Proficiency in SQL and Python – other programming skills such as Scala or Java a plus

·       Experience in working and delivering end-to-end projects independently

·       Experience writing advanced queries in SQL

 

COMPETENCIES

  • Teamwork
  • Attention to Detail
  • Problem Solving

 

SUPERVISORY REQUIREMENTS
This position does not directly manage employees.

 

EEO STATEMENT

Orangetheory Fitness provides equal employment opportunity to all individuals regardless of their race, color, creed, religion, gender, age, sexual orientation, national origin, disability, veteran status, or any other characteristic protected by state, federal, or local law.  Discrimination of any type will not be tolerated.