Client: Peak Fitness, a boutique fitness brand with 32 locations across 17 cities, was recently acquired by BeFit Inc. as part of its global expansion strategy. To scale operations and enhance customer engagement, Peak Fitness is transitioning from Mindbody, its current booking system, to a custom-built, in-house platform for class bookings, loyalty programs, and customer data management.

As a Data Engineer Consultant contracted by Peak Fitness’ Marketing & Retention team, your goal is to design and implement a cloud-based data solution that enables data-driven marketing, customer analytics, and retention strategies to support Peak Fitness’ growth under BeFit Inc.

End Goal:

• Design & build a scalable data model and build a data pipeline for class signups, user transactions, and engagement.
• Transform & store data for analytics & marketing campaigns.
• Enable predictive analytics (e.g., churn prediction, most popular class times) for Data Scientists.
• Allow flexibility in how students design ETL and analytics tables.

Deliverables

1. Technical Design Document (Example, open with Incognito)

   Follow this template: [Technical Design Document](<https://docs.google.com/document/d/1Yvsv5LEa9372VYc4GC2UeSXsppBJ9UCC2YBx8l8v4OY/edit?usp=sharing>)
   

2. A 10 min recorded presentation + demo on your system Architecture & Deployment (AWS, Open source, or other cloud providers)

   1. ETL Development
   2. Database Creation
   3. Enabling downstream data product
      1. Email Campaign (member retention + lifecycle)
      2. App Leaderboard Feature
      3. Brainstorm one more use case (BI dashboard(streamlit), new feature development etc.)

3. Github Repository containing documentation

Accessing the Data

Peak Fitness has shared access to its AWS S3 bucket (peak-fitness-data-raw) with your AWS account. This bucket contains historical and continuously updated data, and you are authorized to access it directly from your own AWS services and ETL tools without replicating the data.

The bucket is configured with Requester Pays, meaning your account will be responsible for any data access charges. So please be mindful and use best practices when developing or deploying any resources. The cost of reading the S3 bucket will be almost negligible (<0.1$ per month), but do set up monitors for the services and tools you provision for data transformation and ETL.

Please follow the steps below to set up secure access and configure your services accordingly.

Additionally, Peak Fitness also have the following tables that they maintain themselves to for relatively stable data including their instructor info, class type, location info, and current membership plans:

[Read Only] PeakFitness Lookup Tables

📍 Step 1: Send your 12-digit AWS account id to Minjia