ERP Data Engineer - SQL, ETL & Data Pipelines (Contract)

Johnson Controls; San Pedro Garza García; On-site; MXN 500,000 - 800,000; Full time

Benefits offered by this job

Comprehensive benefits package

Opportunities for professional growth

Supportive work environment

Job summary

Johnson Controls is seeking an ERP Data Management Engineer for a 1-year contract to support enterprise data initiatives across ERP systems. You will analyze, extract, transform, validate, and troubleshoot data using SQL, ETL processes, and data models.

Collaboration with technical and functional teams is essential to translate business data requirements into solutions. The role requires 5+ years in data engineering or ERP data roles, a CS-related bachelor's degree, and strong SQL skills.

Qualifications

• 5+ years of experience in data engineering or ERP data roles.
• Bachelor’s degree in CS, Data Engineering, Information Systems, or related field.
• Strong SQL skills with joins, CTEs, aggregations, subqueries.
• Experience with ETL/ELT processes and data pipelines.
• Ability to read, understand, and troubleshoot existing code and scripts.
• Experience with data extraction, reconciliation, and validation.

Responsibilities

• Develop and analyze SQL queries to extract, validate, reconcile, and troubleshoot data across multiple systems.
• Analyze database structures, 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

Data analysis

Root-cause analysis

Cross-functional collaboration

Education

Bachelor's degree in CS or related field

Tools

Python

Snowflake

OneStream

ERP systems (SAP/Oracle/JD Edwards)

Job description

Johnson Controls is seeking an ERP Data Management Engineer for a 1-year contract to support enterprise data initiatives across ERP systems. You will analyze, extract, transform, validate, and troubleshoot data using SQL, ETL processes, and data models.

Collaboration with technical and functional teams is essential to translate business data requirements into solutions. The role requires 5+ years in data engineering or ERP data roles, a CS-related bachelor's degree, and strong SQL skills.