Data Engineer - CMDB

Your tasks:

• Design, develop, and maintain data pipelines and workflows using Apache Airflow for efficient data ingestion, transformation, and loading into the CMDB
• Develop and optimize PL/SQL queries and stored procedures for data manipulation and retrieval within the CMDB environment
• Utilize NoSQL databases for handling and processing large volumes of configuration data
• Integrate data from various sources into the CMDB using MuleSoft and other integration platforms
• Conduct data reconciliation activities to ensure data accuracy and consistency across multiple systems and sources
• Develop and implement inventory data models based on the Common Information Model (CIM) to accurately represent IT assets and their relationships
• Design and implement Extract, Transform, and Load (ETL) processes to populate and update the CMDB with accurate and up-to-date information
• Collaborate with cross-functional teams to understand data requirements and ensure the CMDB meets business needs
• Troubleshoot and resolve data-related issues, ensuring data integrity and availability
• Document data processes, data models, and configurations to maintain knowledge and facilitate collaboration

Your profile:

• Proven experience in data engineering and data modeling
• Scripting languages such as Python, Perl and Others
• Strong understanding of Service Asset and Configuration Management (SACM) principles and best practices using Systems such as Microfocus Asset Manager, Peregrine Asset Center or similar (not the ITSM part)
• In-depth knowledge of the Common Information Model (CIM) from DMTF.org
• Proficiency in Apache Airflow for workflow orchestration and automation
• Knowledge of Container Solutions such as iKube 2.0 (preferred), Kubernetes or others
• Extensive experience with PL/SQL for database operations and data manipulation
• Experience working with NoSQL databases (e.g., MongoDB)
• Hands-on experience with MuleSoft or other integration platforms
• Strong data reconciliation and data quality management skills
• Expertise in inventory data modeling and implementation
• Solid understanding of Extract, Transform, and Load (ETL) processes using different Tooling
• Basic Anchor Modelling Skills
• Excellent problem-solving and analytical skills and strong collaboration abilities
• Fluency in English is mandatory, basic knowledge of German is a must