Technical Celonis Developer

Guidehouse•Columbus, OH

1d•Hybrid

About The Position

Guidehouse is seeking a Technical Celonis Developer to join their team. This role involves developing and maintaining Celonis integrations, including ETL pipelines and data connectors, using SQL, Python, and the Celonis Platform. The developer will lead the design, development, and implementation of data models and ETL solutions, build process intelligence solution views, analyses, and dashboards, and design and implement scalable data ingestion processes from ERP systems and third-party applications. Responsibilities also include ensuring reliable and secure connections to source systems, performing ETL operations, troubleshooting data connections, validating datasets, optimizing Celonis data models and ETL processes, designing and implementing audit processes, governing access rights, and providing operational support for the Celonis production platform. The role requires collaboration with clients, Celonis teams, and third-party resources, participation in workshops and demos, and facilitating the establishment of governance and Process Intelligence best practices. Ongoing support to business and technology teams for continuous improvement is also expected.

Requirements

A MINIMUM of FOUR (4) years of overall system development experience, with at least 4 years hands-on in Celonis or process mining tools
Strong understanding of process mining methodologies, process improvement frameworks, and business process management (BPM).
Strong proficiency in SQL and PL/SQL (must-have), Python, and data modeling.
Expertise in ETL processes for data extraction and transformation.
Proven experience with Celonis features and capabilities, including data model optimization.
Ability to interpret complex data and deliver meaningful business insights.
Excellent communication and interpersonal skills with a strong collaboration mindset.

Nice To Haves

Celonis Analyst and Data Engineer certifications.
Experience with streaming technologies (e.g., Kafka) for real-time data integration.
Proven experience with ERP systems and related databases.
Familiarity with agile delivery methodologies (Scrum, Kanban) and enterprise change initiatives.
Exposure to process automation best practices and governance frameworks.

Responsibilities

Develop and maintain Celonis integrations, including ETL (Extract, Transform, Load) pipelines and data connectors, leveraging SQL, Python, and the Celonis Platform.
Lead the design, development, and implementation of data models and ETL solutions to integrate functional data into Celonis.
Build process intelligence solution views, analyses, and dashboards to enable actionable insights for clients.
Design and implement scalable data ingestion processes from ERP systems and third-party applications.
Ensure reliable and secure connections to source systems using technologies such as JDBC for database connectivity and Kafka for real-time data streaming.
Perform ETL operations, troubleshoot data connections, and validate large datasets for accuracy and performance.
Optimize Celonis data models and ETL processes for performance and scalability.
Design, develop, and implement audit processes to ensure data integrity from application platforms to Celonis.
Govern access rights for Celonis processes and maintain operational support for the Celonis production platform.
Collaborate with clients, Celonis teams, and third-party resources to align technical delivery with project goals.
Participate in workshops, demos, and client-facing sessions to showcase technical capabilities.
Facilitate and lead the establishment of governance and Process Intelligence best practices.
Provide ongoing support to business and technology teams to ensure continuous improvement.

Benefits

Medical, Rx, Dental & Vision Insurance
Personal and Family Sick Time & Company Paid Holidays
Parental Leave
401(k) Retirement Plan
Group Term Life and Travel Assistance
Voluntary Life and AD&D Insurance
Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts
Transit and Parking Commuter Benefits
Short-Term & Long-Term Disability
Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities
Employee Referral Program
Corporate Sponsored Events & Community Outreach
Care.com annual membership
Employee Assistance Program
Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.)
Position may be eligible for a discretionary variable incentive bonus