We are seeking a talented Senior Business Intelligence Data Specialist
About the Role
This is an exciting opportunity to join our team as a Senior Business Intelligence Data Specialist. As a key member of our Central Business Intelligence Team, you will play a crucial role in delivering high-quality BI reporting and data transformation solutions.
You will be responsible for supporting, improving, and delivering high-quality BI reporting and data transformation solutions using tools such as Azure Data Factory, Microsoft Fabric, Databricks, and Power Bi.
You will actively participate within the central Data & BI Team to help develop other team members and support the delivery of the team objectives.
Your duties will include enhancing existing Data Lakehouse with new Databricks pipelines to ingest new data sources, building out data transformations to support new Facts and Dimensions within existing Data Lakehouse, and conducting data analysis and designing subsequent data extraction and database repository.
Key Responsibilities
* Data & Business Intelligence Team:
o Enhance existing Data Lakehouse with new Databricks pipelines to ingest new data sources.
o Build out data transformations to support new Facts and Dimensions within existing Data Lakehouse.
o Conduct data analysis and design subsequent data extraction and database repository.
* Wider BI Business Support:
o Work directly with the Actuarial, Underwriting, Claims, Finance, and Central MI business representatives to identify and document business requirements.
o Provide technical support and guidance to the business teams to enable them to achieve their own reporting goals.
o Presentation of innovative technical opportunities to the business and wider data delivery team.
Preferred Skills and Experience
We are looking for individuals with experience in the following areas:
* Databricks
* Azure Data Factory
* Data Lakehouse Medallion architecture
* Microsoft Azure
* T-SQL Development (MS SQL Server 2005 onwards)
* Python, PySpark
Experience of the following systems would also be advantageous:
* Azure DevOps
* MDS
* Kimball Dimensional Modelling Methodology
* Power Bi
* Unity Catalogue
* Microsoft Fabric
Qualifications
Applicants should have a degree in a relevant field or long-standing technical experience.
Key Personal Desirables
We are looking for individuals with excellent communication skills, both written and verbal, who can liaise with staff at all levels around issues and opportunities.
Other desirable qualities include being a self-starter, having a proactive and self-motivated attitude, and being able to establish and maintain effective working relationships with colleagues at all levels.