Brilliant at Business Intelligence New College Swindon is looking for an experienced Senior Systems & BI Developer to lead the creation of accurate, timely data reports and dashboards for Governors and management. Location: North Star and Queens Drive (Hybrid options available) Salary: Up to £48,000 per annum Job Type: Full time, permanent Close Date: 1st December 2024 About Us: New College Swindon is a vibrant and dynamic institution, formed by the merger of New College and Swindon College. We are committed to delivering exceptional teaching, facilities and guidance for our students. Senior Business Intelligence Developer The Role: You will support the development and implementation of College quality improvement planning through the provision of robust and accurate management information on student data, funding and other key performance indicators while leading the production of accurate, timely and accessible data reports & dashboards for Governors and college management. Senior Business Intelligence Developer Key Responsibilities: Produce high-quality statistical and analytical reports using relational databases, spreadsheets, and other tools Design and develop data queries to import, interrogate, and extract data from college systems, funding agency software, and other sources Design, update, and publish Power BI dashboards and Microsoft Reporting Services reports, ensuring accessibility for staff to query college databases Collaborate with BI developers to develop and optimise databases, tables, views, and stored procedures, as well as administer the Data Warehouse Gather business intelligence requirements from internal and external stakeholders, provide technical support, and ensure adherence to best practices Work with the MIS team to automate manual processes and maintain efficient, reliable reporting systems Assist the exams team during the summer exam series with preparation, invigilation, and additional tasks as needed Senior Business Intelligence Developer You: Minimum Level 2 in English and Math; Level 3 in a relevant field or equivalent experience in high-level data reporting & dashboard creation Extensive experience with Entity Relational Diagrams and integrating data across complex databases Proficient in producing and presenting data reports and dashboards for senior leadership and external stakeholders Strong skills in querying relational databases, data warehouse design, and optimising data structures for BI Advanced IT skills: T-SQL, SQL Server BI Stack, MS Office, and related software Expertise in SQL tools, SQL Server Reporting Services, and complex SQL coding (functions, stored procedures, T-SQL scripts) Experience in setting up and maintaining SSIS packages Proficient in Visual Studio and Source Control tools Senior Business Intelligence Developer - Benefits: 5.5 weeks holiday paid in salary 21.7% College pension contribution to LGPS Health care cash plan Free car parking Discounted Hair & Beauty On-site gym Staff development & training Sodexo Retail Discount Scheme Hybrid working arrangements And more! Safeguarding Statement New College Swindon is committed to safeguarding and promoting the welfare of children, young people and vulnerable adults and expects all staff and volunteers to share this commitment. We particularly welcome applications from underrepresented groups including ethnicity, gender, transgender, age, disability, sexual orientation or religion. References will be sought on shortlisted candidates before interview and by agreement. Application Process: An enhanced DBS check, to the satisfaction of New College Swindon, will be required for this role. Please note that this vacancy may close before the published closing date if sufficient applications are received. Please note that this vacancy may close before the published closing date if sufficient applications are received. To apply, you MUST have Right to Work in the UK. To apply for this Senior Business Intelligence Developer opportunity, please click Apply' now!