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 processesDevelop and maintain data marts (Spark, Iceberg, Clickhouse) using DBTWrite and optimize SQL queries for analytical tasksDocument data models and business logicEnsure data quality through automated testsCollaborate with analysts to understand data needsOptimize ETL pipelines and query performanceMonitor and troubleshoot data pipeline issuesParticipate 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 specificsUnderstanding of execution plans and performance optimization (as a plus) Python (intermediate Level) Data processing (pandas, polars)Task automation (Airflow) DBT Building transformation DAGsIncremental models and snapshotsModel documentationData testing experience will be a plus Analytical Thinking Understanding business processes and their reflection in dataAbility to translate business requirements into technical solutionsKnowledge of metrics and KPIs That Can Be a Plus Spark, including PySparkIcebergClickhouse 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 residenceFull 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 familyCorporate 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 rentalsProfessional 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: AnalyticsExperience shown on site: 3+ years of experience