Senior Data Analyst

Saffery; Greater London; On-site; GBP 50,000 - 80,000; Full time

Benefits offered by this job

Contributory pension scheme

25 days annual leave

Life assurance cover

Profit-Sharing Plan

Job summary

Saffery LLP seeks a Senior Data Analyst to support the Data Architect, with responsibilities spanning data governance, quality and integration across the enterprise. The role involves advisory work, data modelling, and BI-ready data pipelines, reporting, and dashboards.

You will work across offices with occasional travel, reporting to the Data Architect, and contribute to continuous improvement in data capture and governance practices.

Qualifications

• Completion of A level studies is essential.
• Degree level education is desirable.
• Two years’ experience in a professional services environment (accountancy or legal) preferred.
• Proficiency in Microsoft Power Platform suite and SQL.
• Experience with Power BI reports and data governance.

Responsibilities

• Analyse requests for data-related improvements and assess business impact.
• Provide high-level advisory on business processes and data management.
• Define mapping and synchronization of shared reference data across systems.
• Develop data transformation and loading processes for data models and architecture.
• Create and maintain data quality dashboards and data dictionaries for CDEs.
• Design data models for BI and reporting tools used enterprise-wide.
• Promote the firm's Data Standards and Data Governance Policy.
• Collaborate on cross-functional programme workstreams.
• Identify new data sources and methods to improve data collection, analysis and reporting.

Skills

Data analysis

Data governance

Data quality

Communication

Project management

Documentation

Problem solving

Team player

Attention to detail

Education

A level studies

Degree level education

Tools

Microsoft Power Platform

SQL

Power BI

Azure Logic Apps

Azure Functions

Microsoft Fabric

Azure Data tooling

Job description

The role

The primary role of the Senior Data Analyst is to assist the firms Data Architect. The role can be based at any of our offices, although travel may be required at times to other Saffery offices as the business required. The postholder will report to the Data Architect.

The role will be responsible for analysing requests for improvements in data-related processes, supporting the Data Architect to challenge these requests and propose workable solutions whilst always adhering to the firm's data standards and data governance policy. The job holder will be required to act in an advisory capacity to other areas of the business on managing data and process changes, reviewing processes with the stakeholders. They will be required to assist with the data management aspects of strategic projects and assisting with integrations and advising on data processes for projects.

The job holder will be required to build wireframe solutions, manage data warehouse structures and maintain internal databases where external solutions are not available.

The Office

The role can be based at any of our offices, although travel may be required at times to other Saffery offices as the business requires. The Senior Data Analyst will report to the Data Architect.

The responsibilities

• Analyse and interpret request for improvements in data related processes, and data change requests, discussing these with senior colleagues where necessary. Be able to identify the business impact of the requests, advising on change management and identify where larger scale project management may be required.
• Provide high level advisory on business processes and data management.
• Defining the mapping and synchronisation of shared reference data across systems.
• Provide solutions and proposals to assist with data integrations.
• Develop and maintain data quality dashboards and create and maintain data dictionary for all Critical Data Elements (CDEs).
• Work with stakeholders to analyse data, provide reporting solutions and identify root causes of dysfunction in processes and providing advice on remediation.
• Contribute to the design of data models for use by Business Intelligence and reporting tool and reuse in the Enterprise landscape.
• Actively promote the firm's Data Standards and Data Governance Policy.
• Contribute to the design of processes.
• Participate in cross-functional programme workstreams.
• Design and develop data transformation and loading processes for the population and on-going management of the data models and architecture.
• Look for opportunities for continuous improvement in data capture processes and integration.
• Monitor data quality reports and liaise with data owners to agree remedial action.
• Document data lifecycles and how they relate to business processes.
• Identify new sources of data and methods to improve data collection, analysis, and reporting.
• Create and develop wireframe solutions.
• Create and maintain database solutions using Microsoft Power Platform Tools/SQL databases.
• Introduce and maintain data quality tools.

You

• A motivated self-starter with strong attention to detail, and who understands the value of data and is passionate about accuracy.
• Experience in analysing data, processes, data quality stats, root cause analysis. Able to challenge where necessary.
• Strong communication and relationship building skills with strong project management skills.
• Experience and understanding of the basic operating model of an accountancy/law practice eg Client, Matter and Time Recording is desirable.
• A problem solver able to define pragmatic solutions.
• Ability to use initiative and be pro-active.
• Good at documentation.
• Strong organisational skills and ability to prioritise.
• Ability to cope with conflicting demands and meet deadlines.
• Communicates effectively at all levels. Must have good verbal and written skills.
• Takes personal responsibility for getting things done to agreed timeframes.
• Remains calm under pressure.
• A team player capable of pitching in to help the team.
• Promotes the firms' values and beliefs, demonstrating integrity and maintaining an ethical stance, using flexibility and tact to express views as necessary.

Qualifications

• Completion of A level studies is essential.
• Degree level education is desirable.
• At least two years' experience of working in a professional services environment, ideally accountancy or legal sectors.
• Experience of working on large scale projects and project management.
• Experience of working on Data Quality, Remediation and Data Management programmes.
• Must be proficient in the Microsoft Power Platform suite with the ability to generate applications for internal use.
• Experience with Azure Logic Apps and Azure Functions.
• Experience of working with Microsoft Fabric, pipelines, dataflows and pySpark.
• Must be proficient in the use of SQL. With advanced T-SQL skills, and familiar with functions, stored procedures, and SQL agent jobs.
• Must be able to develop Power BI reports.
• Competent in the use of Microsoft Office products such as Word, Excel, Powerpoint, Visio, Teams.
• Experience of Elite3E, MS Teams, SmartSheets, and Data Management tools.
• Familiarity with Microsoft Purview would be an advantage.

Reward and benefit

• A 35 hour working week with a hybrid working policy with the flexibility to work from home for up to three days per week (our core hours are 10-4)
• Excellent benefits including; contributory pension scheme, 25 days annual leave, Life Assurance cover and great flexible benefits and family friendly policies,
• Eligibility for the firm's Profit-Sharing Plan. Paid in December.

About us

Saffery LLP is an adviser to individuals and businesses across a range of sectors, providing market-leading accountancy, audit, business advisory, tax and VAT services. Founded in 1855, we are the UK's 15th largest accountancy firm.

When you work with us at Saffery, you work with people who know your name, not just a job title. We're a place shaped by friendly, intelligent people who are individually excellent and collectively exceptional. We're committed to our clients, but also to our greatest asset - our people.

As a proud member of Nexia, a leading, international network of independent accounting and consulting firms, we've got access to local insight on a global scale.

Equality, Diversity & Inclusion

Equality, diversity and inclusion is a top priority for us. With our ED&I strategy, Everyone Belongs, we are building on our positive work culture and implementing initiatives to improve diversity and strengthen our equitable culture of inclusion, led from the top.

We hope you will apply to us, whatever your background, ethnicity, gender, age, sexuality, disability or neurodivergence, because individual differences equal collective strength. Built on values of excellence, integrity, enthusiasm and collegiality, Saffery is where Potential meets Personal.