Join to apply for the procurement data engineer iii role at johnson controls
1 week ago be among the first 25 applicants
what you will do?
join us in the procurement execution center (pec) as a data engineer as part of a diverse team of data and procurement professionals. In this role, you will be responsible for deploying and supporting the end-to-end management of our data, including etl/elt, data warehousing, data staging, data governance, and managing the different layers of data required to ensure successful bi & reporting for the pec. This role involves working with various types of data across multiple functional areas such as logistics, mro & energy, travel, and professional services.
how you will do it?
* deploy data ingestion processes using azure data factory to load data models into azure synapse.
* design and build etl/elt processes with azure data factory and/or python, to be executed daily and weekly.
* assemble large, complex data sets meeting business requirements.
* build infrastructure for optimal etl/elt using azure sql and adf.
* develop data models to enable data visualization, reporting, and analytics with high performance.
* maintain data models and metadata.
* manage devops pipeline deployment, including automated testing.
* implement data stewardship and governance to cleanse and enhance data using business rules.
* perform data ingestion, cleansing, transformation, and coding to support procurement activities.
* support deployment of global data standards for logistics.
* create data tools for analytics and data science teams.
* support rate repository management, including rate card uploads.
* perform other procurement duties as assigned.
what are we looking for?
* bachelor’s degree in engineering, computer science, data science, or related field.
* 3+ years of experience in bi engineering, data modeling, or data engineering, with strong sql skills.
* knowledge of data warehousing, data marts, data modeling, etl/elt, and metadata management.
* experience building and optimizing data pipelines and architectures.
* azure data engineering certification (dp-203) preferred.
* experience with ssis or adf for etl/elt development.
* ability to troubleshoot and resolve etl/elt issues.
* strong project management and organizational skills.
* experience with scripting languages such as python, scala, or c#.
* knowledge of nosql databases is a plus.
* excellent problem-solving and communication skills.
* proficiency in english is required due to the global nature of the role.
seniority level
* mid-senior level
employment type
* full-time
job function
* information technology
industries
* industrial machinery manufacturing
#j-18808-ljbffr