SQL Developer

The SQL Developer is responsible for designing, building, optimising, and supporting database solutions that underpin Kallidus products and internal systems. This role focuses on the development and maintenance of SQL Server environments, ensuring data is accurate, secure, and performant across the applications that depend on it., + Write, optimise, and troubleshoot SQL queries for data manipulation and retrieval

• Develop stored procedures and functions to encapsulate business logic and improve query performance
• Tune SQL queries, create indexes, and implement other performance optimisation techniques
• Debug and resolve issues with T-SQL and related SQL Server components
• Identify and resolve database-related performance and reliability issues
• Manage database backups, restores, and migrations
• Ensure data accuracy, consistency, and security through appropriate validation, backup, and recovery procedures
• Build and maintain ETL processes, including SQL Server SSIS packages
• Provide second-line technical support for data queries
• Collaborate with developers, analysts, and stakeholders to integrate databases with applications
• Apply AI tools to improve productivity, code quality, and documentation, with appropriate critical review of outputs
• Keep up to date with the latest database technologies and best practices

The role requires advanced knowledge of SQL Server and Transact-SQL, a solid understanding of ETL principles and data modelling, and the ability to collaborate effectively with Software Developers, Infrastructure Engineers, and other technical stakeholders. The SQL Developer should be comfortable working in an agile environment and taking ownership of database-related workstreams with a degree of independence., + Experience as a SQL Developer in an agile environment

• Advanced knowledge of T-SQL for data manipulation and query optimisation
• Advanced knowledge of SQL Server, including maintenance and troubleshooting
• Proficiency in designing, developing, and deploying SSIS packages
• Knowledge of ETL/ELT, dimensional modelling, and star schema design
• A strong understanding of data security and multi-tenancy principles
• The ability to analyse and resolve complex data-related issues
• Clear and effective communication skills across technical and non-technical audiences
• An academic qualification in Computer Science, Engineering, or a related field
• An existing right to work in the UK

Desirable

• Knowledge of NoSQL databases
• Knowledge of Microsoft Azure data tools, including Power BI, Fabric, Data Factory, and Data Lake
• Experience with PostgreSQL
• Familiarity with cloud platforms and services such as Azure or AWS
• Exposure to learning, HR, or workforce analytics domains
• Prior experience in a scale-up or SaaS product company

Kallidus is a disability confident employer. We work hard to build an explicitly inclusive space where everybody belongs. Kallidus is a supportive, caring, and enjoyable working environment for all our people, and we are committed to furthering the diversity of our teams. Diversity brings innovation and creativity through different views, backgrounds, and opinions; as a people-first organisation, it's crucial that our teams reflect global diversity. Our people are the heart of our success, and diversity is what drives that. Kallidus positively encourages applications from suitably qualified and eligible candidates regardless of sex, race, disability, age, sexual orientation, gender reassignment, region or belief, marital status, pregnancy or maternity. Proud member of the Disability Confident employer scheme.