Analytics Engineer

This is a fully remote position, open to applicants anywhere in the world.

📋 Description

• Design, develop, and sustain ETL/ELT pipelines utilizing SQL/Apache Spark (AWS Glue) and Airflow.

• Model and enhance data in Amazon Redshift and execute queries on large datasets using Amazon Athena.

• Craft advanced SQL to convert raw data into clean, joinable, and analysis-ready tables.

• Construct and manage Tableau dashboards and data sources, ensuring precision, performance, and usability for business stakeholders.

• Collaborate with stakeholders (marketing, product, BI) to transform business inquiries into robust data models.

• Maintain data quality by instituting checks/monitoring and documenting the data warehouse.

• Enhance pipeline reliability, performance, and cost-effectiveness on AWS, including the evaluation and integration of dbt for transformations.

⛳️ Requirements

• Proficient in advanced SQL — including query optimization, window functions, complex joins, and performance tuning on large datasets.

• Practical experience with the AWS data ecosystem — Redshift/Athena (knowledge of Spark/Glue is a plus).

• Python scripting skills for data processing and automation.

• Experience with Apache Airflow for orchestrating pipelines.

• Background in building and maintaining dashboards/data sources in Tableau.

• Proven ability to convey data logic and insights clearly to both technical and non-technical stakeholders.

• Strong understanding of data warehousing concepts — including dimensional modeling, star/snowflake schemas, and slowly changing dimensions.

• Familiar with the concept of Data Lakehouse and open table formats (Apache Iceberg).

• Experience utilizing dbt for transformation and modeling.

• Familiarity with marketing/attribution data (Meta, Google Ads, TikTok, AppsFlyer) or mobile app analytics.

• Knowledge of CI/CD practices for data pipelines.

🏝️ Benefits

• Remote-First Culture: Our team is diverse and extensive, just like our product portfolio. We offer a flexible working schedule and allow you to work from anywhere in the world, either remotely or in one of our corporate hubs.

• Coworking Compensation: We cover 100% of coworking space costs in Ukraine (except Kyiv, where we have a cozy, autonomous hub) and 50% 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 according to the Ukrainian or Polish holiday calendars. Employees 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 partially covers your medical insurance, sports activities, and therapy costs.

• Personal Equipment Policy: We will provide you with all necessary equipment or cover the maintenance costs for your own tools.

• Personal Learning and Development: We encourage your growth, so Gismart will cover 70% of your professional development courses, along with 100% of corporate English courses.

• Time-Off Policy: Every employee receives 18 working days of paid vacation and 3 personal days per year, with an additional day added for each year at Gismart.

• Corporate Events: We are remote-first, but we enjoy meeting in person. Whenever possible, we organize corporate events and team-building activities across all Gismart hubs.