Company Background

Our client is a global leader in the fitness and active lifestyle industry, providing equipment and solutions that help people lead healthier and more active lives. The company’s portfolio includes well-known brands covering gym training, strength equipment, rehabilitation, indoor cycling, and recreational activities. Its products are distributed in more than 120 countries, supporting fitness clubs, wellness facilities, rehabilitation centers, and individual users worldwide.

Project Description

The project focuses on redesigning a system that collects, transforms, and synchronizes data from multiple sources to streamline processes and reduce infrastructure costs. The solution helps health clubs manage fitness equipment, analyze equipment usage and exerciser behavior, deliver software updates, configure equipment across facilities, and send service notifications.

Technologies

• SQL
• BigQuery
• BigQuery Pipelines
• Google Cloud Functions / Google Cloud Run
• Google Cloud Dataflow
• PostgreSQL
• Cloud SQL
• Linux

What You'll Do

• Design and maintain BigQuery pipelines for operational and analytics use cases, including partitioned data marts consumed by APIs;
• Develop software components supporting data import, export, and synchronization operations;
• Automate data import, export, and processing tasks using Google Cloud Functions, containerized workloads, or equivalent managed Google Cloud services;
• Design and implement on-demand data migration APIs;
• Coordinate data migration activities with other teams and team members;
• Assist teams with extracting data from their existing systems;

Job Requirements

• 4+ years of experience working with BigQuery in production environments;
• Hands-on experience building pipelines from PostgreSQL to BigQuery for operational and analytics use cases;
• Experience designing partitioned data marts consumed by APIs, not only BI tools;
• Experience optimizing BigQuery costs through clustering, incremental models, and scheduled jobs;
• Experience with dbt;
• Background in IoT, device usage, or subscription analytics;
• GCP Professional Data Engineer certification is a plus;
• English proficiency at B2 level or higher;

What Do We Offer

The global benefits package includes:

• Technical and non-technical training for professional and personal growth;
• Internal conferences and meetups to learn from industry experts;
• Support and mentorship from an experienced employee to help you professional grow and development;
• Health insurance;
• Sports activities to promote a healthy lifestyle;
• Flexible work options, including remote and hybrid opportunities;
• Referral program for bringing in new talent;
• Work anniversary program and additional vacation days.