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