Operations Analytics & Controls Lead, Power BI & Automation

Prudential; Kuala Lumpur; On-site; MYR 90,000 - 130,000; Full time

Job summary

Prudential is seeking a Senior Executive, Operations Analytics & Controls to design and maintain reporting standards and automated flows for VCC operations in Malaysia. You will build Power BI dashboards, implement data structures, and ensure data integrity across reports while collaborating with stakeholders to translate operational needs into scalable solutions.

Experience with Excel VBA/macros, SharePoint, and AI-enabled tools to enhance reporting efficiency is required, along with a strong

Qualifications

• Experience designing and implementing reporting flows.
• Proficient in data structuring and transformation with Excel Macro/VBA.
• Ability to develop Power BI dashboards for SLA/KPI tracking.
• Understanding of governance, data dictionaries and controls.

Responsibilities

• Design reporting flows across operations.
• Data structuring and transformation using Excel Macro/VBA and Power Tools.
• Automated reporting pipelines integrating trackers with SharePoint repositories.
• Development of Power BI dashboards for SLA/KPI tracking.
• Operational performance monitoring and trend/exception reporting.
• Establish standardized reporting frameworks and data dictionaries.
• Data validation and reconciliation controls.
• Reporting cadence and governance.

Skills

Excel VBA

Power BI

SharePoint

Data transformation

KPI tracking

AI tools

Tools

Copilot

Power Tools

Job description

Prudential is seeking a Senior Executive, Operations Analytics & Controls to design and maintain reporting standards and automated flows for VCC operations in Malaysia. You will build Power BI dashboards, implement data structures, and ensure data integrity across reports while collaborating with stakeholders to translate operational needs into scalable solutions.

Experience with Excel VBA/macros, SharePoint, and AI-enabled tools to enhance reporting efficiency is required, along with a strong