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

Requirements

You’ll thrive here if you have

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).

Data Warehouse Engineer