Data Engineer

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

Benefits offered by this job

Remote-First Culture

Coworking Compensation

Free Office Lunches

Public Holidays Policy

Sick Leave Compensation

Health & Wellness coverage

Personal Equipment Policy

Learning & Development

Paid vacation & personal days

Corporate events

Job summary

Gismart is seeking a data engineering/analytics engineer to build and maintain ETL/ELT pipelines for the FitMe analytics project, ensuring data quality and reliable BI reporting.

You will optimize Redshift queries, collaborate with the BI team and product analysts, support attribution models, and integrate external sources to deliver actionable insights across subscriptions and monetization.

Qualifications

• 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.

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.

Skills

Advanced SQL

Python

Data engineering

Analytics engineering

BI development

Tools

AWS

Amazon Redshift

Apache Airflow

Terraform

dbt

Apache Spark

Apache Iceberg

Job description

About us

Gismart is a value-driven mobile app developer with a strong presence in the Health & Wellness, Utilities, and Music app markets. We have recently achieved a significant milestone of over 1 billion downloads worldwide, taking a step toward our mission of cultivating the well-being of people worldwide. With headquarters in London, UK, Gismart is a dynamic global company with a reach extending across Europe and far beyond. Our determined team consists of 250 individuals who bring diversity, creativity, innovation, and relentless drive to the company. Gismart unites professionals from diverse backgrounds in entertainment, music, and tech, allowing us to play to each other’s strengths and succeed as a team.

Our mission

Become a stepping stone on our customers’ journeys of self-improvement.

Our values

• D eliver what matters
• R espect and support others
• I nitiate and own
• V oiceopenly
• E xecute with quality

If you are passionate about mobile app development and want to join a company that’s reshaping the industry, Gismart is the place for you. We provide exciting career opportunities, a supportive workplace culture, and the chance to contribute to a team that is making a tangible impact. For more information on Gismart, visit gismart.com.

About project

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.

What you will do

• 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.

Key qualifications

• 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.

Would be a plus

• 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).

Employee Benefits

• Remote-First Culture: Our team is diverse and extensive, just like our product portfolio. We provide a flexible working schedule and let you work anywhere in the world, either remotely or in one of our corporate hubs.
• Сoworking Compensation: We provide 100% compensation for coworking spaces in Ukraine (except Kyiv, where we have a cozy and autonomous hub) and 50% compensation for coworking spaces worldwide to make sure that everyone has a comfortable and inspiring workspace.
• Free Office Lunches: We want you to stay fueled and focused, so we provide delicious free lunches for everyone working from our hubs. It’s one less thing for you to worry about during a productive workday.
• 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: To help you stay happy and healthy, Gismart will partially cover your medical insurance, sports activities, therapy costs.
• Personal Equipment Policy: Of course, we’ll provide you with all the equipment you need or cover the maintenance cost for your own tools.
• Personal Learning and Development: We love to see you learn and grow, so Gismart will cover 70% of your professional development courses. We’ll also pay for 100% of corporate English courses.
• Time-Off Policy: Every employee gets 18 working days of paid vacation and 3 personal days per year, with an extra day added for each year at Gismart.
• Corporate Events: We are remote-first, but we love meeting up in person. Whenever possible, we organize corporate events and team-building activities across all Gismart hubs.