Data Management Analyst SQL (SSMS, SSIS)
Start Date: 11/09/2024 | End Date: 25/09/2024
Salary: 0
Job Title: Data Management Analyst – SQL (SSMS, SSIS)
Department / Location: Hybrid - Leeds / Home Working
Reports to: Data Management Team Lead
Hours of Work: 35 hours a week (between the hours of 09.00-17.00) – 1 hour for lunch (some flexibility may be required according to workloads).
Salary: £25,000 to £30,000 (DOE)
Your Role
The Data Management Team are accountable for the provision of data services to the business. Primarily responsible for the validation, cleansing and transfer of data between ourselves, our clients, nominated agents and the courts to a high level of quality and to strict timescales and SLA’s.
The team is a dynamic one where priorities and work volumes change frequently whilst high quality output is always required, and our approach is to ensure all team members have full knowledge of all tasks to support this.
Alongside existing BAU processes we also serve to administer ad-hoc requests made to our IT Ticketing system. Proactively seeking out the background of the request and expected outcomes to both increase the Team knowledge of business processes/strategies and also identify solutions to reduce manual tasks and risk of error.
The individual will also take responsibility for recording of time for Arrow Professional Services, maintaining of the Data Warehouse, reporting of performance to the Practice Area Heads and supporting Group finance in the invoicing of that time. This function reports directly into the Department Head with the outputs being made available to Group CCO and CEO.
Your Tasks
- Maintain and create procedures using MS Office, SQL Management Studio Services, SQL Server Integration Services and Business Objects that enable the automation of otherwise manual methods.
- SSMS audit of automated processes to capture and report completion outcomes via SQL Server Reporting Studio dashboards.
- Exception outputs of automated process ensuring a 100% data exchange correlation between in / out.
- Ensuring the integrity of time recording submissions using the same automated processes within Data Management.
- Reporting of performance of time recording to Group via Power BI
- Supporting Group finance in the process of accurately invoicing Fund for time submitted.
- Maintenance of held data to ensure both data integrity and cases correctly progressing through the account lifecycle within our Case Management System.
- Support across other Departments to enable upgrade and migration from physical data storage to cloud storage
- Quality control & Audit of completed tasks.
- Process internal Data Management task requests, such as bulk data updates into our Case Management System.
- Various Administrative duties relating to the role
Your Skills and Experience
- Knowledge of SQL Server 2014 software (SSMS, SSIS, SSRS) and SQL data referential infrastructure
- Usage of Power BI or similar desirable but not essential
- Working experience using Microsoft office software Excel
- Proven experience in a data centric environment
- Experience of working in a regulated environment
- Ability to deal with multiple areas of work and competing priorities
- Experience of working cross-functionally with all management levels.
- Excellent communication skills with target audience alignment of the messages
Personal Attributes
- Logical and practical approach to problem solving and resolution
- Willing to question why and eagerness to understand drivers behind tasks
- Attention to detail and accuracy
- Target and results driven
- ‘Can do attitude’ within in a fast paced and continuously changing environment
- Team player with ability to share responsibilities via effective delegation
- Some flexibility in working hours to meet business requirements
- Excellent time management skills and ability to meet targets in a fast paced and conflicting priorities environment
- Leading by example, motivating and influencing continuous data driven and logical change mindset
About us…
As one of the UK’s largest law firms dedicated to debt recovery, we play a crucial role in delivering real commercial results while preserving customer relationships. Recognised annually as one of the top-tier firms in the UK by The Legal 500, we are part of the Arrow Global Group, operating in five geographies with over 9 million customer accounts.
This is an opportunity to join an organisation committed to a personalised, client-focused service. Our office is in Leeds city centre, offering proximity to local amenities.
Your usual place of work will be Leeds, with the possibility of working from home, a reliable internet connection at your home address is required.
What we can offer you:
We offer a competitive salary and benefits package, including an excellent annual bonus scheme:
- 25 days holiday + bank holidays
- Length of service holidays (1 day per year up to 5 years)
- Life assurance (4 x annual salary)
- Company sick pay
- Income protection
- Private medical insurance
- Cycle to work scheme
- Pension scheme matching 5%
- Employee Assistance Programme
- Flexible benefits including dental plan, gadget scheme, buy and sell holidays, gymflex, and give as you earn.
We have an employee recognition scheme and a charity foundation allowing employees to nominate registered charities for donations.
Apply now to shape your career path and join our talented teams. Benefit from fantastic training, support, and a great working environment.
Please note – we are an equal opportunities employer, authorised and regulated by the Solicitors Regulation Authority and Financial Conduct Authority. Pre-employment screening includes credit, fraud, criminal record, and 5-year reference checks.
