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

  • *
    *
    *
    *
    *
    *
    Import LinkedIn profile
    or

    My Information

    My Experience

    Application Questions

    Review

    My Information

    My Experience

    Application Questions

    Review

    *

    Contact Information
    I confirm that I am submitting this electronic application on my own behalf, and not on behalf of any other person, and that the information contained in this application is my own personal information. I hereby affirm that the information provided during the application process and any accompanying documents attached including my resume/CV or provided during any discussion or interviews, are true and complete to the best of my knowledge. To the extent permitted by applicable local law, I authorize Johnson Controls and its affiliates, subsidiaries and operating segments (collectively, the Company) to investigate all statements in this application and accompanying documents and to secure any necessary information from all my employers, references, and educational institutions.

    I understand that should I receive an offer of employment with Johnson Controls, such offer is conditional on successful completion of all aspects of the application process including such background and reference checks as are applicable and permitted under local law. Submission of this electronic application by me does not constitute to me an offer of employment, an employment agreement or any other contractually binding commitment by Johnson Controls.

    I understand and agree that the information submitted by me will be used, disclosed and stored in accordance with Johnson Control's Privacy Notice, which I have fully reviewed and accept. For individuals located in the United States, applicants are not required to provide any age related information and/or graduation date(s). We will transfer your personal information across borders in accordance with the Privacy Notice. To the extent permitted by applicable local law, by clicking the button below, you consent to the cross-border transfer of your personal information. For individuals located in China: please read the Addendum – Rules on Cross Border Transfer of personal information for China (HR Management). By clicking the button below, you consent to Johnson Controls collecting, processing and transferring your personal information (including sensitive personal data) in accordance with our Privacy Notice and the Addendum for China.

    To provide you with the most effective recruiting process, Johnson Controls may use artificial intelligence (“AI”) to help us better understand how your candidate information matches the requirements of the role you have applied to. We may process your answers to the application and qualification questions, information in your resume, and, if applicable, information from your Johnson Controls personnel record, using tools that rely on AI. All hiring decisions will be made by the hiring team after considering your candidate profile in full. These tools help us to match the information provided by you with the job and preferred qualifications. All hiring decisions will be made by our hiring team after considering your candidate profile in full, and the use of AI insights is just one of the tools and one of numerous factors that we use to help us evaluate candidates and reach a decision.

    Johnson Controls would also like to consider you for additional and future job openings, and we may use AI to help with this process. These AI tools help us understand how your candidate information matches the requirements of future job openings (using the same process as described above). Johnson Controls recruiters may use these insights to help them decide whether to reach out to you to regarding a future job opening. If you are located in the United Kingdom or European Union, the use of the AI insights is necessary for Johnson Controls’ legitimate interests to provide a streamlined and efficient recruitment process, and to consider you for future roles. Please note, the use of AI insights is just one of the tools and one of many factors our recruiters use to help evaluate candidates for upcoming roles.

    DO NOT E-SIGN UNTIL YOU HAVE READ THE ABOVE STATEMENT.
    *
    Work Experience
    Work Experience
    Remove
    + Add work experience
    Education
    Education
    Remove
    + Add education
    Skills
    Please provide your relevant Skills
    Websites
    Add any relevant websites (include https:// in URL)
    Website
    Remove
    + Add websites
    Application Questions

    Personal Information
    Johnson Controls values a diverse and inclusive workplace. Providing this information will help us to ensure our recruitment practices promote equality of opportunity.
    Your response to the self-identification questionnaire below is voluntary. It is however mandatory to answer the questions, even if you choose not to provide the information.
    The information will be kept anonymous and your answer will be treated with the strictest confidence and protected from misuse. We assure you that your answers will be used only for the purposes of monitoring our equal opportunities policy and will not be used by us to make any unlawful decisions affecting you, whether in a recruitment exercise or during the course of any employment with us.

    You are not obliged to provide this information and you will not suffer any penalty if you choose not to do so.
    My Information
    Edit Hide
    My Experience
    Edit Show
    Application Questions
    Edit Show
Go to Top