ERP Data Management Engineer - 1 year contract

3321 Johnson Controls BE Operations Mexico S de RL de CV; Monterrey; Sur place; MXN 600 000 - 900 000; Plein temps

Avantages offerts par ce poste

Comprehensive benefits package

Résumé du poste

Johnson Controls in Monterrey, Mexico, seeks an ERP Data Management Engineer to support enterprise data initiatives across ERP systems. You will analyze, extract, transform, validate, and troubleshoot data using SQL, ETL processes, scripts, and data models.

The role requires strong data engineering skills, experience with ERP data, and the ability to collaborate with technical and functional teams. This is a 1-year contract position with opportunities to contribute to critical data initiatives.

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

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

Connaissances

SQL

ETL/ELT

Data profiling

Data modeling

Python

Formation

Bachelor's degree in CS / Data Engineering / IS

Outils

Snowflake

OneStream

SAP

Oracle

Description du poste

Role Overview

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.

This position is a temporary 1 year contract.

What will you do?

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

What are we looking for?

• 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.
• Nice to Have 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.

What do we offer?

• Comprehensive benefits package.
• Opportunities for professional growth and development.
• Supportive and inclusive work environment.
• Commitment to work-life balance and employee well-being.
• Engagement in meaningful projects that make a difference.

This position is a temporary 1 year contract Johnson Controls does not request pregnancy or HIV testing as a condition for hiring, continued employment, or promotion, in accordance with its commitment to labor equality and non-discrimination.

Johnson Controls: Enhancing the Intelligence of Buildings Your buildings have a purpose. They are places for people to live or work. Facilities for learning or healing. Venues for entertainment and shopping. Sites for the specialized storage of tangible goods or mission-critical data. Your buildings have a huge variety of functions; they are central to your mission. This is where Johnson Controls comes in, helping drive the outcomes that matter most. Through a full range of systems and digital solutions, we make your buildings smarter. A smarter building is safer, more comfortable, more efficient, and, ultimately, more sustainable. Most important, smarter buildings let you focus more intensely on your unique mission. Better for your people. Better for your bottom line. Better for the planet. At Johnson Controls, we’ve been making buildings smarter since 1885, and our capabilities, depth of innovation experience, and global reach have been growing ever since. Today, we offer the world’s largest portfolio of building products, technologies, software, and services; we put that portfolio to work to transform the environments where people live, work, learn and play.