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