Analytics Engineer

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.