Data Transformation and Management Lead

Cummins; Pune District; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

Cummins in India seeks a Supply Chain Analytics specialist to develop cross-organizational analytics on lead time, delivery, inventory, and working capital, and to make recommendations to improve profitability and customer service.

The role requires strong SQL, Power BI, data wrangling, and ML skills, with experience in Six Sigma projects and cross-functional collaboration. You will manage multiple analytics initiatives, automate data flows, and present findings to directors.

Qualifications

• Experience delivering supply chain analytics and KPI reporting.
• Strong SQL, data wrangling, and Power BI dashboard creation.
• Experience with dataflows, Power Query, and DAX.
• Project management with cross-functional teams.

Responsibilities

• Develop supply chain analytics to make operational performance visible.
• Lead Six Sigma and supply chain improvement projects.
• Ensure data integrity of all analytics and reports; develop KPI reporting capability.
• Model scenarios using ML and Python; create custom apps with Power apps/streamlit.

Skills

Power BI

SQL scripting

Dataflows

Power Automate

Python

Project Management

Analytics

Supply Chain

Education

Master in Analytics/AI/ML

Tools

Copilot Studio

Python

Job description

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

Competencies:

• Collaborates - Building partnerships and working collaboratively with others to meet shared objectives.
• Communicates effectively - Developing and delivering multi-mode communications that convey a clear understanding of the unique needs of different audiences.
• Customer focus - Building strong customer relationships and delivering customer-centric solutions.
• Drives results - Consistently achieving results, even under tough circumstances.
• Ensures accountability - Holding self and others accountable to meet commitments.
• Global perspective - Taking a broad view when approaching issues, using a global lens.
• Optimizes work processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement.
• Plan for Every Part (PFEP) - Uses PFEP in planning, designing, and management of systems and processes within a facility to ensure delivery of right part at the right time in the right quantity to the right place, which in turn guarantees smooth operations; applies PFEP principles on the end to end supply chain with particular attention to the relationships between master data management, materials planning parameters, engineered material flows, transport management, and warehouse management.
• Analysis and Troubleshooting - Extracts, transforms, models, interprets, and presents planning data with the goal of mining useful information, troubleshooting, suggesting conclusions, and supporting value creating decision making.
• Material Planning - Uses advanced tools (e. g. Advanced Planning Command Centre, Business Intelligence (BI) Dashboards etc. ) to take a decision related to parts availability, inventory optimization and root cause analysis.
• Materials KPI Management - Operates in relation to recent or historical outputs as compared to expectations of the organization to determine next steps to drive improvement; assesses gaps to the supply chain performance against the expectation of achieving target deliverables; interprets KPIs to understand end-customer impact; strategically balances trade-offs to influence one KPI while minimizing the impact to others.
• Values differences - Recognizing the value that different perspectives and cultures bring to an organization.

Education, Licenses, Certifications:

College, university, or equivalent degree required.

This position may require licensing for compliance with export controls or sanctions regulations.

Experience:

Intermediate level of experience required. 3-5 years of relevant work experience preferred.

This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.