Technical Celonis Developer

Guidehouse; Columbus (OH); On-site; USD 89,000 - 148,000; Full time

Benefits offered by this job

Medical, Rx, Dental & Vision Insurance

401(k) Retirement Plan

Tuition Reimbursement

Job summary

A leading consulting firm located in Columbus, Ohio is seeking a skilled professional to develop and maintain Celonis integrations. This role involves leading data model design, optimizing ETL processes, and collaborating with clients to deliver insights. The ideal candidate will possess 4+ years of experience with process mining tools, strong SQL and Python skills, and effective communication abilities. The position offers a competitive salary range of $89,000 to $148,000 along with comprehensive benefits including medical insurance and a retirement plan.

Qualifications

• Minimum 4 years overall experience with at least 2 years in Celonis or process mining tools.
• Strong proficiency in SQL and PL/SQL, Python, and data modeling.
• Expertise in ETL processes for data extraction and transformation.

Responsibilities

• Develop and maintain Celonis integrations using SQL, Python, and the Celonis Platform.
• Lead the design and implementation of ETL solutions and data models.
• Collaborate with clients to align technical delivery with project goals.

Skills

SQL

Python

Data modeling

Process mining methodologies

Communication skills

Tools

Celonis

ERP systems

Kafka

Job description

Job Family:

Software Development & Support

Travel Required:

Up to 50%

Clearance Required:

None

What You Will Do:

• 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 best practices in Process Intelligence and Automation.
• Provide ongoing support to business and technology teams to ensure continuous improvement.

What You Will Need:

• A minimum of 4 years overall experience, with at least 2 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.

What Would Be Nice To Have:

• 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.

The annual salary range for this position is $89,000.00-$148,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.

What We Offer:

Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.

Benefits include:

• 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

About Guidehouse

Guidehouse is an Equal Opportunity Employer–Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation.

Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.

If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at [e-mail] . All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.

All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including @guidehouse.com or [e-mail] . Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse. Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event. Never provide your banking information to a third party purporting to need that information to proceed in the hiring process.

If any person or organization demands money related to a job opportunity with Guidehouse, please report the matter to Guidehouse’s Ethics Hotline. If you want to check the validity of correspondence you have received, please contact [e-mail] . Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicant’s dealings with unauthorized third parties.

Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.