Data Transformation and Management Lead

Cummins India; Pune District; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Cummins Inc. in Pune seeks a senior Supply Chain Planning professional to develop cross-functional analytics using Power BI and related data tools.

You will analyze lead times, delivery, inventory, and order management to drive profitability and customer service improvements. The role requires 7+ years of experience, a master in analytics/AI/ML is preferred, and you will collaborate with IT and business units to implement scalable analytics and reporting.

Qualifications

• Power BI dashboards and DAX measures.
• SQL scripts for data extraction and shaping.
• Dataflows and Power Queries for data readiness.
• Power Automate or Copilot Studio for automation.
• ML models or Python programming for analytics.
• Project management with cross-functional stakeholders.
• Analytical skills including statistics and finance.
• Broad supply chain knowledge (IBP, planning, order management).
• 7 years of experience in analytics or SC planning.
• Master in Analytics/AI/ML preferred.

Responsibilities

• Develop supply chain analytics to reveal operational performance and trends.
• Lead Six Sigma and SC improvement projects and drive data-driven actions.
• Use ERP/BI tools to enable repeatable analytics and reporting.
• Ensure data integrity across analytics and KPI reporting.
• Develop KPIs and reporting capabilities for the supply chain.
• Analyze KPIs to identify improvements and action plans.
• Create analytical models for scenario analysis and optimization.
• Benchmark analyses and provide financial insight as required.
• Collaborate with IT and business units to deliver analytics solutions.
• Develop automation and data flow processes to streamline reporting.

Skills

Power BI

SQL

Power Queries

Power Automate

Python/ML

Project Management

Data Analytics

Supply Chain Knowledge

7+ years experience

Education

Master in Analytics/AI/ML

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.

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

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. 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

Job

Supply Chain Planning

Organization

Cummins Inc.

Role Category

On-site with Flexibility

Job Type

Exempt - Experienced

ReqID

2440530

Relocation Package

Yes

100% On-Site

No