Data and Business Intelligence Manager

  • Job Reference: NHBC5471
  • Date Posted: 11 January 2021
  • Employer: NHBC
  • Website: http://www.nhbc.co.uk/
  • Location: Remote Working
  • Salary: £41,500 to £45,000
  • Bonus/Benefits: Pension, Private Healthcare, 26 days holiday, Employee Assistance
  • Sector: Construction, Insurance & Superannuation
  • Job Type: Full Time
  • Duration: Perm

Job Description

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

About you

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

Tableau Reporting

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

Pro-active innovator

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.

Why NHBC?
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.

Our Values
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