Business Data Analyst

Data Business Analyst, London Market, Insurance London/Hybrid Initial 6-month contract £650 a day (inside IR35) Insurance, London Market, SQL Data Business Analyst with strong experience working within insurance (speciality lines) and strong SQL skills is required to join a buoyant City-based Insurance group. This role will see you collaborating with various stakeholders to gather, analyse, and interpret data, and to provide valuable insights that will support strategic decision-making and operational efficiency. You will play a pivotal role in bridging the gap between business needs and technical solutions, focusing on data-driven insights and analytics. The ideal candidate will have a strong technical data background, a deep understanding of the specialty insurance domain, and the ability to translate complex business requirements into actionable data solutions. Key Responsibilities: • Collaborate with business stakeholders to understand and document data requirements for various projects and initiatives within the specialty insurance domain. • Work closely with underwriters, actuaries, and other business units to capture and analyse data needs from various source systems (Policy, Claims , Revenue etc.) • Data flow mapping from source to target system data models. • Conduct thorough data analysis and profiling to identify data quality issues, anomalies, and patterns, gaps. • Provide insights and recommendations for improving data quality and integrity. • Understanding of conceptual, logical, and physical data models and database schemas. • Monitor, validate and reconcile the data collected on an ongoing basis, establishing internal confidence in the accuracy of the data available • Translate business requirements into technical specifications for data solutions, ensuring alignment with industry best practices and organisational standards. • Collaborate with IT and the Central Data Office functions to support the design and implementation of data models, ETL processes, and data warehouses/lakes. • Work closely with data engineers, developers, and architects and BI Developers to implement data solutions that meet expected requirements. • Create comprehensive documentation for data solutions, including data dictionaries, business glossaries, process flows, and user guides. Key Requirements: • Solid hands-on data business analysis experience, within Insurance (London Market experience a significant advantage). • Proven experience working with data in an agile and dynamic team, with experience working with relational databases (hands on intermediate to advanced SQL coding experience is essential and experiences writing in Python preferred but no essential) • Curiosity in examining complex SQL data sets with experience in reconciliation and data lineage / traceability. • Experience in interpreting technical coding (such as SQL and Python) into business language and terminology. • Demonstrated experience in translating business requirements into data requirements and collation of these to inform the future direction of data capabilities • Cloud based technologies preferrable MS Azure • Ability to effectively communicate, present and articulate strategies across various audiences especially with non-technical business functions • Understanding and knowledge of system development life cycle methodologies (such as agile software development, rapid prototyping, incremental, synchronize and stabilize, and DevOps)