About us: Gismart is a value-driven mobile app developer with a strong presence in the Health & Wellness, Utilities, and Music app markets. We have achieved a significant milestone of over 1 billion downloads worldwide, taking a step toward our mission of cultivating the well-being of people worldwide. With headquarters in London, UK, Gismart is a dynamic global company with a reach extending across Europe and far beyond. Our determined team comprises over 350 individuals who bring diversity, creativity, innovation, and relentless drive to the company. Gismart unites professionals from diverse backgrounds in entertainment, music, and tech, allowing us to play to each other’s strengths and succeed as a team.
Our mission: Become a stepping stone on our customers’ journeys of self-improvement.
Our values: * Deliver what matters * Respect and support others * Initiate and own * Voiceopenly * Execute with quality
If you are passionate about mobile app development and want to join a company that’s reshaping the industry, Gismart is the place for you. We provide exciting career opportunities, a supportive workplace culture, and the chance to contribute to a team that is making a tangible impact. For more information on Gismart, visit gismart.com.
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.
