Basic Information

Location: 6000 Broken Sound Parkway NW, Boca Raton - Corporate HQ, Florida, 33487, United States

Corporate or Franchise

Corporate

Employer Name

Ultimate Fitness Group, LLC

Department

Information Technology

Working Time

Full-time

Studio #

0000

Ref #

DATAB02196

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
The Database Dev Engineer’s role requires an aptitude in relational database skills, database theory, and transactional database systems.  Required tasks for the role include database development and operational aspects, which will primarily align with the development efforts surrounding multiple application platforms within Orangetheory and the data integration between internal and external systems.  Tasks for this role will have clearly defined goals, but the paths to the best solutions are often unknown or highly variable. This requires self-directed investigation and an ability to work effectively within a team to present optional solutions and recommendations; a role ideal for the self-starter who enjoys innovation.

ESSENTIAL JOB FUNCTIONS

  • Development aspects including designing and creating new database schemas and related objects
  • Continuous integration, automation, change control, as well as scalable and performant designs
  • Able to work with large data sets and complex data models across internal and third-party platforms
  • Ability to migrate and cleanse data for consumption by Orangetheory applications and other ancillary processes based on business requirements and quality standards
  • Work closely with the product and development teams to build out the Orangetheory data infrastructure within the cloud using Amazon Web Services and other cloud-based technologies
  • Understanding of mobile, web-based applications and best practices for modeling and storing data from multiple sources and across multiple data storage mediums (Relational and NoSQL databases, as well as file storage solutions such as AWS S3)

 

OPERATIONAL JOB RESPONSIBILITIES

  • Design and Develop database models and schemas utilizing best practices and the continuous integration/continuous deployment development pipeline
  • Develop stored procedures/views using MySQL and back-end ETL processes for data flow/ingestion for business systems and applications using scripting or relevant coding languages (i.e. Python, Java)
  • Develop and maintain data interfaces and data contracts between platforms
  • Collaborate on a regular basis with the product and development teams to design solutions, resolve issues within the database infrastructure, and execute on decisions to meet deliverables and SLAs
  • Participate in the planning and execution of application system deployments with multiple teams
  • Document database processes, data flows, and solutions effectively and communicate between teams
  • Ensure work/tasks assigned are completed within the defined timeframes

 

 

ESSENTIAL SKILLS

  • Strong MySQL development skills - writing stored procedures, views, and ETL processes across data multiple data sources leveraging cloud technologies within Amazon Web Services
  • Competency in designing databases to facilitate application requirements for scalability and performance
  • Possesses the aptitude to monitor, diagnose, and resolve performance issues within the data layer when necessary
  • Ability to work within the Amazon Web Services (AWS) cloud landscape on MySQL databases
  • Can work effectively in a fast-paced, team-oriented environment
  • Self-motivated, flexible, and innovative with ability to manage responsibilities in a time-critical manner
  • Strong analytical/troubleshooting skills with a high aptitude in problem solving and execution of solutions
  • Good interpersonal skills to interact team members, product owners, and technology leadership
  • Ability to balance and prioritize work for multiple simultaneous tasks under time constraints
  • May be required to work early morning, evening, or even weekend hours when necessary
  • May be required to work in a mobile capacity

 

 

REQUIRED EDUCATION/EXPERIENCE

  • Bachelor’s Degree in Engineering/Computer related discipline, or equivalent experience required
  • Strong database development skills working with MySQL relational databases
  • Strong understanding of database design and development principles, theories and best practices
  • Understanding of database performance principles (indexing, partitioning, query performance tuning)
  • Experience working with NoSQL databases such as Cosmos, MongoDB or Amazon DynamoDB is a plus
  • Strong coding/scripting abilities for database ETL processes using Java, Python or equivalent language
  • Experience efficiently managing multiple work streams and analyses in a fast-paced environment
  • Ability to effectively analyze data and ensure quality and correctness according to business requirements
  • 3-5+ years experience with database development and design using relational databases
  • 3-5+ years experience working in development environments with both internal and off-shore teams
  • 3+ years experience working with mobile applications and open stack technologies
  • Working knowledge of both Windows and Linux operating systems (Amazon Linux, CentOS)
  • Working experience with Amazon Web Services (EC2, Lambda, RDS, S3) is preferred
  • Experience and/or familiarity with Adobe Campaign (Adobe Marketing Cloud suite) is a plus
  • Work Requirements

 

COMPETENCIES

  • Accountability to a high standard of work quality
  • Keen attention to detail and code/data quality
  • Excellent verbal and written communication skills
  • Highly organized and able to multi-task under time constraints
  • Ability to balance and prioritize work
  • Works well in a fast-paced environment
  • Self-motivated, Collaborative, and is a true team player
  • Ability to document work, processes, and share information

  

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.