ERP Data Engineer — ETL & SQL Data Pipelines

Johnson Controls, Inc.; San Pedro Garza García; On-site; MXN 600,000 - 1,000,000; Full time

Job summary

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

The role requires collaboration with technical and business teams to translate data requirements into robust data analysis and solutions, with opportunities to work on data platforms and contribute to global building

Qualifications

• 5+ years of experience in data engineering or ERP 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.
• Experience with ETL/ELT processes and data pipelines.
• Ability to read, understand, and troubleshoot existing code and scripts.
• Experience analyzing and troubleshooting data across source and target systems.

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, including extraction, transformation, and loading logic.
• 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

Data modeling

ETL/ELT

Data quality

Cross-functional collaboration

Education

Bachelor's degree

Tools

Snowflake

OneStream

SAP

Oracle

Job description

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

The role requires collaboration with technical and business teams to translate data requirements into robust data analysis and solutions, with opportunities to work on data platforms and contribute to global building