Full time Senior Report Writer
Job Location:
Yearly Salary:
Posted:
Application Deadline:
Vacancies:
Job Summary
An exciting opportunity has arisen at Oaklands for a Senior Report Writer to lead the development maintenance and continuous improvement of the Colleges business intelligence reporting and analytics environment.
We are looking for an experienced Senior Report Writer to join our team and play a crucial role in the design and delivery of reporting solutions dashboards automated workflows and management information that support strategic decision-making operational performance funding compliance and quality improvement.
In this position you will lead the design development maintenance and monitoring of enterprise reporting solutions across College systems. Develop and maintain interactive Power BI dashboards scorecards and data visualisations for governors senior leaders and operational managers.
You will also be responsible for the design development and maintenance of SQL Server databases views stored procedures functions and reporting data models and develop business applications using Microsoft Power Apps to streamline and improve operational processes.
Lead the design development maintenance and monitoring of enterprise reporting solutions across College systems.
Develop and maintain interactive Power BI dashboards scorecards and data visualisations for governors senior leaders and operational managers.
Design develop and support SSRS reports scheduled reporting solutions and selfservice reporting tools.
Transform complex data into clear business intelligence that supports strategic and operational decision-making.
Develop and maintain consistent reporting standards definitions measures and key performance indicators across the College.
Design develop and maintain SQL Server databases views stored procedures functions and reporting data models.
Create and optimise complex T-SQL queries and datasets to support statutory operational and management reporting requirements.
Support the development and enhancement of the Colleges data warehouse and associated data integration processes.
Investigate and resolve data quality reconciliation performance and reporting issues.
Maintain a controlled and documented library of reporting code datasets configurations and technical processes.
Develop business applications using Microsoft Power Apps to streamline and improve operational processes.
Create automated workflows using Power Automate to reduce manual processing improve controls and increase efficiency.
Develop integrated solutions connecting MIS curriculum finance HR and other College systems where appropriate.
Promote effective secure and sustainable use of the Microsoft Power Platform across the College.
Work closely with senior leaders curriculum teams and professional services to understand reporting and analytical requirements.
Translate business requirements into clear technical specifications data models and reporting outputs.
Act as the lead point of contact for complex reporting dashboard and data analysis requests.
Explain technical concepts and analytical findings clearly to technical and non-technical audiences.
Plan and prioritise reporting developments in line with College objectives agreed deadlines and service standards.
Ensure reporting solutions comply with UK GDPR College data protection requirements information security standards and role-based access controls.
Support audit funding statutory and regulatory activity through the provision of accurate timely and traceable management information.
Develop and maintain reports that monitor the accuracy completeness and quality of MIS data.
Apply quality assurance reconciliation testing and change control to reporting developments before release.
Maintain knowledge of FE sector data funding and performance measures and apply this knowledge to reporting solutions.
Identify opportunities to automate processes consolidate reports and improve business efficiency.
Regularly review dashboards reports and applications to ensure they remain accurate effective and aligned with evolving College needs.
Evaluate new reporting and analytics technologies and recommend proportionate improvements.
Support the Colleges wider data strategy digital transformation and business intelligence roadmap.
Maintain professional knowledge through relevant training continuous professional development and engagement with sector practice.
Comply with all College policies and procedures including safeguarding health and safety equality diversity and inclusion data protection and risk management requirements.
Attend training professional development and continuous improvement activities.
Undertake any other duties commensurate with the grade and responsibilities of the post.
Is This You
Ability to work effectively as part of a team and on own initiative.
Excellent written and verbal communication skills with the ability to communicate effectively at all levels.
Customer-focused approachable and able to establish positive working relationships.
Highly organised accurate and detail-oriented with the ability to manage competing priorities and meet deadlines.
Analytical innovative and methodical with strong research and problem-solving skills.
Positive flexible and committed to continuous improvement and professional development.
An understanding of and commitment to cultural diversity equality and inclusion.
Extensive experience of developing and maintaining Power BI dashboards reports semantic models and data visualisations.
Advanced SQL Server and T-SQL development skills including complex queries views stored procedures and functions.
Experience of developing and supporting SQL Server Reporting Services reports and scheduled reporting solutions.
Experience of developing business solutions using Microsoft Power Apps and Power Automate.
Strong knowledge of relational database principles data modelling and data warehousing.
Experience of working with large complex datasets and applying robust validation and reconciliation controls.
Ability to interpret complex business requirements and translate them into sustainable technical solutions.
Ability to present complex data and technical processes in a clear accessible format.
Experience of producing management information for senior leaders and operational managers.
Advanced Microsoft Excel and wider Microsoft 365 skills.
Understanding of data protection information security and secure reporting practices.
Experience of working within Further Education Higher Education or another public-sector environment.
Knowledge of the Individualised Learner Record FE funding methodologies and Department for Education performance measures.
Experience of supporting data warehouse development data integration and report consolidation.
Experience of ProSolution ProMonitor or comparable FE management information systems.
Relevant Microsoft certification in Power BI Power Platform SQL Server or data analytics.
Qualifications
Level 3 qualification and GCSE English and Mathematics at Grade C/4 or above or equivalent qualifications or experience.
Degree-level qualification or equivalent professional experience in data information systems business intelligence or a related discipline.
At Oaklands we value our people and are committed to supporting your wellbeing professional growth and long-term success. When you join our team youll become part of a forward-thinking college that champions innovation collaboration and learner-centred education.
Local government Pension Scheme with excellent employer contributions.
Continuous Professional Development including free access to Adult Community Learning courses and staff training opportunities.
Free onsite permit parking.
Access to our onsite gym and discounted wellness treatments.
Cycle to Work Scheme and discounted travel through the UNO Bus Scheme.
Eye Care Vouchers supporting your health while working with screens.
Employee Assistance Programme providing confidential advice and support.
Mental Health & Wellbeing Support including trained Mental Health Peer Supporters.
Staff Development Days & Awards celebrating your achievements and recognising your impact.
Be aware of and follow College policies and procedures with particular attention to Health and Safety Safeguarding Prevent Wellbeing Risk Management Equality Diversity and Inclusivity Quality Cyber Security and our Values and Behaviours
Oaklands College is proud to be a Disability Confident Employer and we actively welcome applicants from all backgrounds. We are committed to safeguarding and promoting the welfare of young people and vulnerable adults and expect all staff and stakeholders to share this commitment.
We review applications on a rolling basis and may close this advert early if we receive high interest. Dont miss your opportunity to join a college thats shaping futures and transforming lives.
Want to know more about Oaklands College Click here
