Contact Us

Analytics Engineer

Full-Time
Full-Time
Kyiv
Kyiv
Remote
Remote

Requirements

 

  • Advanced SQL proficiency – query optimization, window functions, complex joins, performance tuning on large datasets.
  • Hands-on experience with the AWS data ecosystem – Redshift/Athena (Spark/Glue will be a plus).
  • Python scripting for data processing/automation.
  • Experience with Apache Airflow for pipeline orchestration.
  • Experience building and maintaining dashboards/data sources in Tableau.
  • Ability to communicate data logic and insights clearly to both technical and non-technical stakeholders.
  • Solid understanding of data warehousing concepts – dimensional modeling, star/snowflake schemas, slowly changing dimensions.

 

Would be a plus

 

  • Familiarity with the concept of Data Lakehouse and open table formats (Apache Iceberg)
  • Experience with dbt for transformation and modeling.
  • Experience with marketing/attribution data (Meta, Google Ads, TikTok, AppsFlyer) or mobile app analytics.
  • Familiarity with CI/CD practices for data pipelines.

Responsibilities

 

  • Design, build, and maintain ETL/ELT pipelines using SQL/Apache Spark (AWS Glue) and Airflow.
  • Model and optimize data in Amazon Redshift and query large datasets via Amazon Athena.
  • Write advanced SQL to transform raw data into clean, joinable, analysis-ready tables.
  • Build and maintain Tableau dashboards and data sources, ensuring accuracy, performance, and usability for business stakeholders.
  • Partner with stakeholders (marketing, product, BI) to translate business questions into robust data models.
  • Ensure data quality by implementing checks/monitoring and documenting the data warehouse.
  • Improve pipeline reliability, performance, and cost-efficiency on AWS, including evaluating and adopting dbt for transformations.
Kseniia Makarenko — Talent Acquisition Manager

Kseniia Makarenko

Talent Acquisition Manager

Join our team

Our Benefits

Corporate Events

Corporate Events

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

Learning & Development

Learning & Development

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

Mental & Physical Health

Mental & Physical Health

We provide health insurance, sports and psychotherapy reimbursement

Time Off Policy

Time Off Policy

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

Public Holidays

Public Holidays

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.

Sick Leave

Sick Leave

100% Sick Leave Compensation

Personal Equipment Policy

Personal Equipment Policy

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

Remote-First Work

Remote-First Work

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

Gismart is a mobile app developer with award-winning products in Health, Wellness, Utilities & Music and over 1 billion downloads across the globe.

Our apps inspire and empower people to build a healthy lifestyle that’s sustainable and enjoyable

Our Way 
of Working

D

Deliver what matters

"There’s real pride when something we built goes live."

R

Respect and support others

"Whenever I’m stuck, there’s always someone who jumps in to help - no judgment."

I

Initiate and own

"If you give them a task, they’ll not just do it - they’ll think of a better way to solve it."

V

Voice
openly

"I always know where we’re heading and why - no surprises."

E

Execute with quality

"Always aims to improve the product, even when it’s already good."

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.

Haven’t found a role for you?

Contact Us