Senior Data Business Analyst
The role
• 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. You will have a minimum 5 years’ 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.
Essential qualifications, skills and experience
• Experience in Commercial Insurance experience, Specialty Lloyds Insurance industry experience would be a preference.
Required Skills & Knowledge
• 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.