
Data Engineer
HRS Healthcare
full-time
Posted on:
Location Type: Remote
Location: Mexico
Visit company websiteExplore more
About the role
- 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.
Benefits
- 100% payroll + benefits by law
- Work from home (Anywhere in México)
- 30-day Christmas bonus
- 16 vacation days
- 1 economic day a year
- Grocery coupons
- Savings fund
- Home office stipend
- Major medical insurance
- Life insurance
- Training & certifications
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
SQLPythonCelonis Data IntegrationData WarehousingData ModelingETLELTProcess Query Language (PQL)Data CleansingData Transformation
Soft Skills
Analytical skillsProblem-solving skillsAttention to detailVerbal communicationWritten communicationCollaborationTechnical support