Data Analyst ​/ Data Engineer – Process Intelligence & Process Mining

Data Analyst / Data Engineer – Process Intelligence & Process Mining

• Chicago, IL

Position: Data Analyst / Data Engineer – Process Intelligence & Process Mining

Primary Platform: Celonis

Data Environment: Snowflake and Enterprise ERP Systems

Initial Process Scope: Order-to-Cash (O2C) or Procure-to-Pay (P2P)

Employment Type: Full-Time, W2, Chicago Preferred, Hybrid

We are seeking a Data Analyst / Data Engineer to help build our Process Intelligence capability from the ground up using Celonis, Snowflake, and enterprise ERP data. Initially focused on either the Order-to-Cash (O2C) or Procure-to-Pay (P2P) process, this role will own the transformation of ERP data into scalable Celonis process models, develop meaningful PQL-based analytics, and provide actionable insights that improve business performance.

This is a hands‑on implementation role. We are looking for someone who can become productive with limited ramp‑up time and begin contributing almost immediately. The expectation is not that the individual is a senior Celonis expert; however, they should possess enough practical, project-based experience to independently perform common platform tasks, troubleshoot basic issues, and participate in solution delivery without requiring extensive foundational training.

Candidates with approximately six months of genuine hands‑on Celonis project experience who understand how to navigate the platform, work with process and data models, and build basic analytics should be capable of succeeding in this role.

Success requires strong SQL and data engineering skills, an understanding of ERP data structures, practical experience with process mining, and the ability to translate technical analysis into business process improvements while collaborating effectively with both technical and business stakeholders.

This role offers the opportunity to build a new Process Intelligence capability rather than simply maintain an existing analytics environment. Your work will directly influence how the organization understands and improves critical business processes by transforming operational ERP data into actionable process insights.

You will deepen your expertise across Celonis, Snowflake, ERP data architecture, SQL, PQL, process mining, process modeling, and business process optimization while helping establish standards that will support future process intelligence initiatives across the organization.

This opportunity is ideal for someone who enjoys solving complex data challenges, building analytical solutions from the ground up, and helping organizations uncover opportunities to improve operational performance through process mining.

Within the first 30–60 days, establish and validate the data connection between Snowflake and Celonis for the assigned O2C or P2P process. Develop the SQL, transformations, and source‑to‑target mappings necessary to create a reliable analytical foundation while validating data quality and resolving integration issues. Success will be measured by a stable, repeatable data pipeline, validated transformation logic, and stakeholder confidence in the integrity of the underlying data.

AI‑assisted SQL development, data profiling, and documentation tools may be used where appropriate while ensuring all outputs are validated against business rules.

Within the first 60–90 days, develop a validated Celonis process and data model that accurately represents the assigned business process. Construct event logs, define case structures, activities, timestamps, and relationships, and resolve complex ERP data challenges to ensure the model accurately reflects real‑world process execution. Success will be measured through stakeholder validation, model accuracy, technical reliability, and support for meaningful process analysis.

Within the first 90 days, develop PQL‑based KPIs, dashboards, and analytical views that identify bottlenecks, rework, compliance issues, process variants, and other opportunities for operational improvement.…