Data Analyst/Data Management Specialist

Stephens Scown LLP; Exeter; Hybrid; GBP 35,000 - 45,000; Full time

Job summary

A leading law firm in Exeter is seeking a Data Analyst/Data Management Specialist to manage, analyse, and optimise organisational data for decision-making. Candidates should have strong SQL skills and experience with data warehousing solutions. You will collaborate with stakeholders, develop ETL processes, and ensure data integrity. This position offers a competitive salary and benefits, including hybrid working options. The ideal candidate will demonstrate adaptability, high attention to detail, and a drive for excellence.

Benefits

25 days holiday plus bank holidays

Private medical insurance

Group life assurance

Comprehensive wellbeing support

Paid leave for good causes

Qualifications

• Proficiency in Data Querying & Language (SQL essential).
• Experience with cloud-based data platforms.
• Understanding of data governance frameworks.

Responsibilities

• Design, develop, and maintain SQL queries and scripts for ETL.
• Manage and optimise data warehousing environments.
• Analyse large datasets to identify trends and insights.

Skills

Data Querying & Language (SQL)

Data transformation and wrangling

Cloud data warehouse

Reporting and visualisation

Advanced analytics & ML

Data Access and Ecosystem knowledge

Experience with cloud-based data platforms

Understanding of data governance frameworks

Exposure to scripting languages (Python, R)

Job description

The Role

The Data Analyst / Data Management Specialist will be responsible for managing, analysing, and optimising organisational data to support business decision-making. This role requires strong technical skills in SQL and experience with data warehousing solutions.

Key Responsibilities:

• Design, develop, and maintain SQL queries and scripts for data extraction, transformation, and loading (ETL).
• Manage and optimise data warehousing environments to ensure data integrity and performance.
• Analyse large datasets to identify trends, patterns, and actionable insights.
• Collaborate with stakeholders to define data requirements and deliver accurate reports.
• Ensure compliance with data governance and security standards.
• Support ad hoc data requests and provide technical expertise for data-related projects.

About You

Qualifications and Experience:

• Proficiency in Data Querying & Language (SQL essential)
• Data transformation and wrangling
• Cloud data warehouse
• Reporting and visualisation
• Advanced analytics & ML
• Data Access and Ecosystem knowledge

Skills:

• Experience with cloud-based data platforms.
• Understanding of data governance frameworks.
• Exposure to scripting languages (Python, R) for advanced analytics.

Personal Attributes:

• Adaptability and resilience in a dynamic environment
• High attention to detail and a commitment to excellence
• Self-confidence and a self-motivator
• Commercial

What we can offer you

• We offer a competitive salary and an impressive array of benefits and rewards. Not least of these is through the Firm’s employee-ownership status, where every employee is listened to, helps to realise our vision and receives an equal share in our annual profit-share.
• Our hybrid working model and approach to flexible working enables our people to share their working time between home and the office to support a healthy work / life balance.
• Employee benefits – including 25 days holiday (plus bank holidays and your birthday), private medical insurance, group life assurance, access to a comprehensive range of wellbeing support, and three additional days’ paid leave to support good causes.
• Progression opportunities – including, regular training, qualification options, mentorship, and continued professional development.

Why Stephens Scown?

Working here is something else entirely. It’s a place where we can step up to tough challenges with people so good they inspire us to be better. We proudly work in a beautiful part of the country, go beyond expectations and achieve things that matter.

Owning It Matters…

We’re the UK’s first major employee-owned law firm. But more than this, we’re people-centred, people-powered. We do what it takes to help each other overcome every challenge. Whatever’s happening in the world, empowering our people is what matters.

Our communities and colleagues give us a lot to be thankful for. So we try to make them feel as valued as our clients. Whether we’re digging deep and giving our time and money, picking up rubbish from our streets and beaches, at Stephens Scown, if it’s right, it matters.

We might have the expertise of a top city firm, but outside our offices there’s not a skyscraper in sight. Whether we’re getting to know our clients on our local beach or having fun in the park with colleagues, we’re all about living a life enriched by work. Making the fun matter.

Apply for this position

If this sounds like you and you would like to be considered for this opportunity,please send your application by email enclosing an upto date CV [e-mail] or by post to: HR Department, Stephens Scown LLP, Curzon House, Southernhay West, Exeter, EX1 1RS

At Stephens Scown, we believe that a diverse workforce delivers better results for ourclients and creates a happier workplace where everyone feels valued and appreciated. Thereforewe welcome applications from candidates from all backgrounds, abilities and beliefs.

All offers of employment at Stephens Scown are subject to Basic level of Disclosure and BarringService check. Any information gathered in relation to the DBS process is held in in accordancewith all relevant data protection regulations. Having a criminal record will not necessarilybar you from working with us. This will depend on the nature of the position and the circumstancesand background of your offences. At interview, or in a separate discussion, we ensure that an openand measured discussion takes place on the subject of any offences or other matter that might berelevant to the position. Failure to reveal information that is directly relevant to the positionsought could lead to withdrawal of an offer of employment. We make every subject of a DBSDisclosure aware of the existence of the DBS Code of Practice. This is available onhttps://www.gov.uk/government/publications/dbs-code-of-practice