12 Nov
|
AXA XL
|
Gurugram
Gurgaon, Haryana, India The Data Quality Manager is responsible for the framework, quality, traceability, control and reporting of data supporting the Solvency II calculations. The role combines actuarial and risk understanding with hands-on IT, data management, coding and analytics capabilities. The position acts as the bridge between actuarial and risk teams, data owners, IT teams and Group entities. It translates Internal Model processes into robust Collibra lineage, controlled data transformations, automated reconciliations and actionable Power BI reporting. What You’ll Be DOING What will your essential responsibilities include? Collibra Data Lineage Ownership
• Manage and maintain end-to-end data lineage for the Solvency II Internal Model in Collibra. (cf
• 5)
• Support entities in documenting their data lineage.
• Ensure lineage remains complete, accurate and current when systems, processes or calculation methodologies change.
• Perform and manage Collibra extracts for control campaigns, analysis and Power BI reporting. (cf
• 3)
• Challenge whether documented lineage reflects the actual actuarial and technical process, rather than only checking administrative completeness. Owner Of The Data Quality Framework
• Maintain the DQ Framework at Group and at entity level.
• Assess which transformations are material or critical from a Solvency II and data quality perspective.
• Ensure critical transformations have appropriate controls to detect data loss, leakage, duplication, incorrect mapping or unintended alteration.
• Design, perform or automate pre
- and post-transformation reconciliations, including population, value, mapping and exception checks.
• Apply actuarial and technical judgement to distinguish expected differences from genuine data quality issues. Q2 And Q4 STEC Control Campaigns
• Coordinate the half-year/Q2 and year-end/Q4 STEC data quality control campaigns.
• Extract the applicable controls from the Collibra lineage.
• collect results and request action plan for failed control.
• Consolidate Group results and identify failed, missing or overdue controls.
• Challenge entities on anomalies and escalate material weaknesses through the appropriate governance. (cf
• 6) Power BI Reporting And Analytics
• Develop and maintain Power BI dashboards based on Collibra extracts and entity control submissions.
• Build repeatable data preparation processes using Power Query, SQL, Python or equivalent tools. Coding, Computations And Automation
• Manipulate, join, map, aggregate and reconcile complex datasets from Collibra and entity submissions.
• Use coding and computational techniques to automate repetitive controls, campaign preparation, exception analysis and reporting.
• Understand the end-to-end process sufficiently to ensure calculations and automated checks remain meaningful from an actuarial and business perspective. Control Failures And Remediation
• Ensure material control failures are investigated and supported by root-cause analysis.
• Agree action plans, accountable owners and target completion dates with entities.
• Monitor open and overdue actions centrally and escalate significant delays or repeat failures.
• Assess whether completed actions are effective and have sustainably addressed the underlying risk.
• Use subsequent control campaigns and targeted testing to identify recurring issues. Stakeholder And Entity Management
• Act as the Group point of contact for Internal Model data quality framework.
• Work across actuarial, risk, IT, data governance, control and entity teams.
• Animate the Data Quality community.
• Escalade to the top management the results of the campaigns
• Candidate profile
• Essential experience and knowledge
• Background combining actuarial and data engineering (data governance and data quality disciplines).
• Good understanding of insurance risk, Solvency II and quantitative calculation processes; Internal Model or STEC experience is preferred.
• Hands-on experience with Collibra or a comparable enterprise data governance platform.
• Robust Power BI capability, including data modelling and Power Query.
• Working knowledge of SQL and Python, or equivalent coding tools, for data extraction, transformation, reconciliation and automation.
• Ability to understand complex transformations and translate them into testable controls.
• Experience coordinating multi-entity control, reporting or data quality processes.
• Robust analytical, documentation, challenge and stakeholder-management skills. You will report to Vice President, Group Services. What You Will BRING We’re looking for someone who has these abilities and
skills:
Required Skills And Abilities
• Background combining actuarial and data engineering (data governance and data quality disciplines).
• Valuable understanding of insurance risk, Solvency II and quantitative calculation processes; Internal Model or STEC experience is preferred.
• Hands-on experience with Collibra or a comparable enterprise data governance platform.
• Robust Power BI capability, including data modelling and Power Query.
• Working knowledge of SQL and Python, or equivalent coding tools, for data extraction, transformation, reconciliation and automation.
• Ability to understand complex transformations and translate them into testable controls.
• Experience coordinating multi-entity control, reporting or data quality processes.
• Robust analytical, documentation, challenge and stakeholder-management skills.
• A hybrid actuarial/data/IT professional who can discuss Internal Model calculations with actuaries, challenge critical transformations with IT teams, maintain end-to-end Collibra lineage, interrogate and reconcile data using code, and deliver reliable Power BI dashboards for Group management. Desired Skills And Abilities
• Complete, accurate and current Internal Model data lineage in Collibra.
• On-time execution and complete reporting of Q2 and Q4 STEC controls by entities.
• Reliable Power BI dashboards.
• Percentage of failed controls supported by an approved action plan and accountable owner.
• Timely closure of remediation actions, with effectiveness confirmed and recurrence monitored.
• Reduction in missing lineage, uncontrolled transformations, overdue actions and recurring failures.
• Increased automation and reduced manual effort in campaign preparation, consolidation and reporting.
• University degree in actuarial science, mathematics, statistics, computer science, data engineering, finance, risk management or a related quantitative field.
• Relevant actuarial, data governance, data management, Power BI or technology certification is advantageous.
• Professional English required; additional languages are an advantage in a multi-entity Group environment. Who WE are AXA XL, the P&C; and specialty risk division of AXA, is known for solving complex risks. For mid-sized companies, multinationals and even some inspirational individuals we don’t just provide re/insurance, we reinvent it. How? By combining a comprehensive and efficient capital platform, data-driven insights, leading technology,
and the best talent in an agile and inclusive workspace, empowered to deliver top client service across all our lines of business − property, casualty, professional, financial lines and specialty. With an innovative and flexible approach to risk solutions, we partner with those who move the world forward. Learn more at axaxl.com
What we OFFER
Inclusion AXA XL is committed to equal employment opportunity and will consider applicants regardless of gender, sexual orientation, age, ethnicity and origins, marital status, religion, disability, or any other protected characteristic. At AXA XL, we know that an inclusive culture and enables business growth and is critical to our success. That’s why we have made a strategic commitment to attract, develop, advance and retain the most inclusive workforce possible, and create a culture where everyone can bring their full selves to work and reach their highest potential. It’s about helping one another — and our business — to move forward and succeed.
• Five Business Resource Groups focused on gender, LGBTQ+, ethnicity and origins, disability and inclusion with 20 Chapters around the globe.
• Robust support for Flexible Working Arrangements
• Enhanced family-friendly leave benefits
• Named to the Diversity Best Practices Index
• Signatory to the UK Women in Finance Charter Learn more at axaxl.com/about-us/inclusion-and-diversity. AXA XL is an Equal Opportunity Employer. Total Rewards AXA XL’s Reward program is designed to take care of what matters most to you, covering the full picture of your health, wellbeing, lifestyle and financial security. It provides competitive compensation and personalized, inclusive benefits that evolve as you do. We’re committed to rewarding your contribution for the long term, so you can be your best self today and look forward to the future with confidence. Sustainability At AXA XL, Sustainability is integral to our business strategy. In an ever-changing world, AXA XL protects what matters most for our clients and communities. We know that sustainability is at the root of a more resilient future. Our 2023-26 Sustainability strategy, called “Roots of resilience”, focuses on protecting natural ecosystems, addressing climate change, and embedding sustainable practices across our operations. Our Pillars
• Valuing nature: How we impact nature affects how nature impacts us. Resilient ecosystems
- the foundation of a sustainable planet and society – are essential to our future. We’re committed to protecting and restoring nature – from mangrove forests to the bees in our backyard – by increasing biodiversity awareness and inspiring clients and colleagues to put nature at the heart of their plans.
• Addressing climate change: The effects of a changing climate are far-reaching and significant. Unpredictable weather, increasing temperatures, and rising sea levels cause both social inequalities and environmental disruption. We're building a net zero strategy, developing insurance products and services, and mobilizing to advance thought leadership and investment in societal-led solutions.
• Integrating ESG: All companies have a role to play in building a more resilient future. Incorporating ESG considerations into our internal processes and practices builds resilience from the roots of our business. We’re training our colleagues, engaging our external partners, and evolving our sustainability governance and reporting.
• AXA Hearts in Action: We have established volunteering and charitable giving programs to help colleagues support causes that matter most to them, known as AXA XL’s “Hearts in Action” programs. These include our Matching Gifts program, Volunteering Leave, and our annual volunteering day – the Global Day of Giving. For more information, please see axaxl.com/sustainability.
📌 Data Quality Manager (Gurugram)
🏢 AXA XL
📍 Gurugram