AI Summary
Join Mayflower as an Analytics Engineer to develop and maintain data marts, write and optimize SQL queries, and collaborate with analysts to understand data needs.
Key Highlights
Transform business requirements into data models and ETL processes
Develop and maintain data marts using DBT
Collaborate with analysts to understand data needs
Key Responsibilities
Transform business requirements into data models and ETL processes
Develop and maintain data marts using DBT
Collaborate with analysts to understand data needs
Optimize ETL pipelines and query performance
Monitor and troubleshoot data pipeline issues
Technical Skills Required
Benefits & Perks
EU-based employment contract
3-year Cyprus work visa
Full relocation package
Transparent performance reviews
Private medical insurance
Corporate mobile plan
Interest-free support for car purchases
Mindfulness & well-being support
50% coverage of school and kindergarten fees
Fully covered sports benefits
Access to in-house electric scooters and bike rentals
Cycling purchase compensation
Paid language courses
Access to suited-for-you development programs
Peer reward program
Nice to Have
Understanding of execution plans and performance optimization
Knowledge of OLAP systems specifics
Job Description
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
- Complex analytical queries (window functions, CTEs, subqueries)
- Knowledge of OLAP systems specifics
- Understanding of execution plans and performance optimization (as a plus)
Looking to advance your Development & Programming career with relocation support? Explore Development & Programming Jobs with Relocation Packages that include comprehensive packages to help you move and settle in your new role.
- Data processing (pandas, polars)
- Task automation (Airflow)
- Building transformation DAGs
- Incremental models and snapshots
- Model documentation
- Data testing experience will be a plus
- Understanding business processes and their reflection in data
- Ability to translate business requirements into technical solutions
- Knowledge of metrics and KPIs
- Spark, including PySpark
- Iceberg
- Clickhouse
Discover our full range of relocation jobs with comprehensive support packages to help you relocate and settle in your new location.
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.
- HR interview (30 min);
- Technical interview (1.5 hour);
- Final interview (1 hour).
- vacancy_type: Analytics
- Experience shown on site: 3+ years of experience
Similar Jobs
Explore other opportunities that match your interests
Senior Paid Search Specialist
••••••
••••••
••••••
Job Type
••••••
Experience Level
••••••
Palta
Cyprus
Visa Sponsorship
Relocation
Remote
Job Type
Full-time
Experience Level
Not Applicable
Palta
Cyprus
Visa Sponsorship
Relocation
Remote
Job Type
Full-time
Experience Level
Mid-Senior level
lapitopa
Cyprus