Analytics Engineer

Skylum allows millions of photographers to make incredible images. Our award-winning software automates photo editing with the power of AI yet leaves all the creative control in the hands of the artist.
Join us on our mission to make photo editing enjoyable, easy, and accessible to anyone. You’ll be developing products with innovative technologies, providing value and inspiration for customers, and getting inspired in return.
Thanks to our incredible team of experts, we’ve built a collaborative space where you can constantly develop and grow in a supportive way. At the same time, we believe in the freedom to be creative. Our work schedule is flexible, and we trust you to give your best while we provide you with everything you need to make work hassle-free. Skylum is proud to be a Ukrainian company, and we stand with Ukraine not only with words but with actions. We regularly donate to various organizations to help speed up the Ukrainian victory.

Role Mission:

We’re looking for an Analytics Engineer to build and manage reliable data pipelines and analytical models that support Data Science, Product, Marketing, and company-wide decision-making.

You will join our Core Analytics team alongside Data Engineers and work closely with analysts embedded in Product and Marketing. You will own the analytical transformation layer—from Python and SQL pipelines in Airflow to documented data marts and consistent business metrics.

Our data environment:
Python, SQL, Apache Airflow, MySQL, ClickHouse, Parquet, AWS, and Tableau.

Responsibilities:

• Build and maintain Python and SQL pipelines in Airflow, including scheduling, incremental processing, backfills, and failure recovery.

• Develop reusable data models and marts for product activity, marketing acquisition, accounts, subscriptions, payments, and marketplace transactions.

• Partner with analysts to translate business requirements into trusted datasets and consistent metrics, including revenue, retention, CAC, and LTV.

• Ensure data reliability through automated testing, validation, monitoring, and troubleshooting.

• Optimize pipeline and query performance, maintain documentation, and contribute to code reviews and CI/CD practices.

• Collaborate with Data Engineers on ingestion dependencies and infrastructure, owning analytical workflows from development through production.

Requirements:

• Experience in analytics engineering, data engineering, or a similar role, owning production pipelines and analytical datasets.

• Strong Python skills for data processing and automation, including modular code, logging, error handling, and testing.

• Strong SQL skills, including complex transformations, window functions, incremental processing, and query optimization.

• Hands-on experience with Airflow or a comparable orchestrator, including workflow development, dependency management, and troubleshooting.

• Knowledge of dimensional modeling, dataset grain, historical data management, and reliable pipeline design.

• Experience integrating data from databases, APIs, and files, including Parquet/Delta.

• Familiarity with Git, code reviews, CI/CD, and dbt/Spark or a comparable approach to tested SQL transformations.

• Ability to translate business needs into clear technical requirements and collaborate with engineers, analysts, and stakeholders.

Nice to Have:

• Experience with ClickHouse, MySQL, AWS, and datasets supporting Tableau or Power BI.

• Understanding of subscription, mobile, or marketplace business models.

• Familiarity with attribution, cohort-based LTV, experimentation data, and cross-platform identity resolution.

• Experience improving data quality, documentation, and engineering standards within a growing team.

What we offer:
For personal growth:

• A chance to work with a strong team and a unique opportunity to make substantial contributions to our award-winning photo editing tools;
• An educational allowance to ensure that your skills stay sharp;
• English and German classes to strengthen your capabilities and widen your knowledge.

For comfort:

• A great environment where you’ll work with true professionals and amazing colleagues whom you’ll call friends quickly;
• The choice of working remotely or in our office space located on Podil, equipped with everything you might need for productive and comfortable work.

For health:

• Medical insurance;
• Twenty-one days of paid sick leave per year;
• Healthy fruit snacks full of vitamins to keep you energized.

For leisure:

• Twenty-one days of paid vacation per year;
• Fun times at our frequent team-building activities.

What to expect when you apply:

• An interview with our Talent Acquisition Specialist
• Professional interview
• Management interview