The Data Analyst will play a key role within the Data Architecture and Migration workstream, supporting the migration from legacy systems (predominantly SITS) to Banner SaaS. The postholder will explore, analyse, and validate data across multiple environments, helping to ensure accuracy and consistency during and after migration. They will also support ongoing analytical needs and contribute to ensuring continuity of reporting in the new system landscape.
Key Responsibilities
Data Analysis and Validation
* Query, explore, and reconcile data in the data migration environment and production systems using SQL and other tools (e.g. Power BI, Python, Excel, Banner Insights).
* Investigate and visualise data quality issues to present to business stakeholders (e.g. through Power BI reports), supporting the cleansing and transformation of data before migration.
* Collaborate with the Data Architect and business stakeholders to develop and validate mapping logic and transformation rules.
Stakeholder Liaison
* Engage with business stakeholders to investigate and resolve data-related queries.
* Translate technical findings into clear, actionable insights for non-technical audiences.
* Build productive relationships across functional areas, including project capability teams, Strategic Development and Delivery and IT Services.
* Reporting and Insight
* Support the Head of Data Product in analysing existing reports and identifying dependencies on legacy data sources.
* Develop new Power BI or equivalent reports to highlight cleansing progress and migration readiness.
* Assist in ensuring that key data remains visible and accessible to appropriate stakeholders post-migration.
Collaboration and Continuous Improvement
* Work closely with data engineers, the Data Architect, and governance colleagues to improve data quality and metadata management.
* Contribute to the refinement of data models and documentation to support the long-term data strategy.
* Help design and maintain dashboards for migration progress, data quality tracking, and business readiness.
Essential Skills and Experience
* Strong SQL skills, including experience querying complex data models.
* Experience with Higher Education data structures and Student Record Systems (e.g. SITS, Banner).
* Proven experience working with data from multiple systems, ideally within a migration or transformation project.
* Experience building and analysing reports in Power BI.
* Excellent problem-solving and analytical skills, with attention to detail.
* Strong interpersonal and communication skills, with experience liaising between technical and business teams.
* Understanding of data quality principles and governance frameworks.
Desirable Skills and Experience
* Familiarity with ETL or data pipeline concepts and tools (e.g. Pentaho, MuleSoft, dbt Labs).
* Knowledge of data warehousing and reporting best practices.
* Understanding of data modelling and metadata management.
* Awareness of GDPR and data protection requirements.
Attributes and Behaviours
* Curious, methodical, and detail-oriented approach to analysing data.
* Comfortable managing multiple priorities in a fast-moving project environment.
* Collaborative, open, and able to work effectively with both technical and non-technical colleagues.
* Commitment to continuous improvement and professional development.