Data Solutions Support Architect

Job summary

This is a hands-on technical role bridging Electronic Patient Record projects and Business Intelligence functions. Reporting to the Data Solutions Architect, focused on development of BI functions within core EPR systems, architecture and the data flows to the Trust's Warehousing solutions including data flow requirements and mandatory reporting from those systems.

Will be directly responsible for understanding, designing, creating, maintaining, monitoring and documenting data flows from our core Electronic Patient Record systems and associated modules.

Gathering requirements, designing data transfers and extracts for reporting, commissioning and NHS datasets such as SUS, HES, CSDS and ISN's.

Experienced in Microsoft applications such as SQL, SSRS, SSIS, Excel and Power BI.

Supporting with system preparation, testing and implementation of the BI elements of Patient Administration System modules, ensuring that data quality and reporting standards are maintained.

Working on projects and BAU, to embed new functionality within the core BI/data analytics team.

Previous experience of NHS PAS/BI systems is essential, preferably System C Careflow, NHS Income, commissioning and performance is required.

Ability to design test plans, including UAT and reporting.

The role focuses on architecture, integration, and the design/management of data flows, ensuring compliance with reporting requirements.

Flexible working may be required for support during testing phases and go live periods.

Main duties of the job

• Design, develop, maintain and monitor data flows from core Electronic Patient Record (EPR) systems and associated modules, ensuring accurate upstream and downstream integration.
• Translate business and reporting requirements into robust data extracts and transfers to support reporting, commissioning, and national datasets including SUS, HES, CSDS and ISNs.
• Support the Lead Data Solutions Architect in system preparation, testing, and implementation of BI components within new Patient Administration System (PAS) modules.
• Design and execute test plans, including User Acceptance Testing (UAT), ensuring data integrity, quality and reporting standards are maintained and enhanced.
• Work collaboratively across project and operational teams to embed new BI functionality into core analytics and data teams.
• Contribute to dataset development for internal use and wider cross-organisational initiatives.

About us

Why colleagues think we are "a great place to work!"

What does Buckinghamshire Healthcare NHS Trust offer you?

As part of our BHT family, you'll benefit from learning and development opportunities to support your career progression.

Alongside NHS benefits of generous annual leave entitlement and pension scheme, you'll have access to NHS discount schemes.

We provide a range of health and wellbeing services to promote a healthy, happy workforce.

What do we stand for?

Our vision is to provide outstanding care, support healthy communities and be a great place to work.

Our mission is to provide personal and compassionate care every time.

We are working hard to increase diversity at all levels within the trust. We believe a diverse workforce can have a positive effect on both staff wellbeing and patient outcomes.

We welcome applications from black, Asian and minority ethnic candidates, LGBTQ+ candidates, candidates with disabilities and care-experienced candidates.

We are proud to achieve the Gold award for the Armed Forces Covenant and support applications from the Armed Forces Community. Please contact Pam.Daley@nhs.net (our Armed Forces Covenant Lead) if you would like guidance or assistance with your application.

We make employment decisions by matching our service needs with the skills and experience of candidates, regardless of age, disability, gender, gender identity, marriage and civil partnership, pregnancy and maternity, race, religion or belief, or sexual orientation.