At a Glance
- Tasks: Develop and manage innovative BI systems using Power BI and SQL.
- Company: Join NHFT, a leading healthcare provider focused on community and mental health services.
- Benefits: Gain valuable experience in a supportive environment with opportunities for professional growth.
- Other info: Collaborate with diverse teams and enhance your skills in a dynamic setting.
- Why this job: Make a real difference in healthcare by transforming data into actionable insights.
- Qualifications: Degree or relevant experience in BI, SQL, and Power BI required.
The predicted salary is between 36000 - 60000 £ per year.
Northamptonshire Healthcare NHS Foundation Trust (NHFT) are looking to recruit a BI Developer to work within the Business Intelligence Service, which is responsible for performance improvement and contract management of existing services, and provision of reporting functionality to support operational management of clinical services. The Trust aims to use Power BI to provide interactive visualisations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on information technology staff or database administrators.
Core to this is the function of improving, maintaining and administrating both the Trust's Data Warehouse and the associated Power BI reporting systems, where the position holder will be expected to utilise their advanced level SQL, SSRS & Power BI skills to manage both routine and ad-hoc processes and developments within the current framework. A key part of the role will be to work closely with the Data Warehouse Data Architect to facilitate continued systems development.
Main duties of the job:
- Develop new database and reporting systems to support the delivery of the Trust's BI Systems Power BI Project.
- Manage and understand the full life-cycle of system and report development within a SQL/SSRS/Power BI environment, including all aspects of access control, maintaining data integrity, investigating errors and implementing bug-fixes.
- Manage development activity and administration of the team's SQL data warehouse, used as a central point of collation for the Trust's various system data-streams.
- Provide direct support to members of the BI Service, providing information to support reporting to Operational Managers & Leads.
- Become proficient in understanding how the Trust's Data Warehouse works, and the implications of changes, both from an Operational and Business Intelligence point of view.
- Maintain an expert knowledge of the Trust's PAS system SystmOne, other corporate information systems (such as ESR, Datix, IWGC), and an in-depth understanding of how its data is interpreted within the Trust's Data-Warehouse in relation to reporting and data extraction.
NHFT is an integrated community care and mental health Trust, providing physical, mental health and specialty services in both hospital settings and out in the community. Because we put the person at the centre of all we do, we focus on delivering care that is as easy to access as possible. This means many of our services can be provided at home, work or in schools. We also provide health services to various prisons and detention centres in Bedfordshire and Cambridgeshire.
Person specification:
Qualifications
- Essential criteria: Degree level qualification (or relevant experience), Post graduate diploma or specialist qualification/training to Masters level (or equivalent experience), Evidence of Continued Professional Development.
- Desirable criteria: Project Management qualification e.g. PRINCE2.
Personal Attributes
- Essential Criteria: Enthusiastic, motivated, autonomous as well as being a good team leader, Able to engage with a variety of people, including those within identified Team, and those in external agencies, Able to use own initiative and make decisions independently, Committed to continual quality and service improvement, Self-aware and committed to professional and personal development, Flexible and proactive attitude.
Experience
- Essential criteria: Experience of using Power BI/Power Query/DAX, Extensive experience of SQL BI Stack (SSIS, SSAS, SSRS), Proven experience of working with multiple senior stakeholders to build relationships and communication channels, Experience of managing and understanding the full life-cycle of system and report development within a SQL/Power BI environment, including all aspects of access control, maintaining data integrity, investigating errors and implementing bug-fixes, Experience of developing new database and reporting systems, Ability to capture and translate business requirements effectively to create meaningful dashboards and reports that support decision making across the Trust, Experience of delivering effective training and providing user support to non-technical staff and colleagues.
- Desirable criteria: Knowledge of the Trust's PAS system SystmOne, other corporate information systems (such as ESR, Datix, IQVIA), Experience of working in a health or social care environment.
Knowledge
- Essential Criteria: Understanding of the local NHS structure, strategy, vision and policy, Highly developed, in-depth specialist knowledge, underpinned by theory and professional experience of disciplines including technical development over an extended period.
Business Intelligence in Kettering employer: Midlands and Lancashire Commissioning Support Unit
Northamptonshire Healthcare NHS Foundation Trust (NHFT) is an exceptional employer that prioritises the well-being of its staff while delivering vital community and mental health services. With a strong focus on professional development, employees are encouraged to enhance their skills through continued education and training, fostering a culture of collaboration and innovation. Working in a supportive environment that values flexibility and autonomy, BI Developers will have the opportunity to make a meaningful impact on healthcare delivery while enjoying a balanced work-life dynamic in a community-focused setting.
Contact Details:
Midlands and Lancashire Commissioning Support Unit Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence in Kettering
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend events, and connect with professionals on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Prepare for interviews by practising common questions and showcasing your Power BI skills. We recommend setting up mock interviews with friends or using online platforms to get comfortable with the process.
✨Tip Number 3
Showcase your projects! Create a portfolio of your work with Power BI, SQL, and SSRS. This will give potential employers a tangible sense of your capabilities and how you can contribute to their team.
✨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, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Business Intelligence in Kettering
Some tips for your application 🫡
Tailor Your Application:Make sure to customise your CV and cover letter for the BI Developer role. Highlight your experience with SQL, Power BI, and any relevant projects you've worked on. We want to see how your skills match what we're looking for!
Showcase Your Skills:Don’t just list your skills; demonstrate them! Use specific examples of how you've used Power BI or SQL in past roles. This helps us understand your practical experience and how you can contribute to our team.
Be Clear and Concise:Keep your application straightforward and to the point. Avoid jargon unless it's relevant to the role. We appreciate clarity, so make it easy for us to see why you're a great fit for the position.
Apply Through Our Website:We encourage you to submit your application through our website. It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it’s super easy to do!
How to prepare for a job interview at Midlands and Lancashire Commissioning Support Unit
✨Know Your Tools Inside Out
Make sure you’re well-versed in Power BI, SQL, and SSRS. Brush up on your skills and be ready to discuss specific projects where you've used these tools. Being able to demonstrate your technical expertise will show that you're the right fit for the role.
✨Understand the Trust's Operations
Familiarise yourself with Northamptonshire Healthcare NHS Foundation Trust’s services and how they operate. Knowing their mission and how your role as a BI Developer fits into their goals will help you stand out as a candidate who is genuinely interested in contributing to their success.
✨Prepare for Scenario Questions
Expect questions about how you would handle specific challenges related to data integrity or report development. Think of examples from your past experience where you successfully navigated similar situations, and be ready to explain your thought process.
✨Showcase Your Communication Skills
As you'll be working with various stakeholders, it’s crucial to demonstrate your ability to communicate complex information clearly. Prepare to discuss how you've effectively engaged with non-technical staff in the past and how you can bridge the gap between technical and operational teams.
