Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Transform raw data into actionable insights and develop innovative database solutions.
- Company: Join a professional team dedicated to supporting Finance departments and Local Authorities.
- Benefits: Enjoy a hybrid work model with 3 days in the office and 2 at home.
- Why this job: Be part of a dynamic team focused on innovation and continuous improvement.
- Qualifications: 3+ years of SQL experience, strong communication skills, and proficiency in data visualization tools.
- Other info: Bonus points for familiarity with Python, .Net, Excel, and a passion for learning.
The predicted salary is between 40000 - 66000 £ per year.
Job Description
We are St Andrew's. We are a mental health Charity and our purpose is to inspire hope for those living with complex mental health needs.
We are looking to a future with less stigma, more community support, more research and education, and we aim to be at the forefront of inspiring real change. We want to ensure we can all live in a society where everyone with complex mental health needs is heard, valued and has hope for their future.
Come and join us, and support us to help people transform their lives.
The Role:
The Data and Analytics teams supports the charity to harness the power of data to improve outcomes for patients and operational excellence for our non-clinical colleagues. The role of Business Intelligence Developer involves supporting the existing data platform and delivering new products to meet organisational demands.
Key Responsibilities:
The Business Intelligence Developer will work with the Lead Data Engineer, the Data Product Manager and the rest of the Data, Analytics and Performance team to determine user requirements and deliver quality data products. This involves the modelling of data, the creation of required data framework objects, testing of final products and engagement with users to ensure successful usage of end products.
- Data Engineering: development of ETL processes, maintaining the data platform and creating unit tests for use in automated testing processes.
- Power BI development: build and maintain semantic models and Power BI reports.
- Data Analysis: interrogate data and collaborate with stakeholders to interpret findings, providing actionable insights based on data trends, patterns, and forecasts.
- Support: respond to user issues to offer guidance on reporting solutions and raise, investigate and fix bugs where appropriate.
- Monitor the data platform using all the alert and automated test systems, identifying areas where processes can be optimized.
- Peer review code from team and collaborate on determining best practice for the team, documenting processes where required.
- Personal development: take responsibility for learning new skills and certifications when required.
Your profile:
- Minimum 2 years’ experience in developing data systems.
- Experienced in SQL and DAX.
- Knowledge of Python, PowerShell and YAML.
- Experience in Microsoft data tooling such as: Power BI, Azure Data Factory, Synapse, and Fabric.
- Experience creating data models and clearly communicating the reasoning for the model.
What’s in it for you?
We offer an excellent benefits package including Pension; Sickness policy on par with the NHS; Access to the Blue Light Card and Health Service Discounts schemes; 27 days annual leave (plus bank holidays) Electric Car lease scheme; Cycle to work scheme; Healthcare cash plan; Free parking; Paid DBS application; Access to further qualifications including an Executive MBA Programme and Coaching and Mentoring Qualifications. On-site facilities such as gym and swimming pool access and cafés all set within beautiful grounds.
Interested?
Please apply or contact Samantha Pendry
Please note we are unable to provide a certificate of sponsorship for this role.
#LI-STAH
Business Intelligence Developer employer: St Andrew's Healthcare
Contact Detail:
St Andrew's Healthcare Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business Intelligence Developer
✨Tip Number 1
Make sure to showcase your experience with SQL and data visualization tools like Power BI and SSRS during networking events or informal meetups. Engaging in conversations about your projects can help you stand out.
✨Tip Number 2
Consider joining online forums or local groups focused on Business Intelligence and SQL development. This will not only expand your network but also keep you updated on industry trends and job openings.
✨Tip Number 3
If you have experience with ETL tools like SSIS, be prepared to discuss specific projects where you utilized these skills. Real-world examples can demonstrate your expertise and problem-solving abilities.
✨Tip Number 4
Don’t hesitate to reach out to current employees at the company through LinkedIn. Ask them about their experiences and any tips they might have for the application process. Personal connections can often lead to valuable insights.
We think you need these skills to ace Business Intelligence Developer
Some tips for your application 🫡
Understand the Role: Take the time to thoroughly read the job description for the BI Developer position. Understand the key responsibilities and required skills, such as SQL proficiency and experience with ETL tools like SSIS.
Tailor Your CV: Customize your CV to highlight relevant experience in database solutions, data visualization tools, and any projects that demonstrate your problem-solving skills. Make sure to include specific examples of how you've transformed data into actionable insights.
Craft a Compelling Cover Letter: Write a cover letter that showcases your passion for data-driven initiatives and your ability to communicate complex technical information to non-technical stakeholders. Mention your experience with Power BI and SSRS, and how you can contribute to the company's vision.
Proofread Your Application: Before submitting your application, carefully proofread all documents for spelling and grammatical errors. A polished application reflects your attention to detail, which is crucial for a BI Developer role.
How to prepare for a job interview at St Andrew's Healthcare
✨Showcase Your SQL Skills
Be prepared to discuss your experience with SQL in detail. Highlight specific projects where you utilized SQL to solve problems or improve processes, and be ready to answer technical questions or even perform a live coding exercise.
✨Demonstrate Your Data Visualization Knowledge
Since the role involves using Power BI and SSRS, come prepared with examples of dashboards or reports you've created. Discuss the thought process behind your designs and how they provided actionable insights for stakeholders.
✨Communicate Effectively
Strong communication skills are essential for this position. Practice explaining complex technical concepts in simple terms, as you will need to collaborate with users of varying technical expertise. Think of examples where you successfully communicated your ideas.
✨Prepare for Behavioral Questions
Expect questions about teamwork, problem-solving, and project management. Use the STAR method (Situation, Task, Action, Result) to structure your responses, focusing on how you led system improvement projects or collaborated with others to achieve goals.
