Discovery Partners

Apply

Responsibilities:

Data solution architecture

Provide expert technical advice and guidance to strategize the setup, optimisation and life cycle management of the modern data platform
Provide expert technical advice and guidance to help scope out and design reporting solutions
Translate business requirements into technical data solutions
Develop innovative ETL approaches to bring a diverse set of on-prem and cloud-based data sources into the Data Lake
Identify and implement suitable data quality management and meta data management solutions

Azure platform development and management

Develop and operate the Azure BI platform. Design, develop, test, and roll-out effective Azure data repositories, such as databases, data marts, blob storage, and analytics models to deliver automated reporting, Power BI dashboards, and deploy data science capability
Develop Synapse Pipelines, and other data movement processes as required to support the Digital teams in reporting, auditing, and other data needs
Where necessary create new formats/processes or methodologies, document and communicate them to the wider BI community as needed to enhance the organisations capabilities
Develop and implement error and exception management processes, ensuring causes of poor data quality are identified and escalated to the business owners
Ensure the BI environment is proactively monitored, data flows from source systems are robust with adequate fault tolerance, the reporting layer is consistent, and new developments are designed in a modular fashion
Maintain and performance tune the cloud-based data storage solutions

Requirements:

Degree in computer science, information systems, or another related technical field
4+ years of experience in Azure BI development
Possesses a background in software and/or database development and engineering, data architecture, and managing BI Solutions
Experience as a database or ETL developer preferable on SQL server platform
Experience of designing conceptual and logical data models
Hands-on experience with developing in BI cloud technologies in Azure including Data Factory , Synapse Pipelines and Power BI (DAX) and Microsoft Fabric Platform.
Extensive working experience of Microsoft BI solutions (SSIS, SSAS, SSRS)
Experience in troubleshooting and resolving database issues such as integrity, performance, replication, connectivity, recovery, and security
Experience in agile methodologies
Experience in preparing data for data science and Machine Learning
Design and development of best practice ETL flows, data stores, dimensional models, cubes
Data warehousing and best practice BI Architecture
Data aggregation and dimensional modelling, OLAP
Data preparation (sourcing, acquisition, integration)
Fluency with appropriate tools including Azure DevOps, Visual Studio other SQL Server Management tools
Hands on dev capability in Synapse / Fabric.
Awareness of best practice, trends, and evolutions in the IT industry and most particularly MS Azure technology stack.