.Johnson Controls is a global diversified technology and multi industrial leader serving a wide range of customers in more than 150 countries. Our 130,000 employees create intelligent buildings, efficient energy solutions, integrated infrastructure and next generation transportation systems that work seamlessly together to deliver on the promise of smart cities and communities. Our commitment to sustainability dates back to our roots in 1885, with the invention of the first electric room thermostat. We are committed to helping our customers win and creating greater value for all of our stakeholders through strategic focus on our buildings and energy growth platforms. For additional information, please visit www.Johnsoncontrols.Com or follow us @johnsoncontrols on Twitter.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 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 Fleet, MRO & Energy, Travel, Professional Services, among others.How you will do it?Serve as the main technical resource for any data-related requirementDemonstrate an ability to communicate technical knowledge through project management and contributions to product strategyDeploy data ingestion processes through Azure Data Factory to load data models as required into Azure Synapse.Build and design complex 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.Manage the DevOps pipeline deployment model, including automated testing procedures.Deploy data stewardship and data governance across our data warehouse, to cleanse and enhance our data, using knowledge bases and business rules.Ensure compliance to system architecture, methods, standards, practices and participate in their creationClearly articulate and effectively influence both business and technical teamsPerform 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
