Business Intelligence SQL Developer in England
Business Intelligence SQL Developer

Business Intelligence SQL Developer in England

England Full-Time 40000 - 50000 £ / year (est.) Home office (partial)
Kallidus

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 comprehensive health benefits.
  • Other info: Be part of a diverse team that values creativity and collaboration.
  • 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.

The predicted salary is between 40000 - 50000 £ per year.

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.

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
  • 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

Business Intelligence SQL Developer in England employer: Kallidus

Kallidus is an exceptional employer located in the vibrant City of Bristol, offering a hybrid working model that promotes work-life balance. With a strong focus on employee growth, Kallidus provides comprehensive benefits including private medical insurance, generous holiday allowances, and a supportive work culture that values diversity and inclusion. Join us to be part of a collaborative team where your contributions are recognised and rewarded, and where you can thrive in your career as a Business Intelligence SQL Developer.
Kallidus

Contact Detail:

Kallidus Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Business Intelligence SQL Developer in England

✨Tip Number 1

Network like a pro! Reach out to people in the industry, attend meetups, and connect 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 SQL projects, data visualisations, or any BI solutions you've developed. This gives potential employers a taste of what you can do beyond just your CV.

✨Tip Number 3

Prepare for interviews by practising common BI-related questions and scenarios. Think about how you can demonstrate your problem-solving skills and your understanding of data security and integrity.

✨Tip Number 4

Apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you're genuinely interested in joining our team at Kallidus. Don’t miss out!

We think you need these skills to ace Business Intelligence SQL Developer in England

SQL Development
Data Warehouse Design
Dimensional Modelling
ETL Processes
T-SQL
SQL Query Optimization
SSIS Package Development
Data Security
OLAP
Data Mining
BI Technologies (e.g. Microsoft Power BI, SAP Business Objects)
Communication Skills
Problem-Solving Skills
Agile Methodologies
Cloud Platforms (e.g. Azure, AWS)

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. Keep it engaging and personal!

Showcase Your Problem-Solving Skills: In your application, don’t forget to mention specific examples where you've tackled complex data-related issues. We love seeing how you approach challenges and find solutions, so let us know your thought process!

Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way to ensure your application gets into the right hands. Plus, it shows us you’re keen on joining our team at Kallidus!

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 if they ask about your previous projects.

✨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 work under pressure and deliver results.

✨Communicate Effectively

Since you'll be collaborating with both technical and non-technical teams, practice explaining technical concepts in simple terms. During the interview, focus on clear communication and active listening. This will show that you can bridge the gap between different stakeholders and contribute to a collaborative environment.

Business Intelligence SQL Developer in England
Kallidus
Location: England

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

>