Data Manager (BI)

W. R. Berkley Corporation; London, East Midlands; On-site; GBP 60,000 - 80,000; Full time

Job summary

A leading company in the insurance sector is seeking a Data Manager to support data management and analytics. The role involves overseeing the data platform, ensuring data integrity, and collaborating with business functions to deliver data solutions. The ideal candidate will have strong technical skills in Microsoft technologies and experience in data engineering. This position plays a critical role in enhancing the company's data capabilities and meeting reporting needs.

Qualifications

• Solid experience with Microsoft Technology Stack and SQL.
• Proven ability in data engineering and BI software development.

Responsibilities

• Support the Head of Data in building an effective data management platform.
• Design and develop ETL/ELT processes and data warehouse solutions.
• Assist in data governance and validation checks.

Skills

Data Modelling

Problem Solving

Information Analysis

Attention to Detail

Flexibility

Tools

Microsoft SQL Server

Power BI

Python

MDX

DAX

Kimball Data Modelling

Job description

Company Details

Required Skills & Knowledge:

• Solid hands-on experience with Microsoft Technology Stack (2022)
• Extensive experience of SQL/ data warehousing
• Proven experience of data engineering activities such as release management, environment controls, CICD pipeline orchestration.
• Experience working with Python and Power BI
• Proven ability of Microsoft BI software development including database / reporting development, full development cycle
• Strong data modelling, problem solving, information analysis, attention to detail, flexibility of approach.
• The ability to deal directly with business functions and interpret their thoughts into successful data & analytics solutions.
• The ability to design and develop complex BI/MI solutions in line with agreed architectural principles and toolsets.
• Capable of working closely with the business and delivering complex requirements to tight timescales.
• Strong interest in latest data engineering technologies, best practises, techniques and trends in the data industry

Required Toolsets:

• Kimball data modelling
• Microsoft SQL Server
• Analysis Services (Multidimensional/Tabular), Power BI
• Python, MDX, DAX

Responsibilities

The Data Manager will be responsible for supporting Head of Data and Analytics and wider business to build and deliver the components of an effective enterprise data management platform for WRBU, utilising Microsoft Technology stack for data ingestion, transformation & storage and Power BI for end-user data analytics and reporting. The role will play a critical part in the architectural design and implementation of these elements – capable of meeting a wide range of financial and underwriting reporting/analytics needs. The role will encompass a mix of hands-on technical leadership, team management, stakeholder relations; supporting WRBU to continue its journey to develop its data platform on next-generation technology.

• Data Support: Assist the Head of Data and Technology as a Subject Matter Expert in Data. Act as a senior custodian of the WRBU Data Platform; administering ETL/ELT pipelines, completing peer/code reviews, ensuring the integrity of WRBU data, and holding accountability for data integrity and accuracy.

• Data Warehousing: Help manage aspects of the data warehousing landscape and data movements, including assisting with solution design for new and existing requirements. Collaborate with the business to understand needs. Design and develop ETL/ELT processes, data lake storage architecture, data warehouse, data marts, cubes, reports and dashboards; in-line with the company data management framework and enterprise data strategy.

• MI Development and Maintenance: Support the development and maintenance of Management Information (MI). Assist in gathering requirements for reports or data extracts, developing and agreeing on specifications with the business community, and helping to develop, test, and roll out reports to end users. Provide ongoing support for the production and delivery of these reports. Take ownership of incidents and define remediation plans, with the support of the wider team, to ensure production issues are resolved in line with WRBU’s triage process.

• Data Validation: Assist in developing, implementing, and embedding validation checks for data entry based on business rules in line with Solvency II, Sox and business requirements. Work in collaboration with wider business and act as a Senior contributor on the design, build, and management of WBRU Data Platform; taking direct ownership of data engineering activities and responsibilities and ensure that all new data requirements are met using the most appropriate architecture components and engineering practice.

• Data Governance: Support the ongoing implementation and development of the data governance policy. Help manage data in line with Solvency II and Sox requirements and assist in prioritizing and developing new reports or data extracts. Ensure the business has a transparent view of progress and delivery timescales.

• Market Messages: Help ensure that market messages are processed in a timely manner and assist in resolving any issues quickly.

• MI Projects: Assist in reviewing and signing off on the business and technical requirements of MI projects or the MI aspects of other projects. Provide support throughout the project lifecycle. Assess business requirements and build data solutions to meet business needs. Assist in developing WRBU-specific data management framework policies, processes, and standards.