Описание

Gismart is hiring a Data Engineer for the FitMe fitness app. The role involves developing and supporting ETL/ELT pipelines, ensuring data quality, optimizing Redshift queries, and integrating external attribution and analytics sources.

Responsibilities

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 (Web↔Mobile 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

Requirements

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

Nice to have

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)

We offer

Remote-First Culture: flexible working schedule, work anywhere in the world, either remotely or in one of our corporate hubs
Coworking Compensation: 100% compensation for coworking spaces in Ukraine (except Kyiv, where we have a cozy and autonomous hub) and 50% compensation for coworking spaces worldwide
Free Office Lunches for everyone working from our hubs
Public Holidays Policy: 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
Mental and Physical Health: partially cover medical insurance, sports activities, therapy costs
Personal Equipment Policy: provide all the equipment you need or cover the maintenance cost for your own tools
Personal Learning and Development: cover 70% of professional development courses and 100% of corporate English courses
Time-Off Policy: 18 working days of paid vacation and 3 personal days per year, with an extra day added for each year at Gismart
Corporate Events and team-building activities across all Gismart hubs