Senior BI Developer

Job summary

The post holder will play a key role in developing, maintaining and evolving the Trust's data warehouse and corporate business intelligence and reporting software to support the provision of a centralised information source, team/location performance and business intelligence.

The role will require ensuring the team's core functions are to develop, maintain and enhance the Trust's business intelligence capabilities, support controlled standards and provide robust reporting service and access of central submissions and information on which the organisation operates.

The post-holder will be responsible for maintaining and monitoring the data warehouse ensuring high availability for end users and analysts and continued development.

The post holder will liaise with third party suppliers and staff across all levels of the Trust in the planning, design, and development of highly complex software solutions and preparation of complex reporting requirements systems. This will require ability to analyse, interpret and resolve highly complex problems, covering a wide range of clinical and business areas including at a national level

Main duties of the job

Provide expert advice, guidance, techniques and technical solutions to enhance the Trusts Business Intelligence solutions.

Maintain technical, professional and specialist knowledge and understanding -and be competent in the use of a wide range of specialist software packages and programming languages including but not limited to Microsoft SQL Server, T-SQL, SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services, Microsoft Power BI, Microsoft SharePoint, Performance Point, Excel and Power Pivot

Contribute to the design, development and improvement of Business Intelligence solutions and manipulation of relevant data sources.

To manage specifications and to coordinate with the Information and Applications Teams in the development of statutory returns, standard and bespoke reports utilizing data warehouse and data feeds.To ensure all required data is available in the Trust data warehouse and to manage the specification and coordinate the development if not.Be responsible for active maintenance of the data warehouse ensuring integrity, consistency and relevant documentation. Ensuring smooth operation of ETL processes and high availability of Business Intelligence infrastructure.

Participate in the development and strategy for data migration when changing providers or decommissioning legacy systems ensuring continuity of service. Lead in development of data warehousing capability and ensure effectiveness of its establishment/ creation.

About us

At Dorset HealthCare we're on a mission to empower people to make the most of their lives through our outstanding, joined-up healthcare services. We're a dynamic, forward-looking Trust, running 12 community hospitals, specialist inpatient facilities and a wide range of integrated community and mental health services for a population of almost 800,000 people.

We do things differently here - it's one of the reasons the CQC rated us 'outstanding' in 2019. It's also why 95% of patients across our services say they have a good or very good experience of our services and 89% of staff feel they can really make a difference. Whether you're looking to work with us in one of our bustling market towns, vibrant urban locations, thriving seaside spots, or among the rolling hills of Dorset, there are lots of ways you can make a difference in our communities.

Our 7,000-strong workforce is at the heart of what we do and our success is a testament to our brilliant people. We're all about building a workplace for the future, we believe in equal opportunities and we celebrate diversity. We're an inclusive workplace, where everyone is welcome, everyone can be authentic, and we are all encouraged to be the best version of ourselves.

Working with us you'll be part of a strong team, challenge yourself, build a career, and teach us what we don't know. And you'll be working towards our vision to be better every day through excellence, compassion and expertise in all we do.