Business Intelligence SQL Developer

Reporting To: Business Intelligence Lead

Department: Technology

Salary: £50,000

Location: Hybrid

Hours: 37.5 hours per week

Why Join Kallidus

People are at the heart of everything we do and the key to our success, so it’s important that we recruit individuals who share and represent our values. Curiosity, integrity, collaboration – these are the values we live by. You need to ask questions and to find out why. You need to be true to your word. And you need to be proud to be part of something bigger, working with others will come naturally to you. At Kallidus, we champion our people’s success.

Kallidus helps our customers nurture a culture of self-led learning and ensures compliance with a user-friendly learning platform that makes learning simple and effective, whilst also driving performance with continuous feedback, goal tracking and flexible reviews.

Can you see yourself helping us take our growth to the next level? We invite you to come and discover for yourself the exciting future ahead of you.

About the Job

As a Business Intelligence Developer at Kallidus, you will be responsible for designing, developing and managing business intelligence and analytics solutions for our products. You will build and maintain a data warehouse design to generate reports from our learning and performance management products.

In this role, you should have a background in data and business analysis, along with analytical and communication skills. You should understand key data concepts such as data security and data integrity, and have experience with dimensional modelling, star schema design and ETL processes.

Ultimately, you will enhance our business intelligence systems to help our customers make better decisions.

Key Responsibilities and Accountabilities

• Design, build and deploy new and existing BI solutions
• Maintain and support data analytics platforms
• Writing, optimizing and troubleshooting SQL queries for data manipulation and retrieval
• Developing stored procedures and functions to encapsulate business logic and improve performance
• Ensuring data accuracy, consistency and security through appropriate validation, backup and recovery procedures
• Tuning SQL queries, creating indexes and implementing other performance optimization techniques
• Debugging and resolving issues with T-SQL and related SQL Server components
• Create tools to store data (e.g. OLAP cubes)
• Identifying and resolving database-related issues
• Collaborate with developers, analysts and stakeholders to integrate databases and systems
• Support the creation of visualizations and reports for requested projects
• Develop and update technical documentation
• Keeping up to date with the latest database technologies and best practices

Key Skills and Knowledge

The following skills and experience are essential:

• Experience as a BI Developer, Data Engineer or SQL Developer in an Agile environment
• Background in data warehouse design (e.g. dimensional modeling) and data mining
• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
• Familiarity with BI technologies (e.g. Microsoft Power BI, SAP Business Objects)
• Advanced knowledge of T-SQL for data manipulation and query optimization
• Proficiency in designing, developing and deploying SSIS packages
• Have a strong understanding of data security and multi-tenancy
• A problem-solving attitude with the ability to analyse and resolve complex data-related issues
• Clear and effective communication skills to interact with technical and non-technical audiences
• An academic qualification in Computer Science, Engineering, or a related field
• Must have an existing right of eligibility to work in the UK

Any of the following would be beneficial for this role:

• Knowledge of SQL Server with the ability to maintain and troubleshoot
• Knowledge of NoSQL databases
• Knowledge of Microsoft Azure data tools: Fabric, Data Factory, Data Lake
• Experience with PostgresSQL
• Familiarity with cloud platforms and services (Azure, AWS)

Behaviours Relevant to this role

Inclusive

Considerate, consistent, fair, self-aware, tolerant, builds trust, celebrates others, speaks up when something isn't right

Delivery focused

Gains clarity on what's required, manages time, prioritises workload, acts at speed, high productivity, delivers on commitments & expectations

Influential

Influences sideways and upwards, adapts tone to suit audience, builds & expands network, assertive, growing in confidence, pushes back

Collaborative

Leads by example, acts as a role model for wider team, welcoming, gives space and time, actively supports, relatable

Resilient

Welcoming & supportive of change, knows limits & when to escalate, willing to be challenged, positivity

Solution Driven

Makes smart choices, takes measured risks, works independently, pragmatic, takes ownership, sees the right direction

Ambitious

Thirst for wider knowledge, expert focused, continuously learning, identifies patterns, cascades knowledge, builds their own story

Innovative

Questions what's gone before, thinks laterally, shares new ideas outside the norm, adapts to situations with creativity

Entrepreneurial

Questions inefficiencies, understands business context, challenges gaps & our methodologies, thinks beyond their role, asks "what if"?

What’s in it for you

• Life Insurance
• Workplace Pension Scheme
• Private Medical Insurance
• Dental, Optical and Audio Cover
• 26 days holiday increasing to 28 with service
• Birthday holiday
• Holiday Trading
• Benefits Portal
• Cycle to work scheme
• Employee Assistance Programme
• Family Friendly benefits
• Hybrid Working
• Home Office set up assistance

How we collaborate:

• Fun Team Days
• Employee Success Awards
• Employee Service Awards
• Team of the Quarter
• Equal Voices Committee
• Wellbeing Committee
• Volunteering Committee

Equal Opportunities

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.

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.

Kallidus is a proud member of the Disability Confident Employer scheme. 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.