Analytics Engineer

Analytics Engineer  Who we are and what we do As EF Tours ramps up our digital modernization journey, we are looking for a talented Analytics Engineer to join our dynamic team and help us expand data-driven decision-making within operations. You will join a team of Analytics Engineering professionals helping to provide data warehousing and modelling solutions which support our stakeholders in operations to gain a faster and more accurate insights from our data. The data and insights we deliver has 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 roleYou will work closely and build relationships with data engineers, analysts, data scientists and operations business stakeholders to understand, organize, integrate, clean, test and document our data to provide a well structured data warehouse following medallion architecture principles.

• Develop and architect our cloud analytics data warehouse using Snowflake and DBT
• Develop and maintain dimensional models using Power BI Semantic and SSAS tabular data models
• Develop reports and dashboards in Power BI
• Build relationships with key partners and routinely present proposals and results
• Gather and share expertise, best practices and insights internally
• 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. Someone who gets excited about working deeply with data and new approaches to enhance the quality and value of the customer experiences we deliver will fit in best with our team.

• Strong analytical and problem-solving skills
• Self-driven and have good communication skills
• A team-player with an agile mind-set 
• Comfortable in a fast-paced environment
• Excellent organizational skills and highly attentive to detail
• You have a keen sense of user experience and interfaces

Requirements 

• Bachelor’s degree in Computer Science, Data Analytics, Engineering, Information Technology or equivalent professional experience
• 2-5 years of experience analytics engineering and/or data engineering experience
• 2-5 years of work experience with dimensional modeling, ETL/ELT or other relevant data pipeline tools
• Highly proficient working in SQL
• Expertise in ingesting, transforming, and consolidating data from structured and unstructured data systems suitable for analytics solutions
• Proficiency in creating insightful reports/dashboards in Power BI
• Ability to communicate effectively with both technical and business stakeholders
• A proven team player

Other useful skills include:

• Experience with DBT is a great plus
• Experience with Snowflake is a great plus
• Experience with Git
• Experience with SQL Server
• Experience with Agile/Scrum/Kanban methodologies
• Experience with Prefect
• Experience with Salesforce
• Enthusiasm to work anywhere in the stack, especially in unfamiliar areas

   EF Educational Tours’ operational division is headquartered in the heart of Zurich, in the newly renovated office by the river Sihl. We offer a wide range of benefits ready for our full time staff including:  • Hybrid work model    • Full reimbursement of the SBB ‘halb-tax’ travel card, covering country-wide public transportation   • Discounted passes to local destinations and tourist hot-spots such as mt. Titlis or Kunsthaus Zurich    • Tuition reimbursement of 1500 CHF for professional development once per year    • Participation in our Staff Travel Experience Program once a year including travel on one of our tours    • Yearly kick off conference around the world   • Free membership for our newly built gym or get involved with our variety of sports teams   •  Seasonal and monthly office events including holiday parties, ski trips and pay-day happy hours   •  Discounts on a wide range of local restaurants, shops, hotel stays and EF products   •  15% off in-house childcare service    • Discounts on EF & Hult products for staff and family members    About EF Education First  At EF we believe that the world is better when people try to understand one another. Since 1965, we have helped millions of people see new places, experience new cultures, and learn new things about the world and about themselves. Our culturally immersive education programs—focused on language, travel, cultural exchange, and academics—turn dreams into international opportunities. When you join EF, you join a multicultural and diverse community working across more than 600 schools and offices in 50 countries, all with one shared mission of opening the world through education. Whoever you are, whatever you are passionate about—we welcome you and want you to bring that to work every day. EF is proud to be an equal opportunity employer and we are committed to inclusion and belonging across race, ethnicity, gender, age, religion, caste, parental status, identity, experience and everything else that makes you unique. Founded in Sweden in 1965, EF has schools and offices around the world, including hubs in Boston, London, Mexico City, São Paulo, Shanghai, Stockholm, Zürich, and more. Learn more at https://www.ef.com.