Job Title: Business Intelligence Developer
Location: Homebased
Salary: £45,000 to £50,000 per annum + benefits
Contract Type: Permanent
Hours: Full time – Monday to Friday

Right to live and work in the UK is required for this role

Role Summary

We are looking for a passionate and skilled Business Intelligence Developer to join our team. You will be responsible for the design, development and maintenance of robust BI solutions using SQL server, Power BI, Power Platform, Microsoft Fabric and Azure

Main duties and responsibilities

• Collaborate with cross-functional teams to gather requirements and deliver actionable insights.
• Create and optimize complex SQL queries, stored procedures, and data models.
• Develop interactive and visually appealing dashboards and reports in Power BI.
• Implement and manage data integration processes using Azure Data Factory and other ETL tools.
• Ensure data accuracy, integrity, and security across all BI solutions.
• Stay updated with the latest trends and best practices in Business Intelligence and data analytics.

Who Are We Looking For?

• Proven experience as a Business Intelligence Developer or similar role.
• Strong proficiency in SQL Server, including T-SQL, SSIS, SSRS.
• Expertise in Power BI, including DAX and Power Query.
• Experience with Power Platform (Power Apps, Power Automate).
• Familiarity with Microsoft Fabric and its components.
• Hands-on experience with Azure services such as Azure SQL Database, Azure Data Factory, and Azure Synapse Analytics.
• Solid experience of using the Microsoft development stack including Azure DevOps CI/CD pipelines, Visual Studio.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.
• A passion for continuous learning and staying current with industry advancements.

What Can We Offer You?

• 25 Days Annual Leave + Bank Holidays
• Buy and Sell Holiday Scheme
• Life Assurance
• Pension Scheme
• Health Cash Plan
• Volunteer Days
• YuLife Employee Benefits Platform
• Save As You Earn Scheme
• Eye Test Vouchers
• Flu Vaccination Scheme
• Cycle to work scheme
• Clinical Training Academy
• Paid CPD Days
• Professional Registration Fees Paid
• RAVE Awards
• Employee Assistance Programme
• Right to Request Flexible Working From Day 1

About Us:

Optima Health is the UK's largest provider of Occupational Health and wellbeing services, supporting organisations across both the public and private sectors. With a heritage dating back to 1947, we have been helping employers create healthier, high-performing workplaces for generations, and we continue to evolve with innovative, practical solutions that make a real difference.

At the heart of our story are our people. We bring together like-minded professionals who are passionate about improving workplace health and wellbeing and delivering meaningful support to the organisations we work with across the UK.

When you join Optima Health, you become part of something bigger. We invest in our people/you through structured induction, ongoing training and tailored career development, helping you build the skills and experience to grow your career.

Together, we live our values:

One Team – There are no barriers in our business. We trust each other and work together as one team to deliver what our clients need. We all have a part to play in our future, and everyone's contribution is important and valued.

Doing the Right Thing – We operate to the highest standards. Success is underpinned by honesty and integrity, and by doing what we say we will do. We care about the impact of our work on our people, our clients, their employees, society, and the world we live in. Caring for our colleagues' wellbeing and respecting their time, energy and balance is fundamental to this value.

Shaping Tomorrow – We are always looking for ways to improve and innovate. We train, support and empower future leaders, invest in market-leading propositions and use technology to advance service and clinical outcomes. We evolve how we work - embracing smater, more flexible approaches that help our people thrive both professionally and personally.

Never Too Big to Care – We always retain a client-first approach. Every client, and every one of their employees that we support, matters. We work in partnership to optimise workplace health and wellbeing, sharing in the benefits of growing together.