Reporting Analyst - GPO

Mettler Toledo AG; Mumbai; On-site; INR 900,000 - 1,800,000; Full time

Job summary

Mettler Toledo AG in Mumbai seeks a data analytics professional to turn raw data into actionable insights for global management. You will leverage SQL, Python, Access, and BI tools to build reports and dashboards used by internal stakeholders.

Responsibilities include data cleansing, validation, and transforming data for accurate reporting, plus writing optimized SQL queries and supporting data engineering tasks to ensure consistency of price realization analyses across local markets.

Qualifications

• Proficient in SQL-based data querying and reporting.
• Experience with Python for data analysis and scripting.
• Ability to create dashboards and visualizations for stakeholders.
• Familiarity with Vendavo and BI tools for pricing and reporting.

Responsibilities

• Create reports and dashboards for internal stakeholders using SQL, Python, and BI tools.
• Perform data cleansing, validation, and transformation to ensure reporting accuracy.
• Provide summaries/findings of analysis for management decisions.
• Collaborate with IT to troubleshoot data-related issues and optimize data flows.
• Support price realization analysis across local markets with recurring and ad hoc analyses.

Skills

SQL

Python

Analytics

Data Visualization

Access

Vendavo

BI

Tools

Vendavo

BI

Job description

Essential Duties and Responsibilities

• Supporting analytics and visualizations that help global management gain insight and make decisions.
• Leveraging existing tools (SQL, Python, Access, Vendavo, BI) to create reports and dashboards that can be used by internal stakeholders.
• Providing summaries/findings of analysis based upon quantitative and qualitative analysis
• Performing complex data cleansing, validation, reconciliation, and transformation to ensure reporting accuracy and consistency.
• Writing and optimizing SQL queries to extract, join, and prepare data from multiple sources.
• Supporting data engineering-related activities, including structuring, organizing, and preparing data for reporting and downstream analysis.
• Providing summaries and findings based on quantitative and qualitative analysis of reporting outputs.
• Communicate effectively with multiple levels of management and business partners, tailor reporting outputs and findings to meet the needs of different audiences.
• Provide recurring and ad hoc reports and analysis related to price realization within each local market.
• Providing reports on win / loss data to better help key users understand the drivers impacting price realization in each local market
• Pricing transaction analysis including price banding, transaction waterfalls, promotion effectiveness, discounting controls
• Supporting global deal desk for strategic negotiations by pulling the relevant data points needed: yearly sales, pricing performance, benchmark discounts, general commercial terms, etc.
• Support the management of Vendavo online application through testing and audits
• Collaborating with IT employees to troubleshoot technical issues
• Other duties may be assigned.