Senior Business Intelligence Developer

Job highlights

• Strong database design skills,including an understanding of both normalised form and dimensional form databases. In-depth knowledge and experience of data-warehousing strategies and techniques e.g

• Experience using D365 ERP systems and creating BI reports

• Experience in developing data lakes and data warehouses using Microsoft Azure

• Experience in Azure Dev Ops is a plus

• 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 visualisation tools enabling the company s aim to become a fully digital organisation

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 normalised form and dimensional form databases.
• In-depth knowledge and experience of data-warehousing strategies and techniques e.g. Kimble Data warehousing
• Experience in Azure Analysis Services and DAX (Data Analysis Expressions)
• Experience in Cloud based data integration tools like Azure Data Factory or Snaplogic
• Experience in Azure Dev Ops is a plus
• Familiarity with agile development techniques and objectives

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 visualise data held in SQL Server
• Experience working with finance data highly desirable