ERP Data Management Engineer

San Pedro Garza Garcia-Nuevo Leon-Mexicomid

Other

0 views0 saves0 applied

Overview

Johnson Controls is a global leader in smart, healthy, and sustainable buildings. With operations in over 150 countries,

Technical Tools

Other

As an ERP Data Management Engineer, you will support enterprise data initiatives by analyzing, extracting, transforming, validating, and troubleshooting data across ERP and related systems.
This role combines ERP data knowledge with technical data engineering capabilities. You will work with SQL, data pipelines, ETL processes, scripts, and data models to understand how data moves between source and target systems.
The ideal candidate is comfortable working across both technical and functional teams and can translate business data requirements into technical data analysis and solutions.

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.

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.

~1 min read

Experience with Python or another scripting language.
Experience with data platforms and integration technologies such as Snowflake, OneStream or similar technologies.
Experience working with ERP systems such as SAP, Oracle, JD Edwards, Lawson, MAPICS, or similar platforms.