Description
Job Title: Senior Software Engineer - Data Modelling, ETL, CMDB Integration
Main Tasks:
Required Skills:
Nice to Have:
Main Tasks:
-
Design, develop, and maintain data pipelines and workflows using Apache Airflow to ingest, transform, and load data into the Configuration Management Database (CMDB). -
Develop and optimize PL/SQL queries and stored procedures for efficient data manipulation in the CMDB. -
Use NoSQL databases (e.g., MongoDB) to manage large volumes of configuration data. -
Integrate data from multiple sources using MuleSoft and other integration platforms. -
Perform data reconciliation to ensure accuracy and consistency across systems. -
Develop and implement inventory data models based on the Common Information Model (CIM) for IT asset representation. -
Design and execute ETL processes to keep the CMDB updated and accurate. -
Collaborate with cross-functional teams to meet business data requirements. -
Troubleshoot data issues, ensuring data integrity and availability. -
Document data processes, models, and configurations for knowledge sharing and team collaboration.
Required Skills:
-
Proven experience in data engineering, data modeling, and scripting (Python, Perl, etc.). -
Strong knowledge of Service Asset and Configuration Management (SACM) principles and systems like Microfocus Asset Manager or Peregrine Asset Center (non-ITSM). -
Deep understanding of the Common Information Model (CIM) standard. -
Proficiency with Apache Airflow for workflow orchestration. -
Experience building web frontends and backend loading mechanisms. -
Familiarity with container solutions such as iKube 2.0 (preferred), Kubernetes, or similar. -
Extensive PL/SQL skills for database operations. -
Hands-on experience with NoSQL databases and MuleSoft or equivalent integration tools. -
Strong skills in data reconciliation, data quality management, inventory data modeling, and ETL processes. -
Basic Anchor Modelling knowledge. -
Excellent analytical, problem-solving, and collaboration skills.
Nice to Have:
-
Leadership in system environment communities. -
Expertise in Salesforce-MuleSoft integration development. -
Experience with infrastructure inventory on global public cloud providers and hyperscalers.
Location: Zürich, Switzerland
Work Model: Hybrid
Start Date: ASAP
Project Duration: 6 Months +
Workload: 80-100%
Ref. No.: BH 22959