SQL Developer

The candidate will be expected to provide hands-on assistance to the business and exercise problem solving capabilities on a daily basis. The candidate will maintain an overall understanding of the operation of the ICT infrastructure and Data Management. The main duties the candidate will be expected to carry on will be:

· Writing stored procedures, scalar/table based functions

· Developing data extraction and transformation procedures

· Developing reporting procedures

· Performing basic Database Administration tasks

· Contribute, both in ideas and execution, to the ongoing evolution of the platform architecture

· Database integrity monitoring

· Help in developing internal tools for reporting and data mining

This is a fantastic opportunity for an enthusiastic Developer with a passion for IT to work directly with the Director of ICT. This is a hands-on technical role requiring a detailed understanding of data extraction and transformation as well as relational database and general programming techniques.

You will join our ICT Team in developing a new data warehouse and reporting system as well developing business automation procedures.

Essential skills and experience:

· Advanced knowledge of SQL

· Querying, aggregation and transformation of data using SQL

· An understanding of relational database principles and design

· Ability to learn new technologies and platforms

· Advanced knowledge in SQL Triggers, Stored Procedures and functions

· Experience in SSRS

· Advanced use of MS-Excel

Desirable skills and experience:

· Data migration experience

· Any experience in SSIS

· Any exposure to data warehouse structures and methodologies with modern ETL tools, e.g. Talend

· Data Integration experience

· Familiarity with build and debugging/analysis tools

· Python programming

· Extract, Transform & Load (ETL)

· Experience with Python web frameworks, · Proven ability to work under stress in emergencies, with the flexibility to handle multiple high-pressure situations simultaneously

· Ability to work well under minima supervision

· Excellent communication skills and the ability to explain complex issues in plain English

· Proactive approach and ability to work with colleagues to gain commitment to delivery of high standard products

· Solution focussed. We love Ideas!

· Flexibility, reliable with an extra mile work ethic

Pulled from the full job description

• Free parking
• Company pension
• Casual dress
• Cycle to work scheme
• Car scheme
• On-site parking, · 31+ days’ holidays per year including 8 bank holidays

· Healthcare Scheme*

· Company pension plan

· Allocated Parking Space

· Life Assurance*

· Salary Sacrifice Cycle2work & Electric Car schemes*

• There is a qualifying period for these benefits. They are also subject to a successful probation.

Hybrid Working Opportunities:

We operate a hybrid working pattern which allows colleagues to gain a work life balance with the opportunity to work from office and home for part of the week once you are achieving core competencies. Reviews take place after 3 months of employment, further information will be discussed at interview.

It’s our people that make us a truly exciting and inclusive place to work - a place where you can let your skills shine. If you would like to find out more, you can find this at the Ardent Credit Services Website. So, whatever your culture, gender identity, religion, ethnicity, age, or disability status, if you are ready to help us make a difference, we think you will fit right in.

We look after the personal information you provide to us, if you would like to know more about how we use your data you can read our ‘Privacy Notice & Cifas Fair Processing Notice for Candidates’ which is available on our website.

Pay: £36,000.00-£43,000.00 per year

Since 1997 Phillips & Cohen Associates (PCA) has led innovation in the probate recovery market, establishing itself as the global leader in this highly specialised area of debt recovery industry. We don’t settle for average - our culture thrives on excellence, integrity, and results. With a reputation for professionalism and empathy, we continue to redefine industry standards and deliver unmatched recovery performance. In 2023, PCA acquired the Liverpool based debt collection business, Ardent Credit Services Ltd, which provides market leading “digital first” financial recovery solutions to UK organisations.