About the role

Aplyr's Quick Take

This role is about building and managing data pipelines and models to support business intelligence for procurement activities. You'll work with Azure tools to handle data ingestion, transformation, and governance, making it a hands-on data engineering position. It's primarily an individual contributor role focused on technical execution.

Good fit

Ideal candidates have 3+ years of experience in data engineering or related fields, with strong SQL skills and familiarity with Azure technologies. A proactive, detail-oriented working style will help you thrive in this role.

Worth noting

The role involves a mix of technical tasks and procurement-related duties, which may be a unique combination for data engineers. The emphasis on global data standards and governance suggests a structured environment, but the posting lacks clarity on specific team dynamics.

What you will do?

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 manage 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 Logistics, MRO & Energy, Travel, Professional Services, among others.

How you will do it?

Deploy data ingestion processes through Azure Data Factory to load data models as required into Azure Synapse.
Build and design ETL/ELT processes with Azure Data Factory (ADF) and/or Python, which once deployed, will require to be executed daily and weekly.
Assemble large, complex 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 Azure SQL 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.
Manages 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.
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 for Logistics.
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).
Other Procurement duties as assigned.

What are we looking for?

Bachelor’s degree in related field (Engineering, Computer Science, Data Science or similar)
3+ years of relevant 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 (3+ years). SSIS or ADF 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, C#, 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

Skills & Tags

data

Aplyr's read

Johnson Controls excels in optimizing building efficiencies, attracting engineers and technicians focused on innovative solutions in HVAC and security systems.
Synthesized from recent postings & public sources

What's promising

•Strong focus on energy efficiency aligns with global sustainability trends.
•Diverse roles in engineering and technical fields offer career growth.
•Global presence provides opportunities for international work experience.

What to watch

•Complex organizational structure may slow decision-making processes.
•Highly competitive industry with constant technological advancements.
•Limited public information about employee satisfaction and work-life balance.

Why Johnson Controls

•Pioneers in integrating smart technology for building management.
•Offers specialized roles in HVAC and security systems engineering.
•Strong commitment to sustainability through innovative building solutions.

Aplyr’s read is generated by AI from public sources. Was it useful?

About Johnson Controls

Johnson Controls

johnsoncontrols.com

View company

Johnson Controls is a global leader in building technologies and solutions, providing products and services that optimize energy and operational efficiencies of buildings.