Senior BI Data Business Analyst

This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.

Overview

About us

IQUW is a speciality (re)insurer at Lloyd's (Syndicate 1856) underwriting a diverse range of Property, Commercial and Speciality (re)insurance products from Cargo and Marine to Political Violence, Terror and War. We combine data, intelligent automation and human expertise to make smart decisions, fast.

ERS is the UK's largest specialist motor insurer with an A+ rating. We recognise that for some, motor insurance is more than just a must-have; it's a way of taking care of what stands at the heart of their passion or livelihood. For those people, standard insurance isn't enough. That's why we work exclusively with motor insurance brokers to help get under the skin of the most difficult insurance risks, helping build products to meet their customer's needs.

The role

• Exciting Opportunity to join a Lloyds Market Syndicate that is in year one of a multi-year Data & Analytics Transformation program using Modern Cloud Technologies that aims to create a market leading data function and cloud enabled data lake and warehouse that aims to support current and future data needs of a growing Lloyds Syndicate.
• The Senior Data Business Analyst is a multifaceted role that aims to encompass a blend of technical, analytical, and soft skills. Ideally with an Insurance background in Lloyds or Commercial Insurance. You will have extensive experience in techno functional role within a data function or data programs/projects.
• The successful candidate will be responsible for defining, designing, and supporting key aspects of the implementation of data analytics products and solutions that will inform strategic decisions.
• Additionally, the role will include supporting data governance standards, and leading prototyping of sophisticated data solutions and reporting products / MI and dashboarding.

Key responsibilities

• Problem-Solving: Excellent problem-solving abilities to address business challenges through data-driven solutions. You should be confident in facilitating business requirements gathering sessions and presenting findings following analysis to support recommendations.
• Specification and Documentation: Ability to write functional specifications and supporting designs ranging from: Mapping specs, data flows, report designs, SQL and pseudo code, functional design documents and using diagrams and appropriate templates to convey complex process, systems, designs or data models.
• Data Analysis and Investigations: Utilise Complex SQL, Excel, Python, and Power BI to perform advanced data analysis and prototyping to bring to life ideas and or to provide actionable insights and recommendations.
• Data Solutions design: Design and define data solutions, complex calculations, and processes with support of Data Architect and business stakeholders .
• Analytical Process Improvement: Assess and enhance data analysis processes for increased efficiency and accuracy.
• Data Modelling: Develop and utilize data models, define conceptual designs of data structures and models specifically Star Schema Designs to support the business's analytical needs and extend the data warehouse.
• Insightful Recommendations: Provide recommendations based on data analyses that influence key business decisions and solution design.
• Data Governance: Ensure adherence to data governance framework, support implementation of specific areas of framework, define procedures to maintain data integrity and compliance and support specific initiatives in partnership with Data Governance teams
• Reporting, Visualisation and data story telling: Use data visualization tools to create reports that communicate complex data in an understandable manner, have experience and understand of displaying data effectively to design compelling reports and dashboards that help convey insight for improved decision making.
• Training, Presentation and Leadership: Train colleagues and business users of usage of data products and present confidently on outputs of data analysis and reports. and lead cross-functional project teams and specific data initiatives.
• Quality Assurance: Run quality assurance, recons , UAT on data projects and data solutions designed to ensure the reliability of data sources, calculations and specifications produced.
• Project Collaboration: Collaborate with business teams, project managers, architects and technical leads to ensure successful project implementation.
• Continuous Learning: Eagerness to stay updated with the latest industry trends and technologies and approaches to support role and data function.

Qualifications, skills and experience

• Solid hands-on experience with SQL, familiarity with range of data modelling approaches and Python ( Bonus)
• Hands-on experience in designing data solutions, reports, calculation logic, data processes, dash boards.
• Experience in working with Data Warehousing projects and knowledge and experience of Kimball star schema dimensional modelling.
• Strong data analysis, problem solving, information analysis, attention to detail with a flexibility of approach.
• The ability to deal with business functions and interpret their thoughts into successful data & analytics solutions.
• The ability to analyse and design BI/MI solutions in line with agreed architectural principles.
• Strong interest in latest data engineering technologies, establishing best practises, techniques, and trends in the data industry.

Benefits

• Competitive Benchmarked Salary
• 25 days holiday
• Discretionary bonus scheme
• Employee assistance programme
• Annual holiday buy (up to 3 extra days)
• Salary sacrifice benefits
• Annual benefits reviews
• The option for professional qualifications and study support

Additional Information

• A full job description can be seen here.