Data and Reporting Business Analyst in London

The role supports the business in the development of high-quality Data Products for internal and external use, ensuring data is accurate, timely, and fit for purpose. It strengthens data governance and quality practices to enable reliable analytics, regulatory compliance and informed decision-making. Working closely with operational and technical teams, the role helps improve efficiency and deliver meaningful insights across the organisation.

Key Responsibilities

• Deliver high-quality data reporting services that meet the needs of the business.
• Build a comprehensive understanding of business processes and terminology.
• Support the Head of Business Systems, Change, Data and Reporting by:
• Contributing to the development of business cases where required.
• Representing the function in internal and external meetings.
• Acting as the key point of contact for Business Teams with queries around Data and Reporting.
• Partner with key stakeholders to define new Data Products for strategic and operational MI/BI insights.
• Run workshops and engagement sessions to elicit requirements, train users in dashboard and report usage.
• Work with the business to define improvements to existing reports, dashboards, processes and data products.
• Act as a SME for source system data including the understanding of the associated data models.
• Engage with business stakeholders to understand problems, clarify needs, and translate these into clear functional requirements.
• Work collaboratively with stakeholders and the wider Data Team throughout the full development lifecycle.
• Perform testing on developed data products to ensure they meet requirements and that data presented is accurate.
• Maintain clear documentation for all relevant processes, reports and solutions.
• Use MI and BI tools to enhance the organisation’s understanding of performance, customer behaviour and progress toward strategic objectives.
• Support the business with urgent requests for data sets and ensure timely delivery, using SQL to extract and transform the data from source systems to relevant output format.
• Support the business with Data Queries relating to standard KPIs and existing reports.
• Support monthly reporting cycles across the business.
• Work closely with the Head of Business Systems, Change, Data and Reporting, IT, and senior stakeholders across HR, Finance, Business Development, Compliance and other areas to improve data quality.
• Support Operational Data (OD) Quality Improvement initiatives by:
• Defining and agreeing OD validation rules.
• Identifying OD issues and working with the business and IT to implement corrective actions.
• Support Data Team colleagues to strengthen Data Quality capabilities and improve overall MI reporting.
• Carry out Ad Hoc duties and tasks that are allocated to you at the discretion of management and that are within your capabilities and within the scope of your post.
• Demonstrate and champion Charles Taylor Values by ensuring Agility, Integrity, Care, Accountability and Collaboration.

Required Skills

• Strong passion for data, data quality, and delivering value through data, reporting and analytics.
• Strong analytical and interpretation skills.
• Skilled in understanding complex data models.
• Strong SQL and T-SQL capabilities, including complex queries and optimisation.
• Able to act as a trusted advisor with strong attention to detail and analytical thinking.
• Skilled in designing complex data models and understanding business operations.
• Experience in data transformation and modelling (Snowflake/Star schemas).
• Expert-level Excel (macros, VBA, advanced formulas).
• Experience developing data products, reports, and dashboards across varied datasets.
• Familiarity with tools such as Azure DevOps or Jira.
• Hands-on development of Power BI Dashboards (highly beneficial).
• Methodical approach with excellent attention to detail with ability to meet deadlines.
• Good problem-solving abilities and independent working style.
• Strong interpersonal skills and ability to work collaboratively with business users.
• Keen to continue developing technical and business knowledge.
• Understanding of insurance, finance, and accounting systems.
• Experience with Sun Systems is an advantage.
• Bachelor’s degree in mathematics, Computer Science, or equivalent experience.

Benefits

• This includes a structured onboarding process, job-specific skills development, online and in-person training, as well as study assistance for professional qualifications.

Equal Opportunity Employer

At Charles Taylor, we are proud to be an Inclusive Employer. We foster an environment of mutual respect with zero tolerance to discrimination of any kind regardless of age, disability, gender identity, marital or family status, race, religion, sex or sexual orientation. We recognise that Diversity, Equity and Inclusion is essential in enabling us to deliver better insurance outcomes and fulfilling our responsibilities to clients, colleagues, and the community. We proactively promote and celebrate differences and strive to create an environment where our people feel included and can reach their full potential. We take pride in our inclusive and diverse culture, which is supported by strong partnerships and a transparent, fair recruitment process.