Software/Data Engineer - Data Modelling, ETL, CMDB

Job Title: Senior Software/Data Engineer - Data Modelling, ETL, CMDB Integration

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 (eg, 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 modelling, 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 Back End 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 modelling, 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