Data Engineer - Actuarial

Job Overview

The Actuarial Function falls under the remit of the Chief Financial Officer and works closely with the underwriting, claims, sales and pricing departments. We are looking for a talented data engineer to join the actuarial team to help us better utilise our data and enhance our operating processes. If you are data curious, excited about deriving insights from data, and motivated by having an impact on the business, we want to hear from you.

Job Responsibilities

Working together with reserving actuaries, the data engineer will be responsible for:

• Developing, maintaining and refreshing datasets in MSSQL and SSAS tabular.
• Developing and maintaining a variety of SSIS ETL packages.
• Developing and maintaining a variety of SSRS reports to ensure data quality.
• Identifying opportunities to automate manual data processes, improving efficiency, and reducing operational risk.
• Identifying, analysing, and resolving performance issues in SQL Server databases, optimizing queries and system resources to improve efficiency.
• Monitoring and addressing the impacts of the new claims system on data pipelines and structures, ensuring seamless integration and minimal disruption to actuarial workflows.

• Producing accurate, reliable and timely reports on claim trends, keeping a strong focus on quality, completeness and accuracy of reporting data.

Job Responsibilities

• Analysing data, interpreting results and providing written summaries of analysis in a style and format that can be understood by business users.

• Participating in the gathering and delivering of data requirements in cross functional projects.
• Representing the actuarial department’s interest at a variety of data related committees.
• Creating and updating documentation in relation to the reports and business logic.

Education

• Computer Science, Data Science, Statistics, Maths or Business Degree

Experiences

• Experience with SQL Server database administration
• Intermediate to advanced SQL competency
• Computer literate with strong knowledge of SQL, MS Access, Excel and other Microsoft Office applications
• Ability to create ad-hoc reports using SQL extraction
• Strong SSIS experience with particular emphasis on developing ETL packages
• Strong knowledge of quality assurance practices for data processing and analytics
• Experience of developing, maintaining and running SSRS reports
• Experience of all aspects of SSAS tabular models
• Tableau desktop experience, an advantage
• Strong problem solving, analytical skills and decision-making ability
• Effective communication, presentation and interpersonal skills
• Experience with large data sets, data manipulation, and data cleansing
• Strong focus on quality, documentation, attention to detail, completeness and accuracy of reporting data

Competencies

• Self-motivated with the ability to work on own initiative and an active desire to develop knowledge and experience.
• An ambitious attitude, an individual who is self-aware and willing and able to grow and develop further assuming increased responsibility with experience and opportunity.
• Strong focus on quality, completeness and accuracy. 
• Effective planning, organisation and problem-solving skills.
• Excellent oral and written communication skills, with an ability to discuss and explain report findings in a clear and concise manner.
• Good relationship development skills and capable of working proactively with internal and external business colleagues.

MCC

This role sits within Pay Band M/S of FBD’s Commercial's Pay band

Footer

FBD is an inclusive Equal Opportunity employer that considers applicants irrespective of their age, gender, ethnicity, culture, religion, language, sexual orientation, ability, disability and social circumstances.