BI Developer
Job Type | Perm |
Area | City of London, England |
Sector | Public Sector / Public Services |
Salary | GBP 55,000 - 60,000 Annual Salary |
Start Date | ASAP |
Advertiser | Subeg Lehl |
Job Ref | 25142 |
Job Views | 366 |
- Description
LONDON - £55,000 - PERMANENT BI DEVELOPER KEY RESPONSIBILITIES:- Develop elegant and performant ETL processes using Azure technologies, in line with industry best practice (e.g. Azure SQL Database, Data Factory and others)- Work closely with the wider Data Engineering Team (including Business Analysts) to ensure changes are implemented in line with business requirements- Ensure changes are managed effectively, with appropriate task and project planning, communication, testing, training and logging via DevOps- Create, maintain and release SQL solutions using DevOps / Git - Understand, adapt and utilise the dimensional model and technologies which underpin our business intelligence deliveries.Platform/Database Administration:- Support & maintain the BI Platform / Infrastructure, including managing security, Database Administration, undertaking troubleshooting/detailed investigations and fulfilling BAU requests- Identify and resolve performance issues (e.g. query tuning, optimise code)- Raise Incidents/Requests & collaborate closely with Microsoft & Clarion IT - Lead on BI testing for IT Releases/Upgrades- Undertake software installations & upgrades (E.g. Powershell modules, on-prem SQL)EXPERIENCE: Essential:- Demonstrable experience of developing Data Warehouse and/or Database solutions using SQL Server (ideally, Azure SQL Database)- Development using Azure Data Factory and/or SSIS- Understanding of Dimensional/Data Modelling (e.g. Kimball)- Development with Visual Studio 2019 and DevOps/Git- Experience of query optimisation/performance tuning (e.g. able to analyse Query Store/Plans, indexes)- Knowledge of database security (e.g. on SQL Server)- Comprehensive knowledge of business intelligence, including best practices, processes, principles and technologies- Understanding of data security (e.g. data masking) and GDPR- Experience of undertaking Testing/QA (and peer reviews) Desirable:- Experience of working with Cloud resources (PaaS, IaaS) - Experience of developing enterprise-wide, large scale ETL solutions - Experience in a DBA or support role & working with third parties- Development with PowerShell / Azure Runbooks - Development with SSAS/Azure Tabular Models- Development with SSRS- Development with Power BI - Experience of extracting data from REST APIs- Recognised Azure qualifications- DAX- Synapse Analytics, including SparkPERSON SPECIFICATION: - Excellent communication skills- Ability to work in a pressurised, environment & deliver to deadlines- Adaptable and flexible attitude - Strong analytical & problem solving skills with the ability to analyse and interpret complex scenarios- Willingness and enthusiasm to learn and utilise new technologies- Exceptional attention to detail and accuracy- Ability to learn quickly- Ability to work independently and also in close collaboration with peers- Willingness to share knowledge and assist others within a highly collaborative team - Occasional out of hours work (to support Deployments, IT Releases)- Willingness to start work at 8am in order to monitor the nightly Data Warehouse refresh- Occasional travel as required