Mis Executive

Randstad; Coimbatore District; On-site; INR 500,000 - 800,000; Full time

Job summary

Randstad in India seeks a contract data analyst to compile monthly KPIs, automate tasks, and deliver leadership reports using Excel, Power BI, and AI tools.

You will clean data, create dashboards with pivot tables, and present insights to support dealer financing and retail growth initiatives during a 1-year term.

Qualifications

• Contractual position for 1 year with possible extension.
• Proficiency in Excel, Power BI, and data automation tools required.
• Experience in financial metrics and dashboard creation is a plus.

Responsibilities

• Compile monthly KPIs (disbursements, delinquency, RoA) into Excel dashboards with headers and charts.
• Automate tasks using Power Query, Power BI, and AI platforms for data cleaning and predictions.
• Prepare leadership reports and charter updates using advanced Excel formulas and PowerPoint.
• Analyze financial metrics and generate insights for business growth initiatives.

Skills

Excel dashboards

Pivot tables

Power BI

Power Query

AI platforms

XLOOKUP

EDATE

Automation

Tools

Power BI

Power Query

Copilot/ChatGPT

Job description

It is a contractual position for 1 year and it's extendible.

Key Responsibilities

• Compile monthly KPIs (disbursements, delinquency, RoA) into Excel dashboards with mm/yy headers, pivot tables, and dynamic charts.
• Automate repetitive tasks using Power Query, Power BI, and AI platforms like Copilot or ChatGPT for data cleaning and trend predictions.
• Prepare charter updates, project timelines, and leadership reports using advanced Excel formulas (XLOOKUP, EDATE) and PowerPoint automation.
• Analyse financial metrics (delinquency ratio , LTV % , share of business ) and generate insights for dealer financing and retail growth initiatives.