All around the globe customers rely on our safe connecting solutions. But we are also a reliable partner for our employees. About 1,800 colleagues in more than 30 countries play their part in ensuring that our products optimally combine mission-critical components. Whether it’s motors, airbags or heart pumps – every day we develop connecting solutions for a wide variety of industries and thus take important steps towards a better future. Would you like to be a part of it? Find your peace of mind!

Provide Oetiker business with source data and data services for efficient, effective, fact-based decision making.

The position holder is responsible for the conceptual design and development of the load processes of SAP & Non-SAP Data Sources as well as for the design and implementation of data models, data marts and semantic models in the BI tool

WHAT YOU'LL DO

BI Backend: 

• Technical specification, design, implementation, and documentation in the area of Oetiker BI:
  - Extraction Transformation Loading (ETL) of SAP & Non-SAP Data Sources, structured and unstructured data
  - Data & Layer modelling
  - Scheduling & Monitoring
• Performance tuning, optimization of ETL processes, housekeeping on SAP HANA and system upgrades
• Assurance of information integrity and data quality through processes and tools for assessing missing values, completeness, reliability, audit trails and accuracy of data
• Incident and problem management in case of operational issues in the area of the BI system
• Testing activities
• Design and implementation of data models and data solutions to extract data from various source systems
• Key team member of projects realized in BI, conceptual design and implementation of new business requirements
• Reengineering and enhancing of BI models, components, data structure and data integration to guarantee an efficient system

BI Frontend: 

• Design and further development of standardized KPIs and reports and execution of complex ad-hoc analysis
• Maintaining the requirement process, definition and documentation of detailed specifications for new or changed reports in conjunction with KPI / report owners
• Consult, train and support business users in the area of analytics and reporting in the BI frontend tools (SAP AO & SAC)
• Testing activities
• Control and further development of the compliance of data quality standards and recommendation and coordination on necessary data quality improvement activities in BI and source systems

WHAT YOU’LL NEED

• Knowledge on SAP BW on HANA
• Knowledge on DWH Architecture and on tools for data integration (ETL Tool)
• Knowledge on BI frontend tools (SAP Analysis for Office, SAP Design Studio, SAP Analytics Cloud)
• Knowledge on web service integrations using REST API’s
• Knowledge on data modelling & data structuring
• Knowledge on dashboard and report design
• Knowledge on data analysis techniques
• Good communication & training skills, able to interact effectively with people
• Structured way of working and documentation of work
• BI project experience
• Good understanding of cross-functional and cross-system dependencies
• Experience in algorithms and predictive analytics would be beneficial
• University degree in the area of IT / Data Science / Technology / Economics
• 3-4 years experience in ETL / modelling services or similar position
• Proficient in English
• Willingness to do some business travels (up to 5%)

WHAT YOU’LL GET

• Freedom for personal growth in a  team with a unique culture
• A friendly working atmosphere
• Flexibility regarding working hours and location
• Fair compensation and attractive benefits

For more than 75 years, Oetiker has been a leading manufacturer of high-end connecting solutions for OEMs worldwide. As an employer, we offer our employees attractive international challenges and many development opportunities. Diversity and high quality standards are the foundation of our corporate culture. This way, we combine the visions of today with the technology of tomorrow.

We strongly encourage equal rights and gender equality. At Oetiker, everyone has the same possibilities to grow and develop with us.

Get to know us to get ahead.