At a Glance
- Tasks: Design and optimise high-performance database systems for our SaaS platform and client solutions.
- Company: Join a dynamic IT team at a leading firm in Manchester.
- Benefits: Enjoy hybrid work, competitive salary, and opportunities for professional growth.
- Other info: Collaborative culture focused on continuous improvement and innovation.
- Why this job: Make a real impact by solving complex challenges and mentoring junior engineers.
- Qualifications: Experience with Azure SQL, T-SQL, and strong data modelling skills required.
The predicted salary is between 50000 - 60000 £ per year.
Client Solutions Database Engineer to join our IT team, based in Manchester. The successful candidate will work as part of the Client Solutions sub‑team, collaborating closely with wider IT and Business Services teams to design, optimise and maintain high‑performance database systems that support our core SaaS platform, reporting environments and client billing solutions. This is a hybrid role combining architectural leadership with hands‑on engineering. You will act as the technical authority for our database ecosystem—setting standards, driving best practice, and solving complex challenges—while also writing advanced SQL, building prototypes and guiding junior engineers.
Team Kennedys' IT team is responsible for delivering a responsive, effective and timely IT service to the firm's employees and clients. The team designs and implements operational processes to ensure our systems remain reliable, secure and highly available. You will join a collaborative group committed to continuous improvement and supporting the firm's global technology needs.
Key Responsibilities- Lead the design and optimisation of scalable, high‑performance database architectures across our SaaS platform, reporting environments and client billing systems.
- Govern and enhance the stored procedure estate, reusable scripts and development standards across the engineering team.
- Produce clear, accessible documentation for data models, data dictionaries and architectural decisions.
- Drive technical projects with strong momentum, providing proactive updates and ensuring timely delivery.
- Mentor and upskill junior team members, fostering a collaborative, learning‑focused engineering culture.
- Extensive experience with modern Azure SQL services and designing complex, high‑performance relational databases.
- Strong data modelling skills across both OLTP (SaaS) and OLAP (reporting/analytics) environments.
- Proven expertise in performance tuning, scaling, security and cost optimisation.
- Hands‑on experience with backups, integrity checks, index maintenance and troubleshooting using blocking, caching and wait statistics.
- Advanced proficiency in T‑SQL, stored procedures, functions and custom integrations.
- Experience designing and orchestrating ETL/ELT pipelines using tools such as dbt or Azure Data Factory.
- Strong background in technical code reviews and mentoring junior engineers.
- Excellent communication skills, with the ability to work autonomously and document technical decisions clearly.
- Experience designing Power BI‑optimised data models and writing performant DAX.
- Strong understanding of how database architecture impacts BI performance and reporting pipelines.
Note: Where a level of experience is indicated, this is a guideline and does not preclude applications from candidates with more or less experience.
Client Solutions Database Engineer in Manchester employer: Kennedys
Kennedys is an excellent employer, offering a dynamic work culture that values collaboration and professional growth. With a hybrid working policy, employees enjoy the flexibility of remote work while being part of a supportive team in Belfast, where opportunities for career advancement and skill development are abundant. The firm prioritises employee well-being and fosters an environment where proactive individuals can thrive in their legal careers.
StudySmarter Expert Advice🤫
We think this is how you could land Client Solutions Database Engineer in Manchester
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, attend meetups, and connect with people on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your database projects, SQL scripts, or any prototypes you've built. This gives potential employers a taste of what you can do beyond just a CV.
✨Tip Number 3
Prepare for interviews by brushing up on common technical questions related to Azure SQL services and performance tuning. Practice explaining your thought process clearly, as communication is key in collaborative roles.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Client Solutions Database Engineer in Manchester
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experiences mentioned in the job description. Highlight your expertise in Azure SQL services and database architecture to show us you're the right fit for the role.
Craft a Compelling Cover Letter:Use your cover letter to tell us why you're passionate about database engineering and how your experience aligns with our needs. Be sure to mention any relevant projects or achievements that demonstrate your capabilities.
Showcase Your Technical Skills:When detailing your experience, focus on your proficiency in T-SQL, performance tuning, and ETL/ELT pipelines. We want to see how you've tackled complex challenges in past roles, so don't hold back!
Apply Through Our Website:We encourage you to submit your application through our website. It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Kennedys
✨Know Your Databases Inside Out
Make sure you brush up on your knowledge of Azure SQL services and relational databases. Be ready to discuss your experience with performance tuning, scaling, and security. Prepare examples of how you've optimised database architectures in the past.
✨Show Off Your SQL Skills
Since advanced SQL is a key part of this role, practice writing complex queries and stored procedures. You might be asked to solve a problem on the spot, so being comfortable with T-SQL will give you an edge. Consider bringing along a portfolio of your work if possible!
✨Communicate Clearly
This role requires excellent communication skills, so practice explaining technical concepts in simple terms. Be prepared to discuss how you document architectural decisions and data models. Clear communication can set you apart from other candidates.
✨Be Ready to Mentor
As a potential mentor for junior engineers, think about your approach to teaching and guiding others. Prepare to share examples of how you've supported team members in the past and how you foster a collaborative environment. This shows you're not just a tech whiz but also a team player.
