We are looking for a strong all-round Senior BI Developer to join our exciting BI team. This is a unique opportunity to be involved in delivering leading-edge business analytics using the latest and greatest cutting-edge BI tools, such as cloud-based databases, self-service analytics and leading visualization tools enabling the company's aim to become a fully digital organization.
Key Accountabilities :
Development and creation of high-quality analysis and reporting solutions
Development of ETL routines using SSIS and ADF into Azure SQL Datawarehouse
Integration of global applications such as D365,Salesforce and Workday into cloud data warehouse.
Experience using D365 ERP systems and creating BI reports.
Development of SQL procedures and SQL views to support data load as well as data visualisation
Development of data mapping tables and routines to join data from multiple different data sources
Performance tuning SQL queries to speed up data loading time and query execution.
Liaising with business stakeholders, gathering requirements and delivering appropriate technical solutions to meet the business needs.
Professional Skills :
Strong communications skills and ability to turn business requirements into technical solutions
Experience in developing data lakes and data warehouses using Microsoft Azure
Demonstrable experience designing high-quality dashboards using Tableau and Power BI
Strong database design skills, including an understanding of both normalized form and dimensional form databases.
In-depth knowledge and experience of data-warehousing strategies and techniques e.g. Kimble Data warehousing.
Key Experiences :
Excellent communication skills
Over 5 years- experience in a Business Intelligence Analyst or Developer roles
Over 4 years- experience using Microsoft Azure for data warehousing
Experience in designing and performance tuning data warehouses and data lakes.
4+ years extensive experience in developing data models and dashboards using Tableau / Power BI within an IT department
Self-starter who can manage own direction and projects
Being delivery-focused with a can-do attitude in a sometimes-challenging environment is essential.
Experience using Tableau to visualize data held in SQL Server
Experience working with finance data highly desirable.