Specialist/Senior Specialist-Data & Reporting (Power BI & VBA Macros)

Role Purpose:

We are looking for a highly analytical and detail-oriented Data Analyst to manage data analysis, reporting, and dashboard creation for senior management. This role will be instrumental in developing and maintaining dashboards, generating reports, and enabling desktop automations to support operational excellence across all business functions. The ideal candidate will have strong expertise in Excel Macros, Power BI, and Power Automate, and be passionate about leveraging data and automation to drive business insights and efficiency.

Key Role Responsibilities:

Dashboard Development & Automation

• Design, develop, and maintain interactive dashboards and reports in Power BI to provide actionable insights for operational teams.
• Create, update, and troubleshoot Excel-based MIS reports, including advanced Macros/VBA for automation.
• Develop and manage desktop automation workflows using Power Automate and other Power Apps tools.

Stakeholder Communication & Requirement Gathering

• Work closely with business leaders to understand reporting needs.
• Translate business requirements into meaningful reports and dashboards.
• Present data-driven insights and recommendations to key stakeholders

Process Improvement & Efficiency

• Identify gaps in reporting processes and suggest improvements.
• Develop standardized templates and best practices for reporting.
• Ensure compliance with data governance and confidentiality policies.

Skills & Competencies:

• Minimum of 4+ years of relevant experience

Technical Skills:

• Advanced Excel skills including Macros/VBA scripting.
• Proficient in Power BI data modelling, DAX, report and dashboard creation.
• Hands-on experience with Power Automate and understanding of Power Apps for automation and workflows.

Soft Skills:

• Strong analytical and problem-solving skills
• Excellent communication and stakeholder management skills
• Ability to work with large datasets and complex business metrics.
• High attention to detail and commitment to data accuracy

Education & Qualifications:

• Bachelor's degree and above.

Preferred:

• Experience working in a process excellence or transformation function is a plus.