At a Glance
- Tasks: Lead data management and analytics projects using Microsoft technologies.
- Company: Join a forward-thinking company focused on innovative data solutions.
- Benefits: Enjoy flexible working options and opportunities for professional growth.
- Why this job: Be part of a dynamic team shaping the future of data analytics.
- Qualifications: Experience with SQL, Power BI, Python, and data engineering is essential.
- Other info: Opportunity to work on cutting-edge data technologies and governance.
The predicted salary is between 36000 - 60000 £ per year.
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.
Data Manager (BI) employer: WR Berkley
Contact Detail:
WR Berkley 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 latest version. Being well-versed in tools like SQL Server Analysis Services and Power BI will give you a significant edge during discussions with our team.
✨Tip Number 2
Showcase your experience with data engineering activities, particularly in release management and CI/CD pipeline orchestration. Be prepared to discuss specific projects where you've successfully implemented these practices.
✨Tip Number 3
Highlight your problem-solving skills and attention to detail. We value candidates who can interpret business needs into effective data solutions, so think of examples where you've done this in the past.
✨Tip Number 4
Stay updated on the latest trends in data engineering technologies. Demonstrating your passion for continuous learning and innovation in the field will resonate well with us during the interview process.
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 BI software development and data modelling.
Craft a Strong Cover Letter: In your cover letter, express your enthusiasm for the Data Manager role and how your background aligns with the company's needs. Mention your experience with Power BI and Python, and how you can contribute to their data management platform.
Showcase Relevant Projects: If you've worked on projects involving ETL/ELT processes or data warehousing, be sure to include these in your application. Detail your role and the impact of your contributions to demonstrate your capability in delivering complex BI solutions.
Highlight Problem-Solving Skills: Given the emphasis on problem-solving and attention to detail in the job description, provide examples of challenges you've faced in previous roles and how you successfully resolved them. This will showcase your analytical skills and flexibility.
How to prepare for a job interview at WR Berkley
✨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've used these skills, especially in relation to BI software development.
✨Demonstrate Problem-Solving Abilities
Prepare examples that showcase your problem-solving skills and attention to detail. Discuss how you've tackled complex data challenges in the past and the impact of your solutions on the business.
✨Understand Business Needs
Be ready to explain how you interpret business requirements into successful data and analytics solutions. Show that you can communicate effectively with non-technical stakeholders and understand their needs.
✨Stay Updated on Industry Trends
Express your interest in the latest data engineering technologies and best practices. Mention any recent trends or tools you've explored and how they could benefit the company’s data management strategy.