Vba Developer+Advance Excel (Gurugram)

Vba Developer+Advance Excel (Gurugram)

31 Jul
|
NLB Services
|
Gurugram

31 Jul

NLB Services

Gurugram

Please share your cv at [email protected]

: Assistant Manager MIS & WFM Analytics

We are hiring a high-performing MIS & Analytics professional (Assistant Manager level) with 5–10 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 effective 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
- Improve reporting turnaround time
- Ensure dashboard performance optimization and user adoption.

________________________________________ 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

Positive 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

________________________________________

📌 Vba Developer+Advance Excel (Gurugram)
🏢 NLB Services
📍 Gurugram

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: vba developer+advance excel (gurugram) / gurugram

Subscribe to this job alert:

Get the latest job offers by email for: vba developer+advance excel (gurugram) / gurugram