DATA ENGINEER – MICROSOFT FABRIC (a) 100 %
We are a dynamic, fast-growing family business and one of the leading mid-sized fragrance houses. Our diversity is reflected in our highly international customer base as well as in our team-oriented and motivated colleagues. Our success is not only due to our creative capabilities but also to our unique and sustainable quality, as well as our responsible approach to external partners and employees. In our exceptional company building, you will find not only studio-like creative laboratories and offices but also state-of-the-art industrial production facilities.
As part of our growth strategy, we are filling the above-mentioned position at our headquarters in Dietlikon (Zurich).
JOB SUMMARY
In this role, you will actively contribute to building our central data platform based on Microsoft Fabric and OneLake. You will develop reliable data pipelines, integrate data from various business systems and establish the technical foundation for meaningful analyses and reports. Working closely with our Business Analysts and internal departments, you will play a key role in continuously developing our data architecture, data quality and analytics solutions.
WHAT YOU WILL DO
- Build, operate and continuously develop our central data platform using Microsoft Fabric and OneLake, ensuring a scalable and high-performance architecture.
- Develop and maintain data pipelines to integrate various source systems, particularly Abacus/c-tree, Microsoft SQL Server and MySQL.
- Design and implement efficient ETL/ELT processes to extract, transform and provide business data.
- Structure and prepare our data according to the Medallion architecture (Bronze, Silver and Gold) as the foundation for Semantic Models and Power BI reports.
- Collaborate closely with Business Analysts and internal stakeholders to translate business reporting requirements into appropriate data models and structures.
- Ensure high data quality while monitoring and continuously optimising data flows and Microsoft Fabric capacities.
- Provide technical support in the creation and further development of Semantic Models and Power BI reports.
- Actively contribute to shaping our Data Governance and technical standards for Data Engineering, Analytics and Reporting.
WHAT WE EXPECT
- Completed vocational education or further qualification in Computer Science, Software Development, Data Engineering, Data Analytics or a comparable field (Swiss Federal VET Diploma, Higher Professional Education or University of Applied Sciences).
- Several years of practical experience in Data Engineering, Data Analytics or Business Intelligence.
- Solid knowledge of Python, PySpark and SQL, as well as experience with relational database systems, particularly Microsoft SQL Server and MySQL.
- Practical experience in developing and operating data pipelines and working with ETL/ELT processes.
- Knowledge of Microsoft Fabric and OneLake, or the motivation to develop in-depth expertise in these technologies.
- Experience with Power BI and Semantic Models is an advantage.
- Strong analytical thinking skills and a structured, independent and solution-oriented approach to work, with a high awareness of quality.
- Enjoy working with different departments and have the ability to communicate complex technical concepts clearly and understandably.
- Very good German skills and good English skills, both written and spoken.
WHAT WE OFFER
- Comprehensive onboarding provided by our experienced IT team, offering extensive and diverse expertise.
- An open and friendly company culture.
- Hybrid working.
- Individual development opportunities.
- Work in an international and multicultural environment with development centres in Switzerland, France and Malaysia, as well as various sales offices worldwide.
- An inspiring working environment in one of the most modern buildings in the industry.
- Attractive fringe benefits.
We look forward to receiving your application including your salary expectations via our Jobportal.