At a Glance
- Tasks: Lead data management and analytics projects using Microsoft technologies.
- Company: Berkley Specialty London is a dynamic insurance company focused on innovative data solutions.
- Benefits: Enjoy a full-time role with opportunities for growth and learning in a tech-driven environment.
- Why this job: Join a forward-thinking team and make an impact in the data industry while developing your skills.
- Qualifications: Experience with Microsoft Tech Stack, SQL, Python, and Power BI is essential.
- Other info: This role offers a chance to work closely with business functions and shape data strategies.
The predicted salary is between 28800 - 42000 £ per year.
Join to apply for the Data Manager (BI) role at Berkley Specialty London (a Berkley Company).
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 practices, techniques and trends in the data industry.
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 practices, 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.
Seniority level: Mid-Senior level
Employment type: Full-time
Job function: Information Technology
Industries: Insurance
Data Manager (BI) employer: Berkley Specialty London (a Berkley Company)
Contact Detail:
Berkley Specialty London (a Berkley Company) Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Manager (BI)
✨Tip Number 1
Familiarise yourself with the Microsoft Technology Stack, especially the 2022 version. Make sure you can confidently discuss your hands-on experience with SQL and data warehousing, as these are crucial for the Data Manager role.
✨Tip Number 2
Brush up on your Python and Power BI skills. Being able to demonstrate your proficiency in these tools during discussions will set you apart from other candidates.
✨Tip Number 3
Prepare to showcase your problem-solving abilities and attention to detail. Think of specific examples where you've successfully interpreted business needs into data solutions, as this is a key aspect of the role.
✨Tip Number 4
Stay updated on the latest trends in data engineering technologies and best practices. Showing your enthusiasm for continuous learning can impress interviewers and demonstrate your commitment to the field.
We think you need these skills to ace Data Manager (BI)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your hands-on experience with the Microsoft Technology Stack, SQL, and data engineering activities. Use specific examples to demonstrate your skills in Python and Power BI.
Craft a Compelling Cover Letter: In your cover letter, express your strong interest in the latest data engineering technologies and how your background aligns with the responsibilities of the Data Manager role. Mention your ability to interpret business needs into successful data solutions.
Showcase Relevant Projects: Include any relevant projects or experiences that showcase your ability to design and develop complex BI/MI solutions. Highlight your problem-solving skills and attention to detail in these examples.
Proofread and Edit: Before submitting your application, thoroughly proofread your documents for any errors. Ensure that your language is clear and professional, reflecting your attention to detail, which is crucial for this role.
How to prepare for a job interview at Berkley Specialty London (a Berkley Company)
✨Showcase Your Technical Skills
Make sure to highlight your hands-on experience with the Microsoft Technology Stack, SQL, and data warehousing. Be prepared to discuss specific projects where you utilised these skills, as this will demonstrate your capability to handle the technical demands of the role.
✨Demonstrate Problem-Solving Abilities
Prepare examples that showcase your problem-solving skills, particularly in data engineering activities. Discuss how you've tackled complex issues in past roles, especially those involving release management or CICD pipeline orchestration.
✨Understand Business Needs
Familiarise yourself with how data analytics solutions can directly impact business functions. Be ready to explain how you've previously interpreted business requirements into successful data solutions, as this will show your ability to bridge the gap between technical and non-technical stakeholders.
✨Stay Updated on Industry Trends
Express your strong interest in the latest data engineering technologies and best practices. Mention any recent trends or tools you've explored, as this will reflect your commitment to continuous learning and staying relevant in the fast-evolving data landscape.