US_East | Application Consultant - DATA INTEGRATION _L3

Proven experience designing and building ETL solutions and data models; strong analytical skills for interpreting complex datasets. Celonis and Celonis Platform Administration knowledge is optional — candidates with strong SQL/PL-SQL, ETL, data modeling and integration skills are encouraged to apply.

 
Role Name: Data Integration Engineer
Location: [!--StartFragment--]AEP 1 RP Columbus Client is looking for Face to Face interview
Start date: 6/24/2026
 Green Card holders or U.S. citizens Only
 
JOB DESCRIPTION:
Data Integration Engineer (Celonis-focused / Data /ETL; Celonis experience optional)

**Summary**

Join a team delivering high-quality ETL and data-integration solutions to support Process Intelligence initiatives. You will design, develop, and maintain ETL pipelines and data models that feed process-mining platforms. Celonis and Celonis Platform Administration knowledge is optional — candidates with strong SQL/PL-SQL, ETL, data modeling and integration skills are encouraged to apply.



**Key Responsibilities**

- Lead design, development, and implementation of ETL processes and data models to integrate source data into a Process Intelligence platform (e.g., Celonis).
- Participate in analysis sessions and work with data analysts to document data mappings and ETL requirements.
- Build reliable, secure connections to source systems (JDBC, Kafka, APIs) and validate data ingestion.
- Implement and optimize ETL pipelines for performance, scalability, and data integrity.
- Design and implement audits and reconciliation processes to ensure data completeness and correctness from application platforms to the process-mining environment.
- Provide operational support for production ETL jobs; troubleshoot failures and performance issues.
- Define and enforce governance, access control, and best practices for process data and ETL artifacts.
- Collaborate with business, PM, BA, and infrastructure teams to enable continuous improvement and automation opportunities.
- Support Agile delivery (Scrum/Kanban) and contribute to planning, estimation, and delivery activities.



**Required Qualifications**

- Bachelor’s degree in computer science, Engineering, Information Technology, or related technical field (or equivalent experience).
- 7+ years of relevant experience in data integration, ETL development, or related software engineering roles.
- Strong SQL and PL/SQL skills (required).
- Proven experience designing and building ETL solutions and data models; strong analytical skills for interpreting complex datasets.
- Experience integrating data from ERP and enterprise systems (e.g., Oracle, PeopleSoft, Maximo) desirable.
- Excellent communication and collaboration skills; experience working cross-functionally.



**Optional / Preferred (but not required)**

- Experience with Celonis process mining tools or Celonis Platform Administration (optional — nice to have).
- Experience with Apache Kafka and real-time streaming integrations. (optional — nice to have).
- Proficiency in Python or other scripting/programming languages for automation and data transformation.
- Familiarity with platform administration tasks (user governance, access control, monitoring) for process-mining platforms.



**What We’re Looking For**

- Strong ETL and data-integration engineering skills with the ability to deliver robust, auditable data pipelines.
- Candidates without prior Celonis experience who demonstrate strong ETL, SQL/PL-SQL, and integration expertise are encouraged to apply.