Job Summary

As a BI Developer, you will play a key role in designing, developing, and maintaining Business Intelligence solutions that enable data-driven decision-making. Leveraging your expertise in data modelling, ETL processes, and dashboard development, you will transform complex datasets into scalable, reliable, and high-performance BI assets.

The ideal candidate will manage the full data lifecycle—receiving, cleaning, storing, and analysing data—while maintaining our reporting frameworks and providing occasional support for internal application support.

Key Responsibilities

1.      Data Integration & ETL Development (Receive & Clean)

• Design, develop, and maintain ETL/ELT processes to receive, transform, and load data from multiple sources into centralised data repositories.
• Ensure data quality, consistency, and reliability through rigorous cleaning, validation rules, and transformation logic.
• Identify opportunities to streamline reporting processes and improve data delivery mechanisms.

2.      Data Warehouse & Azure Development (Store)

• Design and maintain data warehouses, data marts, and dimensional models (e.g., star and snowflake schemas) to effectively store and organize data.
• Utilize Azure cloud platforms and database systems (SQL Server, MySQL, etc.) to manage high-performance data architecture.
• Implement indexing strategies and query efficiency to ensure optimal database performance.

3.     BI Solution Development & Reporting (Analyse & Present)

• Analyse business requirements to develop, publish, and maintain interactive dashboards and reports using Power BI, Tableau, or similar tools.
• Translate complex business logic into scalable semantic models and reusable BI assets built from received data.
• Work closely with stakeholders to define KPIs, metrics, and reporting standards to support strategic initiatives.

4.     Performance Optimisation & Maintenance

• Monitor and optimise BI systems, data models, and queries to ensure reliability and high availability.
• Troubleshoot and resolve data or reporting issues promptly to maintain operational performance.
• Implement version control and documentation standards for all BI artefacts.

5.     Data Governance & Compliance

• Ensure all BI solutions adhere to data governance frameworks and privacy regulations (essential for healthcare data).
• Maintain detailed metadata, documentation, and data lineage records to ensure transparency and auditability.
• Implement data security and role-based access controls aligned with company policies.

6.     App Support & Process Automation

• Provide occasional support for the maintenance of internal applications as required to support the broader IT team.
• Automate data refresh schedules, validation checks, and performance monitoring to reduce manual intervention.