Data engineer for a fitness app

Gismart; United States; Remote; USD 90,000 - 120,000; Full time

Job summary

Gismart ищет инженера по данным/BI-разработчика для поддержки и развития инфраструктуры аналитики. Основные задачи включают разработку и поддержку ETL/ELT пайплайнов, работу с базами данных в AWS/Redshift, настройку атрибуции и взаимодействие с командами BI, Product, UA и Billing.

Работа удаленная с возможностью встречи в офисах Gismart; нацеленность на качество данных, улучшение производительности и обеспечение стабильности аналитики.

Qualifications

• 1–2 года коммерческого опыта data engineering/BI-разработки

Responsibilities

• Поддержка заинтересованных сторон: валидация цифр и анализ расхождений между дашбордами
• Разработка и поддержка ETL/ELT-пайплайнов для аналитических отчетов
• Поддержка моделей атрибуции (WebMobile mapping, multi-locale cost-cohort)
• Интеграции с внешними источниками: Meta Marketing API, AppsFlyer, AppMetrica, Stripe, Tableau Server
• Контроль качества данных: проверка схемы, свежести, объема; детекция сломаных снапшотов
• Оптимизация производительности запросов и процедур в Redshift
• Сотрудничество с BI-командой, аналитиками Product/UA/ Billing

Skills

Advanced SQL

Python

AWS

Amazon Redshift

Apache Airflow

ETL/ELT pipelines

Data warehousing

Tools

Terraform

dbt

Apache Spark

Apache Iceberg

AppsFlyer

AppMetrica

Adjust

GA4

Job description

Описание:

FitMe is a fitness app created for people who want to stay active without long, repetitive workouts. It offers short, easy-to-follow routines that can be done at home with no equipment. FitMe is perfect for busy people who want to maintain their health, boost energy levels, and feel good every day — without going to the gym or spending hours on exercise.

Задачи:

• Stakeholder support: ad-hoc validation of figures, investigation of discrepancies between dashboards, ensuring availability of the BI platform.
• Development and support of ETL/ELT pipelines for analytical reports (cohort revenue, LTV, retention, KPI by creatives, post-purchase analytics).
• Support for attribution models (WebMobile mapping, multi-locale cost-cohort resolve, last-click vs raw events).
• Integrations with external sources: Meta Marketing API, AppsFlyer, AppMetrica, Stripe, Tableau Server (TSC), Birch.
• Data quality assurance: schema/freshness/volume checks, broken-snapshot detection, anti-bot-traffic filtering.
• Performance optimization of queries and procedures in Redshift.
• Collaboration with BI Team, Product / UA / Billing analysts.

Требования:

• 1-2 years of commercial experience in data engineering / analytics engineering / BI development.
• Experience with data warehouse, data lake and data lakehouse concepts.
• Proven experience in designing, implementing and supporting ETL/ELT pipelines.
• Experience with AWS, Amazon Redshift, Apache Airflow.
• Advanced SQL, hands‑on experience in designing production‑level Python code.
• Willingness to deal with business logic (subscription, monetization, attribution) — with team support.
• Будет плюсом: Experience with Infrastructure as Code (Terraform); Experience with dbt, Apache Spark, Apache Iceberg; Experience with UA‑attribution stack (AppsFlyer, AppMetrica, Adjust, SKAN, GA4) and UA cost APIs (Meta, Google Ads, TikTok, AppLovin)

Условия:

Despite being remote‑first, we love meeting up in person, so we often organize events in our Gismart hubs

Growth is our top priority, so we’ll cover 70% of your professional development courses and 100% of your English language courses

We provide health insurance, sports and psychotherapy reimbursement

18 days of paid vacation, 3 paid personal days, plus 1 day for each year at Gismart

Gismart observes public holidays based on the Ukrainian or Polish holiday calendars. Employees working in other locations are entitled to 12 public holidays per year.

100% Sick Leave Compensation

You can use our corporate devices or work on your own laptop and get a monthly depreciation compensation

Work from home anywhere in the world, in one of our Gismart hubs, or in a coworking space, which we’ll pay for