Business Intelligence Developer - EHR Implementation

Location: Swift Square One
Job type: Specified Purpose

Overview of role:

The Business Intelligence (BI) Developer will play a critical role in the design, development, and delivery of reporting and analytics solutions to support a large-scale Electronic Health Record (EHR) implementation programme. The role focuses on transforming complex clinical, operational, and financial data into actionable insights that support decision-making across clinical, operational, and executive stakeholders. The successful candidate will work closely with technical teams, clinical and operational stakeholders to build robust, scalable, and secure reporting solutions aligned with programme objectives and governance standards. In addition to technical development, this role requires business analysis capability, including engaging with clinical, operational, and executive stakeholders to gather, analyse, and translate reporting requirements into actionable dashboard and data solutions. The role offers the opportunity to play a key part in delivering transformativ

Primary Duties and Responsibilities:

Business Analysis & Requirements Gathering

• Engage with clinical, operational, finance, and programme stakeholders to elicit and document reporting requirements
• Facilitate workshops and interviews to understand user needs, workflows, and decision-making requirements
• Translate business and clinical requirements into clear functional specifications and data definitions
• Define KPIs, metrics, and success criteria in collaboration with stakeholders
• Validate requirements through walkthroughs and user sign-off processes

Reporting & Dashboard Development

• Design and develop customised Meditech EXPANSE reports and configure dashboards in Meditech’s Business & Clinical Analytics (BCA) platform
• Design and develop interactive Power BI dashboards and reports supporting EHR workflows and operational performance
• Build dashboards to support programme and organisational decision-making
• Ensure reports are intuitive, user-friendly, and aligned to stakeholder needs

Data Integration & Modelling

• Develop and maintain scalable data models using data from the EHR, integration engines, and other systems
• Apply best practice data modelling techniques (star schema, DAX optimisation)
• Collaborate with integration and data teams to ensure accurate and timely data availability

EHR Programme Support

• Work across multiple EHR workstreams to define and prioritise reporting deliverables
• Support System Integration Testing (SIT), User Acceptance Testing (UAT), and go-live validation activities
• Contribute to the overall reporting and analytics strategy for the programme

Data Governance & Quality

• Ensure adherence to data governance standards, data protection regulations (GDPR), and security protocols
• Define and maintain data dictionaries, metadata, and business rules
• Implement validation and reconciliation processes

Performance Optimisation & Deployment

• Optimise report performance and usability
• Manage Power BI workspace deployment, version control, and release cycles
• Support transition of reporting solutions into BAU operations

Qualifications & Experience:

Essential

• 1+ years’ experience developing Power BI solutions in enterprise environments using tools such as Microsoft Power BI or Microsoft Fabric
• Proven experience performing business analysis / requirements gathering in a data or reporting context
• Strong expertise in Power BI (DAX, Power Query, data modelling)
• Experience translating business requirements into technical solutions
Proficient in building and optimizing complex SQL, TSQL queries and data transformations using Azure Data Factory

• Bachelor’s degree in one of the following or a related discipline:
  Computer Science
  Data Analytics / Data Science
  Information Systems / Information Technology
  Software Engineering
  Mathematics / Statistics

Desirable

• 
  
  Experience in healthcare or EHR implementations (Meditech Expanse highly desirable)
• Familiarity with healthcare workflows and reporting requirements
• Postgraduate qualification (e.g. MSc) in Data Analytics, Health Informatics, or related field
• Proficiency in Microsoft Office suite (Excel, Word, PowerPoint, Visio, MS Project)
• Formal training or certification e.g.
• Microsoft Certified: Power BI Data Analyst Associate (PL-300)
• Microsoft Azure Data certifications (e.g. DP-203)
• Business Analysis certifications (e.g. CBAP, CCBA, BCS BA)

This job description is intended to be an outline of the areas of responsibility. As UPMC and the post holder develop, this job description may be subject to review in light of the changing needs of the business.

Equal Opportunity Statement and Benefits

UPMC is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

At UPMC we provide a total rewards program that is not only market competitive, but fair and provides growth opportunities for all our colleagues.

Benefits – Fully paid maternity and paternity leave for new parents. Competitive Pension Plan, company funded Death in Service Benefit x 3 times. Critical Illness cover for all employees up to the age of 66.

Performance and Recognition – Rewards for performance that supports the goals and mission of UPMC through our annual ACES programme.

Work-Life Balance – Enhanced annual leave up to a maximum of 27 days. Flexible working opportunities to support you to work around external family commitments.

Development and Career Opportunities – Opportunities for each employee to reach their career goals through continued learning and/or advancement.

About UPMC

UPMC is a renowned multinational academic medical centre committed to delivering people-focused care that’s close to home. Headquartered in Pittsburgh and affiliated with the University of Pittsburgh Schools of the Health Sciences, UPMC shapes the future of health through clinical and technological innovation, research and education. UPMC expands its expertise globally, bringing world-class care across continents through its UPMC International division — an owned and operated network of hospitals and ambulatory care centres in Italy, Ireland and Croatia. UPMC International brings new access to the signature specialty services of UPMC Hillman Cancer Centre, UPMC Sports Medicine and others to more people in more places around the world.

In Ireland UPMC has provided high-quality healthcare in the South East since 2006. UPMC’s operations in Ireland now include UPMC Whitfield Hospital in Waterford, UPMC Sports Surgery Clinic in Dublin, UPMC Kildare Hospital in Clane, and UPMC Aut Even Hospital in Kilkenny. Outpatient care is available at the UPMC Carlow Outreach Centre, UPMC Hillman Cancer Centre radiotherapy locations in Waterford and Cork, UPMC The 4th Practice in Mallow, and across UPMC Sports Medicine Clinics in Dublin, Waterford, Limerick, Tipperary, Cork, and Mayo. UPMC has also established a nationwide Concussion Network. UPMC's Global Technology Operation Centre is based in Kilkenny.