ERP Data Engineer: ETL, SQL & Data Quality

Johnson Controls; San Pedro Garza García; Presencial; MXN 550.000 - 750.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Comprehensive benefits package

Growth opportunities

Supportive work environment

Work-life balance

Descripción de la vacante

Johnson Controls is seeking an ERP Data Management Engineer to support data initiatives by analyzing, transforming, validating, and troubleshooting data across ERP and related systems.

You will work with SQL, data pipelines, ETL processes, scripts, and data models to understand data movement between source and target systems, collaborating with technical and functional teams to translate business requirements into technical solutions.

Formación

• 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.

Responsabilidades

• 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.

Conocimientos

SQL

Data integration

ETL/ELT

Data analysis

Problem solving

Cross-functional teams

Educación

Bachelor's degree

Computer Science / Data Engineering related

Herramientas

Snowflake

OneStream

SAP

Oracle

JD Edwards

Descripción del empleo

Johnson Controls is seeking an ERP Data Management Engineer to support data initiatives by analyzing, transforming, validating, and troubleshooting data across ERP and related systems.

You will work with SQL, data pipelines, ETL processes, scripts, and data models to understand data movement between source and target systems, collaborating with technical and functional teams to translate business requirements into technical solutions.