Assistant Vice President - Enterprise Risk Reporting and Insights
M&G plcRemote1d ago
RemoteFull-timevia scraped
Required Skills
pythonazuresql
Job Description
*About M\&G India** We are M\&G India, the strategic innovation and digital hub for M\&G. Established in 2003, we have offices in Mumbai and Pune. Our teams work closely with colleagues across the Group worldwide to drive transformation, build digital capability, and support sustainable growth. By leveraging technology, AI, automation, and process excellence, we bring new ways of thinking to improve outcomes for both customers and colleagues. Grounded in a vibrant culture with strong foundations, we are central to how M\&G is transforming as a business. **About M\&G** Our purpose is to give everyone real confidence to put their money to work. With a heritage dating back more than 175 years, we have a long history of innovation in savings and investments, combining asset management and insurance expertise to offer a wide range of solutions. Our two distinct operating segments, Asset Management and Life, work together to provide access to balanced, long\-term investment and savings solutions. Through telling it like it is, owning it now, and moving it forward together with care and integrity; we are creating an exceptional place to work for exceptional talent. **Accountabilities/Responsibilities** The key responsibilities of this role are to support the development and delivery of Enterprise Risk reporting and insights within the Non\-Financial Risk team. This involves: * Lead the development of new dashboards and interactive reports using PowerBI for senior management and other stakeholders. * Lead the development of solutions to automate report production using PowerBI, PowerApps and Power Automate. * Lead the development of automated solutions by integrating PowerBI with existing Risk systems. * Ensure reporting requirements are met through the provision of accurate and timely data. * Leverage technology to further automate the delivery of risk reporting/risk based metrics. * Work with Operations and Technology partners to ensure a high quality of data is feeding from the Governance Risk and Compliance system. * Collaborate with the wider Risk and Compliance teams as well as 1LOD and 3LOD teams to drive improvements and enhancements. * Keep abreast of industry trends, regulatory and business issues. * Proactively identify underlying risks and escalate issues where appropriate. **Key Stakeholder Management** **Internal** * M\&G plc Risk and Compliance * All M\&G plc UK Business Areas and Senior Management Teams * Internal Audit **External** * External Suppliers and Business Partners * External Auditors * Regulators **Knowledge, Skills, Experience \& Educational Qualification** **Required Skills** * **Strong knowledge of Analytical Tools and Methodologies** + Data Modelling, Relationships, Security, Roles, etc. + PowerBI, PowerApps, Power Automate + Python, SQL, Excel Macros/VBA, Scripting * **Design and govern star\-schema data models** optimized for risk reporting, including fact tables for *Issues, Events, Actions*, and dimensions for *Controls, Risk Categories, Legal Entities, Owners, and Time* to support scalable analytics and regulatory reporting use cases. * **Build and maintain robust data ingestion pipelines** from enterprise GRC platforms (via APIs and scheduled exports) into **Azure Data Lake Storage Gen2 or Microsoft Fabric OneLake**, ensuring secure, reliable, and auditable data movement. * **Develop transformation and enrichment logic** using **PySpark and SQL** in **Azure Databricks or Microsoft Fabric notebooks**, implementing **Bronze, Silver, and Gold medallion architecture** standards for GRC and risk data. * **Configure and operate orchestration frameworks** using **Azure Data Factory or Fabric Data Pipelines**, including dependency management, scheduling, failure handling, and automated alerting for operational resilience. * **Optimize analytical and semantic model performance**, including query tuning, aggregation strategies, incremental refresh patterns, and trade‑off decisions between **Direct Lake vs Import modes** in Power BI and Fabric. * **Define and enforce data quality rules** at the pipeline level for risk data, including **completeness, timeliness, accuracy, and consistency checks**, ensuring only trusted datasets reach reporting and regulatory layers. * **Maintain end‑to‑end data lineage documentation**, from source GRC systems (e.g., MetricStream / similar platforms) through transformation layers to **Power BI semantic models**, supporting auditability and regulatory examinations. * **Collaborate with IT, data governance, and risk stakeholders** to ensure data assets are properly **catalogued, classified, and governed**, aligning with enterprise metadata, security, and compliance standards. * Proficient in leveraging complex data sets to support business decision\-making. * Working knowledge of variety of databases and database concepts such as SQL, python. * Knowledge of risk management in financial services * Ability to challenge constructively, and to be pragmatic where appropriate. * Curious and continually looking to seek out improvements and not just accepting the status quo. * Strong drive and delivery, committed to achieving results and delivering on time. * Strong analytical thinking and a critical evaluator of information/issues. * Ability to manage conflicting objectives and to work to pressured deadlines * Ability to make quick independent decisions based on logical thought processes * Good organisation and logistical skills * Ability to quickly learn and assimilate key processes and procedures * Ability to analyse business requirements and regulations, highlighting key considerations or new requirements * Independent, analytical and positive mind, excellent inter\-personal and communication skills, ability to deal with people in different levels including senior management * Good interpersonal skills \- involving liaison across the organisation with key personnel, influencing others to deliver to deadlines and guiding them on specific requirements * Good presentation and report writing skills, including written and oral communication skills * Excellent Microsoft Office skills (Word, Excel, PowerPoint) * Ability to work collaboratively across immediate team and broader Risk and Compliance function whilst also being to work independently under own initiative. * Good stakeholder management skills, with the ability to successfully navigate a complex organisation as well as build strong relationships and work collaboratively with teams across the business * Ability to operate remotely, in a diverse and multi\-cultural environment. **Experience:** * Minimum of 7 years’ experience in data analytics, data modelling preferably within a financial institution with focus on risk and controls. **Educational Qualification:** * Graduate/Post\-graduate/MBA/B. Tech. / B.E. or other professional IT\-related qualification * Relevant professional qualification desirable. **Certifications:** * PL‑300: Microsoft Power BI Data Analyst * DP‑203: Azure Data Engineer Associate * DP‑600: Microsoft Fabric Analytics Engineer Associate * Databricks Data Engineer Associate We have a…