Senior Software Developer - Data Modelling, ETL, CMDB

RM IT Services GmbH; Zürich; Vor Ort; CHF 100’000 - 130’000; Vollzeit

Zusammenfassung

A leading company in IT services is seeking a Senior Software Engineer specializing in Data Modelling and ETL processes. The role involves designing and maintaining data pipelines, optimizing queries, and integrating data from various sources. This hybrid position offers a dynamic work environment and the opportunity to work on critical data management projects.

Qualifikationen

• Proven experience in data engineering and modeling.
• Strong knowledge of SACM principles and systems.
• Proficiency with Apache Airflow for workflow orchestration.

Aufgaben

• Design and maintain data pipelines using Apache Airflow.
• Develop PL/SQL queries for efficient data manipulation.
• Integrate data from multiple sources using MuleSoft.

Kenntnisse

Data Engineering

Data Modeling

Python

PL/SQL

NoSQL

ETL Processes

Data Reconciliation

Collaboration

Problem-Solving

Tools

Apache Airflow

MuleSoft

MongoDB

Kubernetes

Jobbeschreibung

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

Main Tasks:

1. Design, develop, and maintain data pipelines and workflows using Apache Airflow to ingest, transform, and load data into the Configuration Management Database (CMDB).
2. Develop and optimize PL/SQL queries and stored procedures for efficient data manipulation in the CMDB.
3. Use NoSQL databases (e.g., MongoDB) to manage large volumes of configuration data.
4. Integrate data from multiple sources using MuleSoft and other integration platforms.
5. Perform data reconciliation to ensure accuracy and consistency across systems.
6. Develop and implement inventory data models based on the Common Information Model (CIM) for IT asset representation.
7. Design and execute ETL processes to keep the CMDB updated and accurate.
8. Collaborate with cross-functional teams to meet business data requirements.
9. Troubleshoot data issues, ensuring data integrity and availability.
10. Document data processes, models, and configurations for knowledge sharing and team collaboration.

Required Skills:

1. Proven experience in data engineering, data modeling, and scripting (Python, Perl, etc.).
2. Strong knowledge of Service Asset and Configuration Management (SACM) principles and systems like Microfocus Asset Manager or Peregrine Asset Center (non-ITSM).
3. Deep understanding of the Common Information Model (CIM) standard.
4. Proficiency with Apache Airflow for workflow orchestration.
5. Experience building web frontends and backend loading mechanisms.
6. Familiarity with container solutions such as iKube 2.0 (preferred), Kubernetes, or similar.
7. Extensive PL/SQL skills for database operations.
8. Hands-on experience with NoSQL databases and MuleSoft or equivalent integration tools.
9. Strong skills in data reconciliation, data quality management, inventory data modeling, and ETL processes.
10. Basic Anchor Modelling knowledge.
11. Excellent analytical, problem-solving, and collaboration skills.

Nice to Have:

1. Leadership in system environment communities.
2. Expertise in Salesforce-MuleSoft integration development.
3. 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