Skip to main contentA logo with &quat;the muse&quat; in dark blue text.
EF Education First

DWH Engineer / Senior DWH Engineer

3+ months agoZurich, Switzerland

EF Education First is a global education company focusing on language, academic, cultural exchange, and educational travel programs. We are +40,000 staff, faculty and teachers, working in over 580 offices and schools across 52 countries, and having a global presence in 116 countries.

In your role as a (Senior) Data Warehouse Engineer you will: 

  • Collaborate with application teams to determine appropriate schema design and database platforms.
  • Provide expert troubleshooting support and proactively improve database and server performance.
  • Lead efforts to automate cloud operations and infrastructure, balancing cost and performance.
  • Orchestrate the work for data developers (JIRA, Github, reviews, ...)
  • Migrate and transform data to Snowflake.

What do you bring along?
  • Masters or PhD in Computer Science, Physics, Engineering or Math or equivalent professional.
  • 4+ years’ experience in Data Warehouse Engineering and Database Development.
  • Knowledge of SQL Server Database Administrator (2014/2016/2019).
  • Excellent SQL and strong hands-on scripting experience in implementation and performance tuning SQL databases.
  • Experience designing database environments, analyzing production deployments, and making recommendations to optimize performance.
  • Experience in SSIS.
  • Basic knowledge of Kimball Dimensional Modeling.
  • Preferably you have hands on experience in data warehousing design, tuning and ETL/ELT process developmentusing Matillion.
  • Interest in Snowflake (data modelling, ELT using Snowflake SQL, implementing complex stored Procedures or Tasks, ...)

What we offer:

The ability to learn new technologies and explore new database engines in an autonomous environment. 
The possibility to drive the vision, evolution, and innovation of the intelligent big data warehouse and data governance initiatives.
The power of helping and enabling engineers to grow and flourish in a relatively flat engineering organization.

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 school 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://ef.com.

Job ID: oLLXffws
Employment Type: Other