NHBC have an amazing opportunity for a Data & Business Intelligence Manager to join their Actuarial Data and Business Intelligence team. The Actuarial Department is part of the Chief Financial Officer’s directorate. The Department’s objectives relate to reserving, pricing, reinsurance, management information and data analytics activities.
The actuarial data and business intelligence team are responsible for monthly production and reporting of a range of data sets, including registration data, policy and claims data. They also have the objective to develop and improve the data production and reporting processes.
About the role
Maintain and improve existing actuarial data processes, including the production of the actuarial policy and claims databases and the Major Projects bordereau. Eventually replace data sourced from NHBC’s policy and claims administration systems with data sourced from NHBC’s Enterprice Data Warehouse.
Link the actuarial databases to the Enterprise Data Warehouse
Develop the functionality of the Actuarial Data Repository
Understanding Capital modelling data requirements and data regulatory compliance
Migrate existing reporting to Tableau and design new reports
Support the production of new data required for actuarial analyses.
Liaise with IT as regards systems improvements
Take responsibility for actuarial data quality and governance
Engage with data quality audits
Liaise with stakeholders and customers, e.g. external recipients of reports generated by the Actuarial BI team
Develop the data and BI team
Strong database development and analysis experience, including:
Demonstrable experience in using SQL (MS SSRS, SSAS, SSIS) and MS Access
Query development and optimisation – debugging, fixing and enhancing queries
In depth experience in ETL development, Capital Models Data repository.
Proven experience of the software development lifecycle
Data analysis and Testing experience
IBM Cognos and Planning Analytics experience
Reporting tools experience such as Tableau (NHBC adopted tool) or other analytical tools.
Support Actuarial applications such as IBM TM1/Planning Analytics/ R Studio/ R Client/ ML Server
Data Governance processes, including the design and deployment of such processes.
Extensive experience with MS Excel and Access with VBA coding/Macro experience.
Have a maths and programming background.
Degree level education in a computer science based subject or equivalent
Problem-solving skills; desire to push the team forward from a technical perspective; desire bring in new solutions to improve efficiency and allow new ways of looking at data
Planning and time management
Strong writing and documentation skills
Good personal communication skills
Knowledge of actuarial techniques, market practice, relevant legislation and insurance market environment, awareness of emerging market developments
Collaborative attitude; team player
Self-starter; ability to work independently and drive project forwards
Accurate and diligent
Salary & Benefits
£41,500.00 - £45,000.00 per annum (dependent on experience)
Up to 6% performance related bonus. 25 days pa annual leave with option to purchase one additional week per year.
Pension scheme to Pension Mark Plus standards (up to 10.5% of salary employer contribution).
Equalised Paternity, Maternity and Adoption Leave.
Life assurance of 4 x salary.
Subsidised private medical insurance.
Cycle purchase scheme.
High street discounts and preferential gym rates.
Employee assistance programme.
Apart from working with great colleagues who are passionate about what they do, we pride ourselves on developing individuals to achieve their full potential and offer exceptional personal development and career progression opportunities. We also support, sponsor and pay for training and membership to relevant professional organisations. All necessary equipment and other allowances associated with working from home will be provided.
Always happy to talk flexible working
We encourage employees to work flexibly in different ways including home working, field working and both formal and informal flexible working arrangements. We don’t promise we can offer you what you want, but we are always happy to talk flexible working. In the interview process we’ll discuss this more with you.
Diversity and Inclusion
NHBC is committed to equal opportunities for all. We are a signatory to the Armed Forces Covenant and the Women in Finance Charter. Our inclusive culture helps us to maintain competitive advantage as we aim to attract people from diverse backgrounds to complement our team. Underlying our overall commitment to equality is the fundamental belief in the right of all employees and customers to be treated with dignity and respect and to be guaranteed freedom from discrimination.
Excellent – Proud and professional in all that we do.
Connected - Collaborating, sharing and achieving success as a team.
Human - Challenging, supporting and respecting each other.
Progressive - Inspired by possibilities, learning and adapting together.
Closing Date: Tuesday 19th January 2021