ERP Data Engineer (1-Year Contract) — SQL & ETL Expert

Johnson Controls; Monterrey; On-site; MXN 600,000 - 900,000; Full time

Benefits offered by this job

Comprehensive benefits package

Job summary

Johnson Controls in Monterrey, Mexico, seeks an ERP Data Management Engineer to support enterprise data initiatives across ERP systems. You will analyze, extract, transform, validate, and troubleshoot data using SQL, ETL processes, scripts, and data models.

The role requires strong data engineering skills, experience with ERP data, and the ability to collaborate with technical and functional teams. This is a 1-year contract position with opportunities to contribute to critical data initiatives.

Qualifications

• 5+ years of experience in data engineering, data integration, ERP data, or similar technical data roles.
• Bachelor's degree in Computer Science, Data Engineering, Information Systems, or related field.
• Strong SQL skills with joins, CTEs, aggregations, subqueries, and complex data analysis.
• Strong understanding of relational databases, schemas, tables, keys, and data relationships.
• Experience with ETL/ELT processes and data pipelines.

Responsibilities

• Develop and analyze SQL queries to extract, validate, reconcile, and troubleshoot data across multiple systems.
• Analyze database structures, tables, schemas, relationships, and data models across ERP and enterprise applications.
• Understand and troubleshoot ETL/ELT processes and data pipelines.
• Read and understand existing code, scripts, queries, stored procedures, and transformation logic.
• Trace data from source systems through transformations to target systems to identify data issues and root causes.
• Perform data profiling, reconciliation, and quality analysis across large datasets.
• Document data flows, mappings, transformation rules, dependencies, and technical logic.

Skills

SQL

ETL/ELT

Data profiling

Data modeling

Python

Education

Bachelor's degree in CS / Data Engineering / IS

Tools

Snowflake

OneStream

SAP

Oracle

Job description

Johnson Controls in Monterrey, Mexico, seeks an ERP Data Management Engineer to support enterprise data initiatives across ERP systems. You will analyze, extract, transform, validate, and troubleshoot data using SQL, ETL processes, scripts, and data models.

The role requires strong data engineering skills, experience with ERP data, and the ability to collaborate with technical and functional teams. This is a 1-year contract position with opportunities to contribute to critical data initiatives.