Inventory Data Analyst

Inventory Data Analyst (Pune, India)

“Life Unlimited” At Smith+Nephew. We design and Manufacture technology that takes the limits off living.

The Inventory Data Analyst will be the team’s primary expert in Power BI dashboard development, SQL-based data processing, and automated Inventory reporting in an environment with limited IT support.

The individual will collaborate with Supply Chain & Field Inventory teams to ensure complete and accurate data flows from SAP and related systems. They will drive field inventory reconciliations and analytics, establish robust controls, and strengthen compliance with company policies and external regulations (e.g., SOX) through auditable, automated reporting.

What will you be doing?

• Develop, maintain, and enhance Power BI dashboards focused on Inventory and operational metrics (inventory performance & variances).

• Write SQL queries and build data models (Power Query/DAX) to extract, transform, and load data from SAP & other sources into automated, governed datasets.

• Perform field inventory reconciliations and variance analysis leveraging finance knowledge (expenses, accounts, debits/credits); investigate root causes and propose corrective actions.

• Partner with Field Count and Logistics teams to ensure accurate data capture; document reconciling items; validate/route proposed adjustments for review and approval.

• Build finance dashboards that enable management decision-making and clearly reflect P&L impact, material- and batch-level analytics, and trend insights.

• Support post-count validation via dashboard-driven analytics and automated checks; confirm SAP adjustments align to approved proposals; summarize P&L impacts to management.

• Identify and implement process automations using Power BI, SQL, and Excel scripting to improve efficiency, control, and auditability.

• Contribute to ad-hoc analytics and digital reporting initiatives across Finance and Supply Chain.

What will you need to be Successful?

• Education: Minimum Bachelor’s in Accounting, Finance, Data Analytics or related field.

• Minimum 5 years in Inventory / Finance / data analytics / reporting. Strong Power BI (data modeling, DAX, Power Query) and SQL experience. Background with SOX, SAP, and multi-national environments preferred.

• Advanced Power BI development; proficient SQL; experience with financial dashboards (expenses, accounts, debits/credits); ERP (SAP) familiarity; strong attention to data quality, controls, and SOX awareness; ability to operate independently with limited IT support.

• Excellent communication; strong problem-solving; ability to manage multiple priorities; strong business partnering mindset.

You. Unlimited

We believe in creating the greatest good for society. Our strongest investments are in our people and patients we serve.

Inclusion, Diversity and Equity – committed to welcoming, celebration and growing on Diversity. Learn more about it on our website: https://www.smith-nephew.com/.

Other reasons why you will love it here!

• Your future: Major medical coverage + Policy exclusions and Insurance non-medical limit.

• Education Assistance

• Work / Life balance: Flexible Personal / Vacation time off, Privilege leave, Floater leave etc.

• Your Wellbeing: Parents / Parents in law’s insurance coverage also available.

• Flexibility: Hybrid work model (for most professional roles).

• Extra Perks: Free Cab Transport facility for all employees, one time meal provided to all employees as per shifts. Night Shift Allowances.

#LI-AL1