About the Role
This role offers an exciting opportunity to play an active part in the development and maintenance of the College’s data systems, ensuring they remain robust, accurate, and fit for purpose. You will support the creation and management of reports, datasets, and system integrations that empower data-driven decision-making across the organisation.
Working collaboratively with colleagues across departments, you’ll help to ensure key data processes are efficient, accessible, and reliable — contributing to the continuous improvement of how the College collects, analyses, and uses information to deliver its strategic goals.
Key Responsibilities
* Support the develop and maintain datasets, reports, and dashboards using tools such as SQL Server, SSRS, and Power BI.
* Actively take part in designing and implementing data solutions that meet the requirements of internal stakeholders, ensuring outputs are accurate, timely, and user-friendly.
* Assist in managing and updating the College’s data warehouse, ensuring the accuracy and integrity of stored data.
* Support the creation and maintenance of automated data transfers between systems, helping to ensure consistency and reliability across platforms.
* Monitor and maintain the security, integrity, and confidentiality of data systems, ensuring appropriate access controls, data quality checks, and compliance with relevant policies and regulations.
* Support the development of workflows and forms to streamline data collection and improve efficiency for end users.
* Collaborate with key users to understand data needs, gather specifications, and develop fit-for-purpose reporting and integration solutions.
* Regularly review existing reports and processes, identifying opportunities to enhance performance and usability.
* Contribute to the implementation and support of new systems and software integrations, ensuring compatibility with existing architecture.
Skills & Expertise
* Experience using SQL Server Management Studio and writing SQL queries
* Proven ability to design and deliver reports and dashboards using Power BI, SSRS, or similar BI tools
* Understanding of data warehouse structures and data modelling concepts
* Experience developing user-focused reporting or data solutions working with large and complicated datasets
* Knowledge of GDPR, access control, and secure data handling best practices
* Strong attention to detail and commitment to data quality and consistency
* Demonstrated ability to work independently and manage competing tasks and priorities
* Strong knowledge of Microsoft 365 applications including Excel, Word, Outlook, and Teams
Qualifications & Training
* Degree or equivalent experience in a relevant field (e.g. Computer Science, Information Systems, Mathematics)
* Level 2 qualification (GCSE A* – C, or equivalent) in maths and English or a willingness to attain these qualifications with the support of the College
#J-18808-Ljbffr