Data Transformation and Management Lead

Job Summary:
Develop and provide supply chain analytics that cross organizations and Business Units, such as through put time, lead time, delivery, logistics, working capital, and order management. Make recommendations to achieve profitability, customer service, and/or inventory goals.

Key Responsibilities:
Develop supply chain analytics to make operational performance and trends visible. Lead and participate in six sigma and supply chain improvement projects Use common processes tools, and information systems to enable supply chain analysis. Ensure data integrity of all analytics and reports. Develop reporting capability for supply chain Key Performance Indicators. Analyze and interpret Key Performance Indicators to identify areas for improvement and action plans. Use existing business systems to provide analytics and reporting that are capable and repeatable. Develop basic supply chain models for scenario analysis Conduct internal and external benchmarking analysis. Provide financial analysis as required

The Supply Chain Analyst manages the project portfolio for all analytics projects with functional directors in supply chain (order management, planning and inventory, strategy, or NPI). This role requires strong project management for timelines and stakeholder expectations. Communicates to two distinct audiences - business leaders and managers, and to IT developers and managers.
The Supply Chain Analyst creates SQL scripts to extract data, loads data in Power BIs, creates new columns with power queries, creates complex measures in Power BI for supply chain concepts, creates state of the art Power BI visuals.
The SC Analyst also drives process efficiencies creating Power automate flows to move/copy/download/refresh power BIs when data becomes available. Creates agents when require to prompt data set for more complex processes.
The SC Analyst creates analytical models using ML to automate processes for supply chain. Use python, R or other programming languages to achieve custom results. Use power apps and streamlit to create custom applications to fit supply chain business needs.
The SC Analyst manages several projects, applies project management principals to control schedule and scope, manages stakeholders expectations for milestones, and present project portfolio updates to managers and directors.

MUST have demonstrated experience executing/developing:

-Power BI skills (must know creation of dashboards, measures, DAX scripts)

-SQL scripts skills (or data engineering experience)

-Dataflows transformations and power queries (data readiness)

-Power-Automate flows or Copilot Studio skills

-Machine learning models or phyton programming

-Project Management (work with cross functional stakeholders, drive project adoption, manage timelines)

-Analytical skills (statistics, trend analysis, financial analysis)

-Broad Supply Chain knowledge is highly desired (Network Optimization, Materials Planning, Demand Planning - IBP, Order Management, Supply Chain VPI)

-7years of experience

-Master in Analytics, AI, ML or related field is highly desired.

- Working Time - 12 PM to 9 PM