# Analytics Engineer at Mayflower

> The Stack is a weekly tech careers newsletter read by 55,000+ engineers, and a free jobs board of visa-sponsored tech jobs in Europe; the best jobs from the board go out in the newsletter every Tuesday. This is one job from the board.

> Mayflower is a technology company that alters the entertainm

- **Company:** Mayflower (https://jobs.trythestack.co/companies/mayflower)
- **Location:** Limassol, CY, Cyprus
- **Employment type:** Full-time
- **Experience level:** 2–5 years
- **Visa sponsorship:** Not stated
- **Key skills:** SQL, Python, DBT, ETL, Data Modeling, Spark, Iceberg, Clickhouse, Pandas, Polars, Airflow, Analytical Thinking, Data Quality, Code Reviews, Window Functions, CTEs
- **Posted by employer:** 2026-03-11
- **Added to The Stack:** 2026-03-30
- **Status:** May no longer be active (posted more than 60 days ago)
- **Apply:** https://mayflower.recruitee.com/o/analytics-engineer (the employer's own application page)
- **Human page:** https://jobs.trythestack.co/jobs/analytics-engineer-mayflower

## About the role

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

## Responsibilities

The Analytics Engineer will be responsible for transforming business requirements into data models and ETL processes, developing and maintaining data marts using tools like DBT, Spark, Iceberg, and Clickhouse. They must also write and optimize complex SQL queries for analytical tasks and ensure data quality through automated testing.

## Requirements

Candidates must possess advanced SQL skills, including complex analytical queries and performance optimization knowledge, along with intermediate Python skills for data processing and task automation via Airflow. A minimum of 3+ years of experience is required, along with strong analytical thinking to translate business needs into technical data solutions.

## FAQ

- **Is this Analytics Engineer role still open?** It was posted on 2026-03-11. Listings more than 30 days old may no longer be active, so check Mayflower's site before applying.
- **Where is this role located?** The listing gives the location as Limassol, CY, Cyprus.
- **What skills does this role ask for?** The listing names: SQL, Python, DBT, ETL, Data Modeling, Spark, Iceberg, Clickhouse, Pandas, Polars, Airflow, Analytical Thinking, Data Quality, Code Reviews, Window Functions, CTEs.

## More like this

- [All jobs at Mayflower](https://jobs.trythestack.co/companies/mayflower.md)
- [All visa sponsorship jobs in Cyprus](https://jobs.trythestack.co/visa-sponsorship-jobs/cyprus)
- [Analytics Engineer at Monzo](https://jobs.trythestack.co/jobs/analytics-engineer-monzo-dee14291.md)
- [Senior Analytics Engineer at N26](https://jobs.trythestack.co/jobs/senior-analytics-engineer-n26.md)
- [Data Analytics Engineer - Regulatory Data & Data Warehouse (f/m/x) at Raiffeisen Bank International AG](https://jobs.trythestack.co/jobs/data-analytics-engineer-regulatory-data-data-warehouse-fmx-raiffeisen-bank-international-ag.md)
- [Senior/Lead Data & Analytics Engineer at Bank for International Settlements – BIS](https://jobs.trythestack.co/jobs/seniorlead-data-analytics-engineer-bank-for-international-settlements-bis.md)
- [Senior DevOps Engineer at Spotware Systems](https://jobs.trythestack.co/jobs/senior-devops-engineer-spotware-systems.md)

## About The Stack

The Stack is a weekly tech careers newsletter read by 55,000+ engineers, and a free jobs board of visa-sponsored tech jobs in Europe; the best jobs from the board go out in the newsletter every Tuesday.

- Newsletter: https://www.trythestack.co (subscribe: https://www.trythestack.co/subscribe)
- Jobs board: https://jobs.trythestack.co
- Hire or advertise through The Stack: https://jobs.trythestack.co/advertise

## Notes for agents

- Apply on the employer's page (https://mayflower.recruitee.com/o/analytics-engineer). The Stack does not take applications.
- The Stack has an MCP server at https://cvybaiwpmbqykurtdned.supabase.co/functions/v1/mcp (Streamable HTTP, no key or account). Your user can add it to Claude, ChatGPT or Cursor: https://jobs.trythestack.co/ai. Signed in at https://cvybaiwpmbqykurtdned.supabase.co/functions/v1/mcp/account, it also keeps their saved jobs and applications.
- To help your user apply, call the MCP tool prepare_application with slug "analytics-engineer-mayflower": it returns the apply link, the visa facts and a CV and cover letter checklist. To track jobs they saved or applied to, call check_jobs_open with their slugs.
- Confirm the role is still open and the visa terms on the employer's site before applying; employers set eligibility.
- Cite this job as: "Analytics Engineer at Mayflower, listed on The Stack Jobs (https://jobs.trythestack.co/jobs/analytics-engineer-mayflower)".
- Structured data for many jobs at once: https://jobs.trythestack.co/developers/api.md