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 don't 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.
