Data Warehouse / Business Intelligence Developer

Innovation, Efficiency and Ambition: this is what VAT has stood for over 50 years. 

With this passion, VAT has grown to become the leading international developer, manufacturer and supplier of high-performance high-end vacuum valves and vacuum sealing technology, employing over 2000 people worldwide.  The headquarters are located in Haag (Switzerland), the production centers in Switzerland, Malaysia, Romania and Taiwan. 

As a Senior Data Warehouse / Business Intelligence Developer, you play a key role in ensuring that VAT is a successful data-driven company where every person has the right data and insights available at the right time in the right format to make the right business decisions, improve business processes and deliver value to our customers. You are a part of a global IT team, collaborating across geographies and time zones (our main hubs are in Malaysia, Switzerland and Romania) who is passionate about delivering value through digital BI & data analytics solutions. 

Your responsibilities include, but not limited to –

• Design, develop and maintain the data warehouse and data lake analytics environment at VAT based on the Microsoft Fabric platform, ensuring performant and resilient infrastructure supporting VAT business worldwide 

• Design, develop and maintain end-to-end BI and analytics solutions based on business requirements of various areas of VAT business (procurement, manufacturing, SCM, finance, sales and others) using your expertise across SQL, DAX, Power BI and other applicable technologies within the Microsoft Fabric environment 

• Monitor, extend and troubleshoot existing BI and analytics solutions 

• Support key users and end users of analytics solutions (e.g. semantic models, Power BI reports) on finding the right solution to their technical questions or challenges 

• Collaborate and communicate across technical and business teams to support data-driven decision making at VAT, esp. with other developers, IT business consultants and business and data analysts 

• Work closely with the rest of our BI analytics team in an agile manner (scrum methodology) incl. code reviews and QA 

Preferred Qualification :

• Master’s degree in computer science, information systems, economics, business analytics or similar; or corresponding professional experience 

• Experience with Microsoft Fabric and/or Azure Synapse Analytics 

• Proficiency in Python for Data Analytics or Data Science (pandas, numpy etc.) 

• Microsoft Certification: Fabric Analytics Engineer Associate (DP-600) 

• Microsoft Certification: Fabric Data Engineer Associate (DP-700) 

• Experience in implementing good visual communication standards (e.g. IBCS) 

• Experience in conducting user trainings 

• Experience with the ERP system Microsoft Dynamics 365 Finance and Operations 

• Experience working in an agile manner, applying the scrum methodology 

Minimum Qualification :

• 5+ years working as a DW/BI Developer or Consultant  

• Bachelor’s degree in computer science, information systems, economics, business analytics or similar; or corresponding professional experience 

• Strong proficiency in SQL, DAX and Power BI incl. semantic modelling 

• Expertise in designing, implementing, and managing data pipelines and ETL processes 

• Proven track record in optimizing analytics workloads and platform performance, incl. optimizing complex SQL queries 

• Strong analytical and problem-solving skills with keen attention to detail 

• Experience in translating business requirements into actionable reports and dashboards 

• Excellent teamwork and communication skills to liaise with business as well as technical stakeholders 

• Experience working in a cross-functional and culturally diverse team 

• Full professional proficiency in spoken and written English 

• Ability to work independently under pressure and in a constantly changing environment

VAT is an equal opportunity employer. We see ourselves as a responsible and far-sighted employer that offers not only jobs, but also career and personal development opportunities through various training programs. We recognize the value of employee diversity and provide equal employment opportunity for all qualified application that contributes to innovation, improves customer orientation and employee satisfaction. One-step in this direction is to ensure that people are recognized and fairly compensated for their contributions to the company. In 2021, VAT received the Fair-ON-Pay+ certificate as an acknowledgement for our commitment in ensuring equal pay for equal work between men and women.