Data Services support

Deliverables

Data Factory (Data Portal Migration):

Create solution to replace existing Data Portal processes: import / validate / export functional-ity within Azure Data Factory / Data Bricks.

Migrate all existing data portal configuration into Azure SQL config environment.

Have all code stored in Azure DevOps with deployment pipelines in place.

Fully document changes.

Migrate SVR, Data Quality, OFQDS_Stats databases:

Migrate existing processes/data from Data Portal SQL Server database.

Migrate SVR / Data Quality process into DW ETL

Migrate OFQDS_Stats into Data Lake / Data Mart systems.

Adapt existing ETL to use new sources.

Integrate import processes into Data Factory.

Fully document solution.

Data Factory (UI):

Create UI to ease process of configuring Data Factory. This piece of work is to replace cur-rent Data Importer UI when it is moved into Data Factory.

Fully document solution.

Public Facing Services

Exact activities to be defined following Discovery workshops with Ofqual and Ofqual's Digital Strategic Partner.

Current understanding of priorities:

Data architecture review with Digital Strategic Partner to separate Portal reporting into transactional (i.e. 'real-time' data available in the Portal) and analytical data (i.e. available in PowerBI)

Implement/support with any changes to enable the above.