Who we are and what we do
As EF Tours ramps up our digital modernization journey, we are looking for a talented Senior Analytics Engineer to join our dynamic team and help us expand data-driven decision-making within the Travel Department. You will join a team of Analytics Engineering professionals helping to provide data warehousing and modelling solutions which support our stakeholders in operational teams to gain faster and more accurate insights from our data. The data and insights we deliver have a direct impact on the huge number of students and adults travelling with us, as well as the profitability of the business. We operate from the EF global headquarters in Zurich, Switzerland.
The role
You will work closely and build relationships with data engineers, analysts, data scientists and business stakeholders to understand, organize, integrate, clean, test and document our data to provide a well-structured data warehouse following medallion architecture principles.
1. Develop and architect our cloud analytics data warehouse using Snowflake and DBT
2. Develop and maintain dimensional models using Power BI Semantic
3. Develop reports and dashboards in Power BI
4. Build relationships with key partners and routinely present proposals and results
5. Gather and share expertise, best practices and insights internally
6. Partner with cross-functional global teams across engineering and operations to implement data models across the business
Your Profile
You are passionate, smart and thrive in a collaborative environment. We are looking for someone who gets excited about working deeply with data and new approaches to enhance the quality of the customer experience.
7. Strong analytical and problem-solving skills
8. Self-driven and have good communication skills
9. A team-player with an agile mindset
10. Comfortable in a fast-paced environment
11. Excellent organizational skills and highly attentive to detail
12. Keen sense of user experience across interfaces
Requirements
13. Bachelor’s degree in Computer Science, Data Analytics, Engineering, Information Technology or equivalent professional experience
14. 5-7 years of analytics engineering and/or data engineering experience
15. 5-7 years of work experience with dimensional modelling, ETL/ELT or other relevant data pipeline tools
16. Highly proficient working in SQL, Snowflake and DBT
17. Expertise in ingesting, transforming, and consolidating data from structured and unstructured data systems suitable for analytics solutions
18. Proficiency in creating insightful reports/dashboards in Power BI
19. Demonstrated experience using AI-powered tools to enhance SQL development, data modelling, testing, documentation, and debugging
20. Ability to communicate effectively with both technical and business stakeholders
21. A proven team player
EF offers
EF Educational Tours’ operational division is headquartered in the heart of Zurich. We offer a wide range of benefits ready for our full-time staff including:
22. An international and dynamic team situated in our centrally located, brand new office.
23. Free membership for our in-house gym and opportunity to get involved with our variety of sports teams
24. Discounts on a wide range of local restaurants, shops, hotel stays, as well as on EF & Hult products
25. Full reimbursement of the SBB ‘halb-tax’ travel card, covering country-wide public transportation
26. Discounted passes to local destinations and tourist hot-spots such as Mt. Titlis or Kunsthaus Zurich
27. International travel opportunities
28. For parents, on-site Kita (daycare center) with employee discounted rates