ERP Data Engineer: ETL, SQL & Data Integrity

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

Benefits offered by this job

Comprehensive benefits package.

Opportunities for professional growth/

Supportive and inclusive work environ.

Commitment to work-life balance and 직원

Job summary

Johnson Controls, a global leader in building technologies, seeks an ERP Data Management Engineer in Monterrey to drive data initiatives across ERP systems. You will analyze, transform, and validate data, and work with SQL, ETL processes, and data models to ensure data quality.

You will collaborate with technical and functional teams to translate business requirements into robust data solutions, document data flows, and troubleshoot data issues across source and target systems.

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, including 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.
• Ability to read, understand, and troubleshoot existing code and scripts.
• Experience analyzing and troubleshooting data across source and target systems.
• Experience with data extraction, transformation, reconciliation, and validation.
• Strong analytical and root-cause problem-solving skills.
• Ability to work across technical, functional, and business teams.

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

ETL/ELT

Data modeling

Root-cause analysis

Cross-functional collaboration

Education

Bachelor's degree in Computer Science, Data Engineering, Information Systems

Tools

Snowflake

SAP

Oracle

Job description

Johnson Controls, a global leader in building technologies, seeks an ERP Data Management Engineer in Monterrey to drive data initiatives across ERP systems. You will analyze, transform, and validate data, and work with SQL, ETL processes, and data models to ensure data quality.

You will collaborate with technical and functional teams to translate business requirements into robust data solutions, document data flows, and troubleshoot data issues across source and target systems.