We are seeking a Senior SQL developer to work with our growing, agile Tech team. We are currently on a cultural and tech transformation journey utilizing cloud based elastic solutions and are looking for an all-round SQL developer with DB administration experience. Role: Senior SQL Developer Location: Liverpool City Centre with hybrid working Salary: up to £50,000 depending on experience Working hours: Monday to Friday 9:00am to 5:30pm (37.5 hours per week) - flexibility will be required due to the nature of the role What you will be doing: Involved in agile development practices Supporting the BAU and Development teams Writing SQL CTE queries, procedures, functions, views, triggers Working with complex database schemas with high transaction volumes Migrating to cloud environments Supporting production as well as development systems Paired programming, as required Supporting the Head of Dev and Data Admin in all aspects of Db administration Optimizing enterprise level database systems Implementing data security and redundancy solutions Working with DevOps and Infrastructure engineers What we’re looking for: 5 years’ experience with SQL development Strong Microsoft SQL Server optimal programming techniques Evidence of discipline and diligence Excellent understanding of DRI and database design best practice Experience with transactional and reporting database systems Strong experience in SSIS / SSRS / Power BI Experience with Data Warehouse including development and implement ETL routines according to the Data Warehouse design and architecture Experience of Azure SQL Database / Data factory / Synapse Implementation of database performance optimization techniques Implementation of locking / anti-blocking strategies Experience of replication / log shipping / backup Implementations About Acorn Insurance We are a growing business with great opportunities to build your knowledge of the financial services industry. As a specialist insurance provider, we have 40 years of experience helping people secure motor insurance across all of the UK. We help more than 50,000 customers to find a policy that meets their needs and gives them the peace of mind that comes with high-quality insurance. At Acorn Insurance we provide full training and continuous coaching inhouse you will be given full in-depth FCA regulated industry knowledge and have all the tools necessary to help you personally grow your career with the business. We celebrate difference and it’s important to us that we have a culture where our people feel respected and valued for who they are. We pride ourselves on being accessible and encourage inclusive environments where our people can always give and show the very best of themselves. Why Acorn Insurance? Acorn Insurance want to give you more than a job, we want to give you a purpose and a career. Enhanced Annual Leave entitlement starting at 31 days and potentially increasing to 35 days per year depending on grade & length of service (including bank holidays) Additional Buy & Sell Holidays Company Sick Pay Scheme Company Paid Maternity & Paternity Leave Generous Company Pension Scheme A comprehensive Mental Health support system via the health assured Employee Assistance Programme (EAP) A wide network of mental health first aiders. Our very own reward and discount platform "Your tomorrow" Fresh fruit Deliveries twice a week £250 Refer a friend bonus Cycle to work scheme Free eye test vouchers and a contribution towards the frames Regular Employment Engagement including ongoing competitions with fantastic prizes Charity fundraising events All roles are subject to DBS and Financial checks, any offer made will be conditional until checks are completed to a satisfactory standard. Due to the length of training and complexity of the role, we can only accept applications from candidates who have at least one year remaining on their (Graduate/ Post study work) visa. Unfortunately, we are unable to provide visa sponsorships. At Acorn, we are committed to creating an inclusive and supportive work environment. We recognise that candidates may have specific needs and are happy to consider reasonable adjustments to the recruitment process and working environment to accommodate individual requirements. Whether it’s modifying equipment, adjusting working hours, or providing additional support, we aim to ensure all employees can perform at their best. If you require any reasonable adjustments, please let us know during the application or interview process, and we will work with you to ensure your needs are met. LI-LJ1