Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and develop innovative business intelligence solutions using SQL.
- Company: Join Kallidus, a forward-thinking tech company in Bristol.
- Benefits: Enjoy hybrid working, competitive salary, and great health benefits.
- Why this job: Make a real impact by enhancing data-driven decision-making for our customers.
- Qualifications: Experience in SQL development and a passion for data analytics.
- Other info: Be part of a diverse team that values creativity and collaboration.
The predicted salary is between 40000 - 50000 £ per year.
As a Business Intelligence SQL 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:
- 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
- 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; questions what’s gone before, thinks laterally, shares new ideas outside the norm, adapts to situations with creativity; questions inefficiencies, understands business context, challenges gaps & our methodologies, thinks beyond their role, asks 'what if'?
What’s in it for you:
- Life Insurance
- 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
How we collaborate:
- Employee Success Awards
- Employee Service Awards
- Team of the Quarter
- Volunteering Committee
Diversity and Inclusion:
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.
Seniority level: Associate
Employment type: Full-time
Job function: Information Technology
Industries: Software Development
Business Intelligence SQL Developer in West Bromwich employer: Kallidus
Contact Detail:
Kallidus Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business Intelligence SQL Developer in West Bromwich
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, attend meetups, and connect with current employees at Kallidus. A friendly chat can sometimes lead to opportunities that aren’t even advertised!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL projects or any BI solutions you've developed. This gives you a chance to demonstrate your expertise beyond just words on a CV.
✨Tip Number 3
Prepare for the interview by brushing up on your T-SQL knowledge and understanding of data warehousing concepts. Be ready to discuss how you’ve tackled complex data issues in the past.
✨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, it shows you’re genuinely interested in joining the Kallidus team.
We think you need these skills to ace Business Intelligence SQL Developer in West Bromwich
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Business Intelligence SQL Developer role. Highlight your experience with SQL, data warehousing, and any relevant BI technologies. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about this role and how your background in data analysis and BI solutions makes you a perfect fit. Let us know what excites you about working at Kallidus!
Showcase Your Projects: If you've worked on any relevant projects, make sure to mention them! Whether it's a data warehouse design or an ETL process you've implemented, we love seeing real examples of your work that demonstrate your skills.
Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and you'll be able to keep track of your application status. Plus, we love seeing candidates who take the initiative!
How to prepare for a job interview at Kallidus
✨Know Your SQL Inside Out
Make sure you brush up on your T-SQL skills before the interview. Be prepared to discuss your experience with writing, optimising, and troubleshooting SQL queries. You might even be asked to solve a problem on the spot, so practice common SQL scenarios to show off your expertise.
✨Understand BI Concepts
Familiarise yourself with key business intelligence concepts like data warehousing, dimensional modelling, and ETL processes. Being able to explain these concepts clearly will demonstrate your knowledge and help you connect with the interviewers, especially since they’re looking for someone who can enhance their BI systems.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've tackled complex data-related issues in the past. Use the STAR method (Situation, Task, Action, Result) to structure your answers. This will not only highlight your analytical skills but also your ability to communicate effectively with both technical and non-technical audiences.
✨Be Ready to Discuss Collaboration
Since the role involves working closely with developers, analysts, and stakeholders, think of instances where you've successfully collaborated on projects. Highlight your communication style and how you adapt to different audiences, as this will show that you can fit into their team dynamic.