Senior Business Intelligence Developer | Bi | Adf Job in Datatobiz

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