Analytics Engineer

Описание вакансии

Mayflower is a technology company that alters the entertainment industry to a new level of perception and engagement.

We are developing a partner advertising high-load system with a large RPS, convenient and modern interface. We are growing exponentially and successfully implementing new technologies to accelerate this growth and the system as a whole.

Now we look for a Analytics Engineer to join our team.

Job Responsibilities

  • Transform business requirements into data models and ETL processes

  • Develop and maintain data marts (Spark, Iceberg, Clickhouse) using DBT

  • Write and optimize SQL queries for analytical tasks

  • Document data models and business logic

  • Ensure data quality through automated tests

  • Collaborate with analysts to understand data needs

  • Optimize ETL pipelines and query performance

  • Monitor and troubleshoot data pipeline issues

  • Participate in code reviews and develop team best practices

Job requirements

SQL (advanced level):

  • Complex analytical queries (window functions, CTEs, subqueries)

  • Knowledge of OLAP systems specifics

  • Understanding of execution plans and performance optimization (as a plus)

Python (intermediate level):

  • Data processing (pandas, polars)

  • Task automation (Airflow)

DBT

  • Building transformation DAGs

  • Incremental models and snapshots

  • Model documentation

  • Data testing experience will be a plus

Analytical thinking:

  • Understanding business processes and their reflection in data

  • Ability to translate business requirements into technical solutions

  • Knowledge of metrics and KPIs

That can be a plus:

  • Spark, including PySpark

  • Iceberg

  • Clickhouse

Conditions

We know that great talent deserves great conditions, so here's what you can expect when joining us:

  • EU-based employment contract and a 3-year Cyprus work visa with full support for your relocation and visa processes, including assistance for your family.

  • Full relocation package: flights to Limassol for you and your family, a company-covered apartment for the first month, and full relocation support to make your move smooth and hassle-free.

  • Transparent performance reviews twice a year, with bonus opportunities and salary adjustments.

  • Private medical insurance for you and your family, a corporate mobile plan (unlimited in Cyprus with roaming included), and interest-free support for car purchases.

  • Mindfulness & well-being support, including psychological assistance with 50% coverage.

  • 50% coverage of school and kindergarten fees for your children.

  • Fully covered sports benefits, and also access to in-house electric scooters and bike rentals, and cycling purchase compensation.

  • Investment in your growth: paid language courses and access to suited-for-you development programs, including conferences, training programs, and coaching to support your professional journey.

  • A culture of recognition: a peer reward program to celebrate your contributions.

  • A fully equipped office in Limassol’s city center, with everything you need for deep work and collaboration.

  • Free catering in the office and an in-house coffee bar with high-quality drinks and a health bar stocked with nutritious snacks.

  • A strong engineering culture: international teams, corporate events, team buildings, and hackathons—because great work happens in great communities.

Recruitment process

  • HR interview (30 min);

  • Technical interview (1.5 hour);

  • Final interview (1 hour).

Навыки
  • SQL
  • Clickhouse
  • Spark
  • Python
Посмотреть контакты работодателя

Похожие вакансии

Хотите оставить вакансию?

Заполните форму и найдите сотрудника всего за несколько минут.
Оставить вакансию