Design, develop, and maintain performant and scalable data pipelines to ingest, transform, and load data from various source systems into the Celonis platform.
Create, integrate, maintain, and optimize the SQL Server DataWarehouse pipelines.
Utilize Celonis Data Integration to build and optimize complex data models, ensuring data accuracy and consistency.
Collaborate with business analysts and process owners to translate business requirements into technical data specifications for process mining analyses.
Write and optimize SQL queries and Celonis's Process Query Language (PQL) to support the development of Celonis analyses and dashboards.
Develop Python scripts to perform data cleansing, complex transformations, and automation tasks within the data pipeline.
Implement and monitor audit processes to ensure data integrity between source systems, SQL Server, and the Celonis platform.
Provide ongoing technical support for the Celonis platform and assist end-users with data-related technical issues.
Adhere to best practices for data governance, access rights management, and platform security.
Requirements
2+ years of hands-on, practical experience with the Celonis platform (ideally case centric experience) including Celonis Data backend Integration, frontend development and Action Flows.
Solid experience with SQL programming for data extraction, transformation, and query optimization.
Proficiency in Python scripting for data manipulation, automation, and complex data processing.
A strong understanding of data engineering principles, ETL/ELT processes, and data modeling techniques.
Experience working in an Agile/Scrum environment is preferred.
Excellent analytical and problem-solving skills, with a keen attention to detail.
Effective verbal and written communication skills for collaborating with technical and non-technical stakeholders.