Data Analyst

My client based in Edinburgh are undertaking a major transformation of their platform meet Business Objectives through standardised, controlled, and efficient processes embedded within core systems. The role will be Inside IR35, and looking for at least 2 days a week onsite in their Edinburgh Office.

The Data Analyst will play a key role in supporting the transformation of our systems and processes. They will deliver detailed process mapping, data analysis, and insight to enable the replacement of legacy component systems while maintaining strong data integrity across existing workflows. The role will focus on eliminating duplicate data entry across applications, improving data quality and consistency, and enhancing the accuracy and reliability of business reporting.

Through close collaboration with operational teams, the Data Analyst will ensure that data structures, flows, and controls align to business needs and support scalable, efficient ways of working.

Key Responsibilities

Map and document existing data flows end-to-end, including downstream systems and data warehouse integrations.
Validate current build stage management processes and associated tasks.
Validate design future-state processes incorporating their project management tool.
Define and document data structures and flows to support redesigned processes, aligned with the agreed solution architecture.
Collaborate with technical teams to ensure requirements are clear for integration and implementation.
Provide input into testing and validation of new processes and data flows.
Support change management activities by preparing process documentation and training materials where required. Required Skills and Experience

Strong data analysis skills, including understanding of data structures and flows.
Experience supporting solution design and integration activities.
Strong Power BI experience; model design and performance tuning.
Understanding and documenting requirements for data transformation
Excellent Power Query and SQL/TSQL experience.
Confidence engaging from C-suite to analysts; clear, outcome focused communication.
A track record of creating certified, reusable datasets that scale across multiple functional domains