gismart - Analytics Engineer
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.
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. • 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.
Apply in one click
Upload My Resume
Drop here or click to browse · Tap to choose · PDF, DOCX, DOC, RTF, TXT