Analytics Engineer

Job not on LinkedIn

🔥 0 minutes ago

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Gismart

WebsiteLinkedInAll Job Openings

201 - 500 employees

👥 B2C

🧘 Wellness

📱 Media

B2C • Wellness • Media

Gismart is a mobile app developer that creates award-winning consumer apps across health, wellness, utilities, and music. The company reports more than 1 billion downloads worldwide and 30+ million monthly active users, and states a mission to make personal wellness more accessible through easy-to-use interactive technology. Gismart focuses on B2C mobile experiences that encourage healthy habits and provide music and utility apps for a broad consumer audience.

📋 Description

• 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. • Familiarity with the concept of Data Lakehouse and open table formats (Apache Iceberg) — would be a plus • Experience with dbt for transformation and modeling — would be a plus • Experience with marketing/attribution data (Meta, Google Ads, TikTok, AppsFlyer) or mobile app analytics — would be a plus • Familiarity with CI/CD practices for data pipelines — would be a plus.

🏖️ Benefits

• Remote-First Culture: Our team is diverse and extensive, just like our product portfolio. • Сoworking Compensation: We provide 100% compensation for coworking spaces in Ukraine and 50% compensation for coworking spaces worldwide. • Free Office Lunches: We provide delicious free lunches for everyone working from our hubs. • Public Holidays Policy: Gismart observes public holidays based on the Ukrainian or Polish holiday calendars. • 100% Sick Leave Compensation • Mental and Physical Health: Gismart will partially cover your medical insurance, sports activities, and therapy costs. • Personal Equipment Policy: We’ll provide you with all the equipment you need or cover the maintenance cost for your own tools. • Personal Learning and Development: Gismart will cover 70% of your professional development 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 organize corporate events and team-building activities across all Gismart hubs.