Data Engineer

This is a fully remote position, open to applicants in Ukraine.

📋 Description

• Conduct ad-hoc validation of data and explore discrepancies between dashboards.

• Ensure the Business Intelligence platform is always accessible.

• Design and maintain ETL/ELT pipelines for analytical reporting, covering aspects such as cohort revenue, LTV, retention, creative KPIs, and post-purchase analytics.

• Assist in attribution models, including Web-to-Mobile mapping, multi-locale cost-cohort resolution, and comparisons between last-click and raw events.

• Integrate external data sources like Meta Marketing API, AppsFlyer, AppMetrica, Stripe, Tableau Server, and Birch.

• Conduct data quality assurance through checks on schema, freshness, and volume.

• Identify broken snapshots and filter out anti-bot traffic.

• Enhance queries and procedures within Amazon Redshift.

• Collaborate with analysts from BI, Product, UA, and Billing departments.

⛳️ Requirements

• 1–2 years of professional experience in data engineering, analytics engineering, or BI development.

• Understanding of data warehouse, data lake, and data lakehouse principles.

• Demonstrated experience in designing, implementing, and maintaining ETL/ELT pipelines.

• Familiarity with AWS, Amazon Redshift, and Apache Airflow.

• Proficient in SQL.

• Practical experience in writing production-level Python code.

• Openness to engage with subscription, monetization, and attribution business logic, supported by the team.

• Experience with Infrastructure as Code using Terraform is a bonus.

• Knowledge of dbt, Apache Spark, or Apache Iceberg is advantageous.

• Familiarity with user acquisition attribution tools and stacks such as AppsFlyer, AppMetrica, Adjust, SKAN, and GA4 is a plus.

• Experience with user acquisition cost APIs such as Meta, Google Ads, TikTok, and AppLovin is a plus.

🏝️ Benefits

• Remote-first work culture.

• Flexible working hours.

• Ability to work from anywhere globally, either remotely or from a corporate hub.

• Full reimbursement for coworking spaces in Ukraine, excluding Kyiv.

• 50% reimbursement for coworking spaces worldwide.

• Complimentary office lunches for employees working from hubs.

• Public holidays aligned with either Ukrainian or Polish holiday calendars; 12 public holidays annually for employees in other locations.

• Complete sick leave compensation.

• Partial coverage for medical insurance, sports activities, and therapy costs.

• Equipment provided or maintenance costs covered.

• 70% reimbursement for professional development courses.

• 100% coverage for corporate English courses.

• 18 working days of paid vacation each year.

• 3 personal days annually.

• An additional vacation day for each year of service at Gismart.

• Corporate events and team-building activities held across Gismart hubs.