Data Analyst

Venesky Brown; Paisley; Hybrid; GBP 72,000 - 94,000; Full time

Job summary

Venesky-Brown's client in Glasgow is recruiting a Data Analyst for an initial 6-month contract at £450/day (Inside IR35). Hybrid working with around one day per week in Glasgow.

You will lead data migration workstreams, define cleansing, transformation and validation rules, and coordinate integrations with data owners and suppliers. A strong focus on BI, governance, and robust MI reporting is required.

Qualifications

• Experience leading data migration within BI and governance standards.
• Ability to define cleansing, transformation and validation rules.
• Experience coordinating data integration and system migrations.
• Knowledge of GDPR and data governance practices.
• Strong reporting and MI capability.

Responsibilities

• Lead end-to-end data migration workstream and define mapping specs.
• Develop data plan aligned with project strategy and track delivery.
• Lead data preparation and quality initiatives and ownership model.
• Coordinate integrations and future architecture with data owners and suppliers.
• Translate business requirements into reporting and MI catalogues.

Skills

Data migration

Data governance

BI

Data quality

Tools

GDPR compliance

Job description

Venesky-Brown's client, in Glasgow, is currently looking to recruit a Data Analyst for an initial 6 month contract on a rate of £450/day (Inside IR35). This role will be hybrid working with around 1 day per week in Glasgow.

Responsibilities:

• Lead the end-to-end data migration workstream - working within the corporate Business Intelligence (BI), DDaT, data governance and information governance standards where available, produce the project's data migration strategy and plan, producing mapping specifications from legacy systems to future Software as a Service (SaaS) solutions. Define cleansing, transformation and validation rules, coordinate mock loads, reconciliation cycles and final cut over across all data in the project scope. Resolve complex data issues with functional subject matter experts, BI, DaTS and system suppliers, reporting data readiness to governance groups.
• Data planning - Develop a plan for all areas of the agreed project data strategy that aligns with the wider project, technical, change and implementation plans, detailing all data and reporting related tasks and milestones. Maintain the plan once baselined, tracking delivery burn rate and escalating as required deviations from the baselined plan out with agreed tolerance.
• Lead data preparation and quality - establish an ownership model for data within scope of the project, aligning to corporate retention and metadata requirements where available and defining project specific requirements as necessary. Lead targeted data cleansing, estimating the size and scale of cleansing and the specific resources required to execute it.
• Lead, define and coordinate integrations - working with DaTS, data owners and future system suppliers, define the future integration architecture aligned to DDaT strategy principles, ensuring all data flows are documented.
• Lead the project's management information and reporting strategy - lead on the translation of business requirements into a reporting and MI catalogue that delivers the project's outcome of robust management information. Define operational, strategic and compliance dashboards to eliminate spreadsheet reliance and manual reconciliations, delivering real time, self-service reporting for users.
• Ensure that reporting and dashboard requirements for "Day One" are fully understood, agreed, built, tested and operational to support a successful go-live and embedding new ways of working. Ensure that all relevant teams and governance groups are engaged as required.
• Lead the alignment of data to support process redesign - ensure that project data standards support adopt not adapt configuration approach, working with stakeholders across the organisation to ensure re-designed processes use on system data and enable automation across workflows, triggers and notifications.
• Governance and assurance - maintain the risk, issues and dependencies relating to data elements of the project and provide updates to project and corporate governance groups to ensure compliance with corporate data and security standards, GDPR regulations and DDaT strategy.
• Lead cross functional and supplier collaboration - lead collaborative working with DaTS, BI & Data, People, Finance, Asset Management, Operational and Business Support teams and external suppliers to ensure project data activities are properly sequenced across all workstreams and aligned to corporate standards where available. Work with external and internal suppliers to ensure configuration, migration and integration work to ensure technical dependencies are understood and resolved as required.
• Procurement - work with the Procurement Category Lead and User Intelligence Group members to ensure all data requirements and relevant evaluation criteria are accurately captured and represented throughout the procurement process.
• Business change and readiness - work closely with the project Business Change Lead to support business readiness in relation to data quality and migration. Ensure future integrations support users and processes requirements. Support the Business Change Lead in defining training, readiness and user adoption activities reliant on data and reporting outputs.