Data Warehouse 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

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.

• EU passport. Opportunity to obtain an EU passport after 4 years of residence

• 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

• Corporate mobile plan (unlimited in Cyprus with roaming included)

• 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

• Professional growth support: language courses, conferences, training programs, and coaching.

• Peer recognition program: receive and share kudos for great work.

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

• Free breakfasts and lunches 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).