Business Analyst

Job Description

About the role:

We are looking for a data-first Business Planner who can turn raw business signals into structured plans, actionable dashboards, and decisive outcomes. You will sit at the intersection of analytics, inventory planning, and cross-functional strategy - building the visibility frameworks that help leadership moves faster and smarter.

Analytics-Led Business Planning

• Own monthly and quarterly performance tracking — build SQL-driven queries to extract business metrics, identify deviation from targets, and surface corrective actions with full data backing.
• Develop and maintain advanced Excel models (pivot-based, dynamic-array, scenario-driven) to simulate demand-supply scenarios, forecast gaps, and test planning assumptions.
• Design planning frameworks that bind demand, supply, finance, and operations into a single version of truth — no guesswork, only evidence.
• Proactively identify performance gaps before they become escalations using trend analysis, YoY comparisons, and variance decomposition.
  
  

Inventory Planning & MPCP Oversight

• Monitor inventory lifecycle TAT using structured data pulls — flag delays, bottlenecks, and overbuild situations before they hit financial impact.
• Drive MPCP adherence across departments; build scorecards that show compliance vs. plan at a glance.
• Improve Inventory Turnover Ratio through root-cause analysis of slow-moving stocks, demand mismatches, and supply timing issues.
• Maintain optimal stock level dashboards coordinated with production, supply chain, and logistics teams.
  
  

Dashboard Engineering & Management Reporting

Build dynamic, logic-driven dashboards — not static slides. Dashboards must auto-highlight gaps, flag risks, and surface the so what without manual intervention.

Embed situation-based logic into dashboards: if actual < target by X%, trigger a visual alert; if TAT exceeds threshold, escalate automatically in the view.

Own the full MIS/MPR cycle — data sourcing, validation, structuring, and final review-ready output delivered ahead of schedule, not on request.

Structure cross-functional data into unified views covering target vs. actual, MPCP compliance, inventory health, and project milestones.

Strategic Projects & Cross-Functional Execution

• Lead cost optimization and process improvement initiatives in partnership with Finance, Procurement, and Production — always anchored in data, not opinion.
• Build and maintain financial models, rolling forecasts, and budget-vs-actuals trackers that are audit-ready and insight-rich.
• Support leadership with scenario modelling and business-case evaluations backed by quantitative analysis.
• Facilitate stakeholder alignment by converting complex datasets into crisp, decision-enabling narratives for BU heads and HO teams.
  
  

Requirements

Skills & Tools

Analytics & Querying: SQL ★ Must-have

Spreadsheet Modeling: MS Excel - Advanced ★ Must-have

Dashboard Logic: Situation-based gap identification

Planning Concepts: Inventory, Forecasting, MPCP

Reporting: MIS / MPR cycles, KPI management

Mindset: Analytical, fast-paced, ambiguity-tolerant

What We Value

• You dont wait for someone to tell you the data looks wrong — you find it first.
• Your dashboards have an opinion. They tell stakeholders what to act on, not just what happened.
• You can write a SQL query, build a model, and present findings to leadership — all in the same day.
• You treat planning deadlines as non-negotiable, and prep stakeholders well before review windows.
  
  

Education

• Tier 2 / Tier 3 Institute Background
• We hire on demonstrated analytical ability and hands-on experience.
• Strong SQL + Excel skills and a sharp eye for business gaps matter far more than the name on your degree.

---