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

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).
• vacancy_type: Analytics
• Experience shown on site: 3+ years of experience