Procurement Data Engineer III

YDU JC Air Cond & Ref Inc.- Dubai; Monterrey; Presencial; MXN 600.000 - 1.000.000; Jornada completa

Descripción de la vacante

Johnson Controls seeks a Data Engineer to join the Procurement Execution Center, driving end-to-end data management across BI and reporting initiatives. You will design, implement and optimize ETL/ELT pipelines, data models and governance controls to support enterprise analytics.

You will collaborate with cross-functional teams spanning fleet, energy, travel and services, mentor junior engineers, and contribute to the data platform strategy while ensuring scalable cloud-native architectures and

Formación

• Bachelor’s degree in Engineering, Computer Science, Data Science or related field.
• 5+ years of BI/Data Engineering experience with data modeling and pipelines.
• Strong SQL and data warehousing concepts; Azure cloud experience a must.

Responsabilidades

• Deliver end-to-end data management including ETL/ELT pipelines and data governance.
• Build and optimize data models for BI and analytics across multiple domains.
• Maintain data quality, metadata, and data vaults; support data platform governance.
• Collaborate with business and tech teams; contribute to product strategy.
• Mentor junior data engineers and drive engineering best practices.

Conocimientos

SQL

Azure Data Factory

dbt

Python

Azure Synapse

Data Modeling

NoSQL

Educación

Bachelor’s degree in Engineering/CS/Data Science

Herramientas

Azure Data Factory

Snowflake

dbt

Python

Azure Synapse

Azure DevOps

Descripción del empleo

Join us in the Procurement Execution Center (PEC) as a Data Engineer as part of a is a diverse team of data and procurement individuals.

In this role, you will be responsible for deploying supporting the E2E management of our data, including: ETL/ELT, DW/DL, data staging, data governance, and managing the different layers of data required to ensure a successful BI & Reporting for the PEC. This role will work with multiple types of data, spreading across multiple functional areas of expertise, including Fleet, MRO & Energy, Travel, Professional Services, among others.

• Deploying supporting the E2E management of our data, including: ETL/ELT, DW/DL, data staging, data governance, and managing the different layers of data required to ensure a successful BI & Reporting for the PEC.
• Work with multiple types of data, spreading across multiple functional areas of expertise, including Fleet, MRO & Energy, Travel, Professional Services, among others.
• Serve as the main technical resource for any data-related requirement
• Demonstrate an ability to communicate technical knowledge through project management and contributions to product strategy
• Deploy data ingestion processes through Azure Data Factory to load data models as required into Azure Synapse.
• Build and design robust, modular and scalable ETL/ELT pipelines with Azure Data Factory, Python and/or dbt.
• Assemble large, complex, robust and modular data sets that meet functional / non functional business requirements.
• Build the infrastructure required for optimal ETL/ELT of data from a wide variety of data sources using Data Lakehouse technologies and ADF.
• Develop data models that enable DataViz, Reporting and Advanced Data Analytics, striving for optimal performance across all data models.
• Maintain conceptual, logical, and physical data models along with corresponding metadata.
• Manage the DevOps pipeline deployment model, including automated testing procedures.
• Deploys data stewardship and data governance across our data warehouse, to cleanse and enhance our data, using knowledge bases and business rules.
• Ensure compliance with system architecture, methods, standards, practices and participate in their creation.
• Clearly articulate and effectively influence both business and technical teams.
• Performs the necessary data ingestion, cleansing, transformation, and coding of business rules to support annual Procurement bidding activities.
• Support the deployment of a global data standard.
• Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
• Support Rate Repository management as required (including Rate Card uploads to our DW).
• Mentor junior data engineers and promote engineering best practices.
• Lead technical initiatives and provide guidance on solution design, development standards, and code reviews.
• Drive continuous improvement of the data engineering ecosystem.
• Design and maintain scalable cloud-native data architectures that support growing business demands and enterprise data strategies.
• Participate in data platform architecture decisions, including storage optimization, compute strategies, security, and performance tuning.
• Other Procurement duties as assigned.

What are we looking for?

• Bachelor’s degree in related field (Engineering, Computer Science, Data Science or similar) 5+ years of relevant professional experience in BI Engineering, data modeling, data engineering, software engineering or other relevant roles.
• Strong SQL knowledge and experience working with relational databases.
• Knowledge in DW/DL concepts, data marts, data modeling, ETL/ELT, data quality/stewardship, distributed systems and metadata management.
• Experience building and optimizing data pipelines, architectures, and data sets.
• Azure Data Engineering certification preferred (DP-203).
• ETL/ELT development experience (5+ years), ADF, dbt and snowflake are preferred.
• Ability to resolve ETL/ELT problems by proposing and implementing tactical/Strategic solutions.
• Strong project management and Organizational skills.
• Experience with object-oriented function scripting languages: Python, Scala, R, etc.
• Experience with NoSQL databases is a plus to support the transition from On-Prem to Cloud.
• Excellent problem solving, critical thinking, and communication skills.
• Relevant experience with Azure DevOps (CI/CD, git/repo management) is a plus.
• Due to the global nature of the role, proficiency in English language is a must.

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.