Job VC

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.

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.

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, autonomous hub) and 50% compensation for coworking spaces worldwide to ensure 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, and 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.