Principal Business Solutions Developer
We are seeking a skilled Principal Business Solutions Developer to join our team. This role will involve designing and developing data models, applying extensive knowledge of data warehouse and ETL design principles.
The successful candidate will have the opportunity to contribute to the ongoing development, enhancement and maintenance of data warehouse and reporting products. They will develop fit-for-purpose data models to deliver insights directly into the hands of users.
About the Role
* This position plays a key part in shaping and supporting the department's continued expansion of business intelligence solutions.
* The Principal Business Solutions Developer will be responsible for designing and developing data models, as well as conducting performance analysis and optimising code as required.
Responsibilities Include:
* Designing and developing data models, applying extensive knowledge of data warehouse and ETL design principles.
* Developing and implementing Quality Assurance checks to ensure data quality, integrity, and lineage across solutions.
* Conducting performance analysis and optimising code as required.
Requirements
* Demonstrated knowledge of data warehouse architecture, data modelling, and ETL design.
* Highly developed analytical skills, particularly in analysing data and transforming it into relational tables.
* Demonstrated experience working with the Microsoft development stack, including SQL Server Management Studio and Visual Studio, for the creation of ETL processes on Microsoft SQL Server, as well as creation of semantic models in PowerBI or SSAS, including DAX query language.