Data Quality Manager
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).
- 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.
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.