At a Glance
- Tasks: Design and manage business intelligence solutions while optimising SQL queries.
- Company: Join Kallidus, a dynamic tech company in Bristol focused on innovative learning solutions.
- Benefits: Enjoy hybrid working, 26 days holiday, private medical insurance, and more perks!
- Other info: Kallidus values diversity and offers a supportive, inclusive work environment.
- Why this job: Make an impact by enhancing BI systems that help customers make informed decisions.
- Qualifications: Experience in BI development, SQL, and a degree in Computer Science or related field required.
The predicted salary is between 36000 - 60000 £ per year.
Overview
Business Intelligence SQL Developer at Kallidus – City Of Bristol, England, United Kingdom. Location: Hybrid. Hours: 37.5 per week. Reporting To: Business Intelligence Lead. Department: Technology.
Salary: This range is provided by Kallidus. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.
About the job
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
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
- 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
- Hybrid Working
- Home Office set up assistance
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
#J-18808-Ljbffr
Business Intelligence SQL Developer employer: Kallidus
Kallidus is an exceptional employer that champions a collaborative and inclusive work culture, making it an ideal place for a Senior .NET Backend Engineer to thrive. With a flexible hybrid working model and a strong commitment to employee development, you will have the opportunity to enhance your skills while contributing to an award-winning platform in a supportive environment. Join us in shaping the future of learning and performance management in the UK.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence SQL Developer
✨Get to Grips with Data Visualisation Tools
If you're aiming for a full-time role in business intelligence, brush up on your skills with popular data visualisation tools like Tableau or Power BI. Showcasing projects where you've transformed raw data into clear visual insights can give you a real edge.
✨Join Local Business Intelligence Meetups
Look for local business intelligence meetups or analytics conferences in your area. These events are not just great for learning but also for networking with industry professionals who could lead you to opportunities at companies like Kallidus!
✨Engage with Online BI Communities
Join online forums or communities focused on business intelligence—think LinkedIn groups, Reddit threads, or even dedicated Slack channels. Engage actively by sharing your insights and asking questions; this can help you build visibility and connect with potential employers.
✨Leverage Your University’s Career Support
If you're a recent graduate, definitely tap into your university's career services. Many have connections with companies in need of full-time BI specialists, and they can guide you on how to pitch yourself effectively—don't miss out on that!
We think you need these skills to ace Business Intelligence SQL Developer
Some tips for your application 🫡
Highlight Your Analytical Skills:In the business intelligence field, showcasing your analytical skills is a must. Make sure your CV includes relevant experience with data analysis tools, programming languages like SQL or Python, and any projects where you've interpreted complex data sets to drive business decisions.
Showcase Your Business Acumen:Don't just focus on data; show us how you can apply your insights to real-world business problems. Highlight projects where you made a tangible impact on company performance, and be prepared to explain your thought process in your cover letter.
Tailor Your Documents for Us:When applying for a full-time role at Kallidus, tailor your CV and cover letter to reflect our organisational goals and strategies. Mention specific tools and methodologies that align with what we do—this shows you’ve done your homework and are genuinely interested in our mission!
Include Relevant Certifications:Certifications like Google Data Analytics or similar qualifications can really make you stand out in business intelligence. Include these in your application, as they demonstrate your commitment to the field and your willingness to stay current with industry standards.
How to prepare for a job interview at Kallidus
✨Show off your analytical skills
In a business intelligence role, you're going to need to demonstrate your analytical prowess. Be prepared to discuss specific tools you've used, like SQL, Tableau, or Power BI. Have real-world examples ready where you’ve turned data into actionable insights – this is what makes us shine in interviews!
✨Practice your technical know-how
Expect some technical questions during the interview that dive deep into your understanding of data modelling and analytics frameworks. Brush up on your knowledge of data warehousing concepts and be ready to tackle any real case scenarios they might present. They’ll want to see how you approach problems using your BI toolkit.
✨Portfolio of Projects
Since it's a full-time role, having a strong portfolio is key! Compile case studies demonstrating your previous projects, preferably showing how your insights led to business improvements. This can help us display how you think through complex datasets and your problem-solving process, which is what employers are keen on seeing.
✨Know their business model
Get familiar with Kallidus’s business model and recent data-driven decisions. Be prepared to discuss how your skills can specifically support their objectives or challenges. Understanding their landscape shows that you’re not just a data buff, but you’re also genuinely interested in how BI can impact their bottom line.
