Vba Developer

NLB Services; Gurugram District; On-site; INR 1,800,000 - 2,600,000; Full time

Job summary

NLB Services is seeking a high-performing MIS & Analytics professional at Assistant Manager level in Gurugram to drive data-led decision-making.

The role focuses on reporting automation, data modeling, dashboarding, and advanced analytics to turn complex datasets into actionable insights that improve operational efficiency, forecasting accuracy, and financial outcomes.

Qualifications

• MIS reporting, dashboards, and governance required.
• Strong data analysis, forecasting, and performance packaging.
• Experience with WFM analytics preferred.
• Expertise in Excel, VBA, Power Query, and BI tools.

Responsibilities

• Design, develop, and standardize enterprise MIS reports, dashboards, and executive scorecards.
• Own end-to-end reporting lifecycle including data quality and timely insights.
• Automate recurring reports using Excel, VBA, Power Query, and BI tools.
• Deliver daily/weekly/monthly performance packs with variance analysis for leadership.
• Perform deep-dive analysis to identify trends, risks, and opportunities.
• Translate analytics into business narratives for leadership decisions.
• Partner with WFM teams for forecasting, scheduling, and capacity planning.

Skills

Advanced Excel

Power BI

VBA

SQL

Tableau

Data modeling

Stakeholder management

Analytical thinking

Education

Bachelor's degree in Statistics/Mathematics/Economics/Engineering

Certifications in Data Analytics / Power BI / SQL

Tools

Power BI

Tableau

SQL

Excel

Job description

We are hiring a high-performing MIS & Analytics professional (Assistant Manager level) with 510 years of experience, preferably in WFM/Operations Analytics, to drive data-led decision-making.

The role requires strong expertise in reporting automation, data modeling, dashboarding, and advanced analytics, along with the ability to convert complex datasets into actionable business insights that improve operational efficiency, forecasting accuracy, and financial outcomes.

Key Responsibilities

1. MIS Strategy, Reporting & Governance

• Design, develop, and standardize enterprise-level MIS reports, dashboards, and executive scorecards.
• Own and manage end-to-end reporting lifecycle ensuring:
• Data quality, accuracy, and consistency
• Timely delivery of insights
• Drive automation of recurring reports using Excel (Advanced), VBA, Power Query, and BI tools.
• Deliver daily/weekly/monthly performance packs for leadership including variance analysis.

2. Advanced Data Analysis & Business Insights

• Perform deep-dive analysis on large datasets to identify trends, risks, and improvement opportunities.
• Provide data-driven recommendations to optimize:
• Capacity planning
• Scheduling efficiency
• Cost & productivity metrics
• Conduct root cause analysis (RCA) across key operational levers.
• Translate analytical findings into business narratives for leadership decision-making.

3. Workforce Management (WFM) Analytics

• Partner closely with WFM teams across:
• Forecasting & Capacity Planning
• Scheduling & Rostering
• Real-Time Operations (RTA)
• Track, analyze, and improve key KPIs:
• Service Level (SL)
• Average Handle Time (AHT)
• Occupancy & Utilization
• Shrinkage
• Forecast Accuracy
• Support scenario planning and what-if analysis for business demand fluctuations.

4. Dashboarding, Automation & Data Engineering

• Develop interactive and scalable dashboards using Power BI (mandatory) and/or Tableau.
• Build efficient data models and visualization frameworks for real-time tracking.
• Perform ETL operations using SQL from multiple data sources.
• Lead initiatives to:
• Automate workflows
• Reduce manual effort

  5. Stakeholder & Leadership Management

  • Collaborate with Operations, WFM, Finance, and Senior Leadership to understand business needs.
  • Translate requirements into analytical solutions and reporting frameworks.
  • Present key insights, trends, and strategic recommendations to stakeholders.
  • Act as a thought partner to business teams in driving performance improvements.

  Core Competencies

  • Strong analytical thinking & problem-solving skills
  • Ability to simplify complex datasets into actionable insights
  • High attention to detail and data accuracy focus
  • Strong communication and stakeholder management skills
  • Ability to work in fast-paced, matrixed environments

  Tools & Technologies

  Data Analysis & Visualization:

  • Microsoft Excel (Advanced – Mandatory)
  • VBA / Macros
  • Power Query & Power Pivot
  • Power BI (Mandatory)
  • Tableau (Preferred)

  Data Handling & Processing:

  • SQL (MySQL, SQL Server, Oracle, etc.)
  • Data modeling & ETL concepts

  Good to Have:

  • Python/R for analytics
  • Exposure to cloud data platforms (Azure, AWS, GCP)
  • Experience with automation tools

  Educational Qualification

  • Bachelor’s degree in Statistics, Mathematics, Economics, Engineering, or related analytical field
  • Certifications in Data Analytics / Power BI / SQL (preferred)

  Preferred Experience

  • Experience in BFSI / Consulting / BPO / Shared Services
  • Prior exposure to WFM Analytics / Operations Analytics
  • Experience with large-scale data handling and automation projects