Role Overview
A leading financial services provider is seeking a Data Engineer and BI Developer to design, build, and deploy BI solutions with SQL, Azure, and Power BI. You will maintain data platforms and pipelines, improve BI systems, develop queries, troubleshoot issues, and produce technical documentation. The role also contributes to data modelling and programme deliverables within our client's strategic data initiative, enhancing reporting and supporting finance and management information functions in a transformative, data-driven environment.
Responsibilities
* Design, build, and deploy BI solutions using SQL, Azure, and Power BI.
* Maintain and support data analytics platforms and associated pipelines.
* Conduct data modelling and create calculations, measures, and KPIs.
* Develop and execute database queries for in-depth analysis.
* Ensure timely refresh and continuous improvement of Consumer Duty MI dashboards.
* Automate source data integration to enhance reporting efficiency.
* Contribute to the strategic MS Azure solution design and data governance.
What you'll need to succeed
1. Strong experience with MS Azure Cloud Dev/Ops and Data Lake design (dimensional modelling).
2. Proficiency in Databricks open data lakehouse architecture in Azure.
3. In-depth understanding of database managemen...