15 Nov
|
AXA XL
|
Gurugram
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.
Collibra Data Lineage Ownership
- Manage and maintain end-to-end data lineage for the Solvency II Internal Model in Collibra. (Support entities in documenting their data lineage.
- Perform and manage Collibra extracts for control campaigns, analysis and Power BI reporting. (Challenge whether documented lineage reflects the actual actuarial and technical process, rather than only checking administrative completeness.
Owner Of The Data Quality Framework
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.
Coordinate the half-year/Q2 and year-end/Q4 STEC data quality control campaigns.
~ 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
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.
Ensure material control failures are investigated and supported by root-cause analysis.
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
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.
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.
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.
Complete, accurate and current Internal Model data lineage in Collibra.
Reliable Power BI dashboards.
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.
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.
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. 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 advantages
Named to the Diversity Best Practices Index
Signatory to the UK Women in Finance Charter
com/about-us/inclusion-and-diversity. AXA XL is an Equal Opportunity Employer.
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.
In an ever-changing world, AXA XL protects what matters most for our clients and communities. Our 2023-26 Sustainability strategy, called 'Roots of resilience', focuses on protecting natural ecosystems, addressing climate change, and embedding sustainable practices across our operations.
Resilient ecosystems - the foundation of a sustainable planet and society – are essential to our future. 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.
📌 Data Quality Manager (SQL) (Gurugram)
🏢 AXA XL
📍 Gurugram