What you will do:
as a business intelligence analyst within the johnson controls global products planning organization, you will dive deep into large, fragmented, and sophisticated data sets that span our entire supply chain. This position will require a creative problem solver who isn’t afraid to get down into the details and build out digital solutions to unlock efficiency within our business. You will build tools to consolidate, analyze, and drive strategic decision making across our supply chain. Our business intelligence analysts will work with many different partners to understand the problem, identify the solution, and execute on bringing the solution to life.
how you will do it:
* own your projects by crafting project plans, tracking progress, and presenting project updates to collaborators and senior leadership.
* build, develop and maintain data models, automated reports, and dashboards that align to strategic performance metrics.
* design and develop digital solutions that drive insights into major supply chain metrics such as, timely delivery, days inventory on hand, inventory health, and forecast accuracy.
* connect with technical teams to identify data tables and schemas needed for analysis. Strong understanding of erps and complex databases will be needed to determine how to prep and blend data from different systems.
* identify and drive process improvement opportunities with digital solutions to increase operational efficiency.
* use business intelligence tools to communicate findings and solutions to the problems you are trying to solve.
* offer recommendations and analysis on course correction and seriousness and magnitude of business issues.
* partner with planning & materials coe teams to make sure process standards down to a plant and distribution center level are adhered too.
what we look for:
required:
* bachelor’s degree in supply chain, finance, data analytics, data science, computer science, information technology, or related field.
* 3+ years of supply chain or finance related experience.
* 2+ years of experience in data analytics, business intelligence, or data science capacity.
* advanced sql experience with the ability to build complex sql queries to prep and blend data.
* proficient in using business intelligence tools such as power bi and alteryx.
* exceptional microsoft excel and powerpoint skills.
* proven ability to critically think and creatively problem solve.
* strong presentation and interpersonal skills.
* excellent analytical skills and attention to detail.
* experience connecting directly to multiple databases to extract, prep, and blend large datasets.
* ability to work effectively in a highly matrixed organization.
* travel up to 10%.
preferred:
* experience using microsoft applications such as sharepoint, power automate, power apps, lists, etc.
* knowledge of r, python, dax, javascript, or related programming languages.
* apics certification.
#j-18808-ljbffr