Data Analyst

Your Newpany and Role

Hays' client is a leading Scottish public sector organisation. You will play a crucial role in their data migration project, transitioning data from our current system to a new platform.

In this role, you will:

Cleanse and transform data from the current system for migration to the new platform.

Map external data sources, interfaces, and third-party systems.

Document off-system data sources and identify critical data for inclusion in the transformation activity.

Evaluate localised reporting activities and determine gaps in specified reporting.

Analyse off-system data sources and documents for digitisation.

Ensure datapliance with GDPR and retention policies.

Support the development and implementation of tools for data identification and archiving.

Support the cataloguing and mapping of data fields used in critical processes.

What You Will Need to Succeed
The following skills and experience are essential for this role:

Knowledge and experience with ETL methodologies and practices.

Understanding of data cleanse principles and the ability to apply them across large data sets.

Ability to understand systems topography and develop maps to trace data lineage.

Experience maintaining data dictionaries and recording data items and validation criteria.

Knowledge of datapliance and GDPR practices and policies.

Experience with data retention schedules and archiving principles.

Ability to map data flow between systems.

Experience with exchanging data between systems using interfaces and APIs.

Strongmunication and interpersonal skills.

Ability to work with stakeholders at all levels of seniority across the organisation.

Experience with project lifecycle and testing methodologies within a deployment setting.

The following skills and experience are desirable for this role:

SQL skills for developing and interrogating views within non-production environments.

Strong Microsoft Excel and SharePoint skills.

Experience with automated testing tools.