Designing and engineering elegant and performant BI solutions using existing and emerging Azure technologies, in line with industry best practice
Working closely with the wider Data Engineering Team (including Business Analysts) to ensure changes are implemented in line with business requirements
Supporting the BI Platform / Infrastructure, including undertaking troubleshooting, detailed investigations and fulfilling BAU requests
Ensuring changes are managed effectively, with appropriate task and project planning, communication, testing, training and logging via DevOps
Creating, maintaining and releasing SQL solutions using DevOps / Git
Requirements :
Developing enterprise Data Warehouse/Database solutions using T-SQL (e.g. Azure SQL DB)
Dimensional/Data modelling
Query optimisation
Developing solutions in Azure Data Factory (Synapse Analytics highly desirable)
Developing with Visual Studio 2019 / 2022 and DevOps/Git