BI Engineer

• Undertake any other work appropriate to the level and general nature of the post.
• Maintain professional knowledge and remain aware of developments in Business Intelligence, data engineering, cloud technology and NHS information requirements.
• Participate in relevant training and continuing professional development.
• Work flexibly where necessary to support business-critical reporting or data processes.

• Develop, maintain and support SQL databases, data models, queries, stored procedures and reporting datasets.
• Develop and maintain Power BI reports, dashboards and semantic models supporting operational, contractual, financial, clinical and governance requirements.
• Produce regular and ad-hoc analysis to support senior management, service leads and commissioners, identifying trends, performance issues and opportunities for service improvement.
• Develop and maintain automated ETL and data-processing pipelines, including ingestion, transformation, validation and loading of information from clinical and operational systems.
• Use Python, SQL and other appropriate technologies to automate repetitive data-processing and reporting activities.
• Monitor scheduled data processes, reporting systems and interfaces, investigating and resolving failures or data-quality issues.
• Design appropriate validation, reconciliation, logging and alerting processes to improve the reliability and traceability of data pipelines.
• Support the development and administration of the organisation's cloud-based data infrastructure, including Azure SQL and associated Microsoft Azure services.
• Apply appropriate software development practices including source control, documentation, testing, code review and controlled deployment.
• Work with internal and external stakeholders to understand information requirements and translate these into practical technical and reporting solutions.
• Support statutory, contractual and commissioner reporting requirements and provide cover for established BI processes where required.
• Support clinical governance and audit activity by providing accurate datasets, reports and data-quality assurance.
• Identify data-quality problems within source systems and reporting processes and work with relevant teams to develop appropriate solutions.
• Maintain clear technical documentation covering data sources, transformations, reporting processes, system dependencies and recovery procedures.
• Work collaboratively with the BI Lead on the design and development of the organisation's longer-term data architecture, reporting capability and Business Intelligence strategy.
• Support business continuity by developing sufficient knowledge of core BI systems and processes to maintain essential reporting and data services during periods of absence.
• Contribute to Information Governance and data-security processes, ensuring that systems and data are handled in accordance with GDPR, confidentiality requirements and organisational policies.

• Support the coordination and annual submission of the Data Security and Protection Toolkit, maintaining the evidence library, tracking assertion evidence and progressing outstanding actions.
• Maintain the organisation's Information Governance policy suite, including scheduled review, version control and renewal of data protection, data quality, records management and acceptable-use policies, escalating gaps to the appropriate lead.
• Maintain the Information Asset Register and Record of Processing Activities, ensuring new systems, datasets and reporting products are captured and information asset owners identified.

Essential

• Significant practical experience working in Business Intelligence, data analytics, data engineering or a closely related role.
• Strong SQL skills and experience developing and maintaining relational databases, queries and data transformations.
• Experience developing dashboards and analytical reporting using Power BI or a comparable Business Intelligence platform.
• Experience designing, developing and maintaining ETL or automated data-processing workflows.
• Experience using Python or another programming/scripting language for data processing, automation or integration.
• Strong understanding of data modelling, data quality, validation and reconciliation.
• Ability to investigate complex data or system issues and independently identify practical solutions.
• Experience producing accurate management information and translating data into clear findings for non-technical stakeholders.
• Ability to document technical systems and processes clearly enough to enable support and maintenance by other team members.
• Understanding of data protection, confidentiality and secure handling of sensitive information.
• Experience of working on Information Governance elements as outlined in the JD.

Desirable

• Experience working with Microsoft Azure, particularly Azure SQL and related data services.
• Experience with Git, source control, automated testing, CI/CD or other modern software-development practices.
• Experience developing or consuming APIs, SFTP interfaces or other system integrations.
• Experience implementing monitoring, logging and automated alerting for production data processes.
• Experience working with NHS or healthcare information.
• Understanding of NHS datasets, clinical systems, commissioner reporting or healthcare performance monitoring.
• Knowledge of Information Governance requirements including GDPR, DSP Toolkit and Caldicott principles.

Essential

• Degree-level education in Data Science, Computer Science, Information Systems, Mathematics, Statistics or a related discipline, or equivalent relevant professional experience.
• Evidence of continued professional development within Business Intelligence, analytics, data engineering or software development.

Desirable

• Relevant Microsoft, Azure, Power BI, SQL or data-engineering certification.
• BCS, PRINCE2, Agile, ITIL or similar professional/project/service-management qualification.

Essential

• Able to work independently and take ownership of technical systems, reporting processes and deliverables.
• Strong analytical and problem-solving ability.
• Able to manage competing priorities and deliver work to agreed deadlines.
• Methodical approach with strong attention to data accuracy and quality.
• Comfortable working collaboratively within a small team where responsibilities overlap and knowledge sharing is essential.
• Willingness to learn unfamiliar systems, datasets and healthcare processes.
• Able to maintain confidentiality and exercise appropriate judgement when handling sensitive information.

Essential

• Ability to communicate technical and analytical information clearly to both technical and non-technical audiences.
• Strong written communication and report-writing skills.
• Ability to work effectively with senior managers, clinicians, operational teams, commissioners and external suppliers.
• Ability to understand stakeholder requirements and translate them into appropriate technical solutions.