ERP Data Engineer & ETL Specialist

Johnson Controls; San Pedro Garza García; Sur place; MXN 450 000 - 650 000; Plein temps

Avantages offerts par ce poste

Comprehensive benefits package

Résumé du poste

Johnson Controls is seeking an ERP Data Management Engineer in Mexico to support enterprise data initiatives by analyzing, extracting, transforming, validating, and troubleshooting data across ERP systems. The role blends ERP data knowledge with technical data engineering, working with SQL, data pipelines, ETL processes, and data models.

The ideal candidate has 5+ years in data engineering or ERP data roles, strong SQL skills, experience with ETL/ELT, and the ability to collaborate with

Qualifications

• 5+ years of experience in data engineering, data integration, ERP data, or similar technical data roles.
• Strong SQL skills, including joins, CTEs, aggregations, subqueries, and complex data analysis.
• Experience with ETL/ELT processes and data pipelines.

Responsabilités

• 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.
• Document data flows, mappings, transformation rules, dependencies, and technical logic.

Connaissances

SQL

ETL

Data profiling

Root-cause analysis

Formation

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

Outils

SQL-based tooling

Description du poste

Johnson Controls is seeking an ERP Data Management Engineer in Mexico to support enterprise data initiatives by analyzing, extracting, transforming, validating, and troubleshooting data across ERP systems. The role blends ERP data knowledge with technical data engineering, working with SQL, data pipelines, ETL processes, and data models.

The ideal candidate has 5+ years in data engineering or ERP data roles, strong SQL skills, experience with ETL/ELT, and the ability to collaborate with