Data Engineer
Gismart · Ukraine
Software Development · 201-500 employees
About the role
The role involves developing and maintaining ETL/ELT pipelines for analytical reporting and supporting attribution models. Additionally, the engineer will ensure data quality, perform query optimization in Redshift, and provide stakeholder support for BI platforms.
What they look for
Requirements
Candidates must have 1-2 years of commercial experience in data engineering or BI development with proficiency in SQL and Python. Strong knowledge of AWS, Amazon Redshift, and Apache Airflow is required, along with experience in data warehouse and data lake concepts.
Benefits
Full 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:
- Deliver what matters
- Respect and support others
- Initiate and own
- Voiceopenly
- Execute 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 (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.
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.
