Data Analyst

Summary: The Data Analyst role at a leading Scottish public sector organization involves crucial responsibilities in a data migration project, focusing on cleansing, transforming, and mapping data from the current system to a new platform. The position requires collaboration with stakeholders to ensure data compliance and effective documentation of data sources. The analyst will also support the development of tools for data identification and archiving, ensuring adherence to GDPR and retention policies.

Key Responsibilities:

• 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 data compliance 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.

Key Skills:

• 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 data compliance 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.
• Strong communication and interpersonal skills.
• Ability to work with stakeholders at all levels of seniority across the organisation.
• Experience with project life cycle and testing methodologies within a deployment setting.
• SQL skills for developing and interrogating views within non-production environments (desirable).
• Strong Microsoft Excel and SharePoint skills (desirable).
• Experience with automated testing tools (desirable).

Salary (Rate): £45k

City: Glasgow

Country: UK

Working Arrangements: undetermined

IR35 Status: undetermined

Seniority Level: undetermined

Industry: Other