"E2" . "Estates identifier" . . . "Agent" . "finance code" . "OUCS" . "Information Communication Technology Support Team" . . "in dataset" . . . . "Oxford University Computing Services" . """

Senior Developer- Business Intelligence

 

Spanning the historic streets of the “city of dreaming spires,” the University of Oxford has been ranked the world’s leading university for nine consecutive years. A place where centuries of tradition meet world-changing innovation, we offer you the chance to shape the future while working in an inspiring environment that promotes excellence. Here, you’ll contribute to ground-breaking research that tackles global challenges—from advancing sustainability to pioneering healthcare solutions—and join a diverse, inclusive community that champions your wellbeing, development, and aspirations. Apply now to become part of our extraordinary legacy.

 

An exciting opportunity has arisen for a Senior Developer – Business Intelligence to join us on a permanent basis within our IT Services department.

 

The Department 

IT Services plays a pivotal role in supporting the University’s digital infrastructure, providing robust technology solutions that underpin world-class research, teaching, and administration. The Data Reporting, Architecture, and Modelling team focuses on architecting and managing data platforms that enable effective decision-making across the University. Within this team, the Business Intelligence (BI) group supports the University’s central Data Warehouse, ensuring timely, reliable access to critical information while providing technical leadership to innovative BI projects that enhance data-driven insight and analysis.

 

What We Offer

Working at the University of Oxford offers several exclusive benefits, such as:


  • 38 days of annual leave to support your wellbeing, with the option to purchase up to 10 extra days and additional leave after long service.

  • One of the most generous maternity and adoption leave schemes in UK higher education, offering up to 26 weeks of full-pay leave, followed by additional statutory and unpaid leave options.

  • A commitment to hybrid and flexible working to suit your lifestyle.

  • An excellent contributory pension scheme.

  • Affordable and sustainable commuting options, including a cycle loan scheme, discounted bus travel, and season ticket loans.

  • Access to a vibrant community through our social, cultural, and sports clubs.


 

About the Role

As a Senior Developer – Business Intelligence, you will take a leading role in the design, development, and maintenance of the University’s BI solutions, built on the Microsoft BI technology stack. You’ll work closely with analysts, developers, and end users to deliver high-quality, scalable solutions that meet the complex data needs of the University.

 

In this role, you will be responsible for developing robust ETL (Extract, Transform, Load) processes, ensuring the effective movement of data from various source systems into the University’s Data Warehouse. You’ll lead the design, coding, and testing of BI solutions, ensuring they are well-documented, reliable, and fit for purpose.

 

Beyond technical development, you’ll act as a key source of expertise in the BI team, supporting and mentoring colleagues, promoting best practices, and ensuring high-quality support for production systems. With access to cutting-edge BI technologies, you will have the opportunity to broaden your skill set as we progress the migration of out on-premise Data Warehouse to the Microsoft cloud.

 

 

About You

We are looking for a skilled and motivated professional with:


  • A degree in a computing or IT-related subject or equivalent professional experience.

  • Extensive knowledge of the Microsoft BI stack, including SQL Server, T-SQL, and SSIS.

  • Strong knowledge of Data Warehousing principles and experience developing ETL processes.

  • A solid understanding of the full software development lifecycle, including design, development, and support of production systems.

  • Excellent communication skills, with the ability to work collaboratively in a team environment and engage with both technical and non-technical stakeholders.


 

Application Process

To apply, please upload:


  • A covering letter/supporting statement

  • Your CV

  • The details of two referees


 

The closing date for applications is 12 noon on the week commencing 03 February 2025.

 

Interviews will take place on the week commencing 10 February, and will be held either face to face or virtually.
"""^^ . . "University of Oxford" . _:Nf6bbec29b91943c4b018b3691b599981 "University of Oxford" . "Gibson Building" . . . "email"@en . . . "street address"@en . . """**Senior Developer- Business Intelligence** Spanning the historic streets of the “city of dreaming spires,” the University of Oxford has been ranked the world’s leading university for nine consecutive years. A place where centuries of tradition meet world-changing innovation, we offer you the chance to shape the future while working in an inspiring environment that promotes excellence. Here, you’ll contribute to ground- breaking research that tackles global challenges—from advancing sustainability to pioneering healthcare solutions—and join a diverse, inclusive community that champions your wellbeing, development, and aspirations. Apply now to become part of our extraordinary legacy. An exciting opportunity has arisen for a **Senior Developer – Business Intelligence** to join us on a **permanent basis** within our IT Services department. **The Department** IT Services plays a pivotal role in supporting the University’s digital infrastructure, providing robust technology solutions that underpin world- class research, teaching, and administration. The Data Reporting, Architecture, and Modelling team focuses on architecting and managing data platforms that enable effective decision-making across the University. Within this team, the Business Intelligence (BI) group supports the University’s central Data Warehouse, ensuring timely, reliable access to critical information while providing technical leadership to innovative BI projects that enhance data-driven insight and analysis. **What We Offer** Working at the University of Oxford offers several exclusive benefits, such as: * **38 days of annual leave** to support your wellbeing, with the option to purchase up to 10 extra days and additional leave after long service. * One of the most **generous maternity and adoption leave schemes** in UK higher education, offering up to 26 weeks of full-pay leave, followed by additional statutory and unpaid leave options. * A commitment to **hybrid and flexible working** to suit your lifestyle. * An excellent **contributory pension scheme**. * **Affordable and sustainable commuting options** , including a cycle loan scheme, discounted bus travel, and season ticket loans. * Access to a **vibrant community** through our social, cultural, and sports clubs. **About the Role** As a **Senior Developer – Business Intelligence**, you will take a leading role in the design, development, and maintenance of the University’s BI solutions, built on the Microsoft BI technology stack. You’ll work closely with analysts, developers, and end users to deliver high-quality, scalable solutions that meet the complex data needs of the University. In this role, you will be responsible for developing robust **ETL (Extract, Transform, Load) processes** , ensuring the effective movement of data from various source systems into the University’s Data Warehouse. You’ll lead the design, coding, and testing of BI solutions, ensuring they are well- documented, reliable, and fit for purpose. Beyond technical development, you’ll act as a key source of expertise in the BI team, supporting and mentoring colleagues, promoting best practices, and ensuring high-quality support for production systems. With access to cutting- edge BI technologies, you will have the opportunity to broaden your skill set as we progress the migration of out on-premise Data Warehouse to the Microsoft cloud. **About You** We are looking for a skilled and motivated professional with: * A degree in a computing or IT-related subject or equivalent professional experience. * **Extensive knowledge of the Microsoft BI stack** , including **SQL Server** , **T-SQL** , and **SSIS**. * Strong knowledge of **Data Warehousing principles** and experience developing ETL processes. * A solid understanding of the **full software development lifecycle** , including design, development, and support of production systems. * Excellent communication skills, with the ability to work collaboratively in a team environment and engage with both technical and non-technical stakeholders. **Application Process** To apply, please upload: * A **covering letter/supporting statement** * Your **CV** * The details of **two referees** The **closing date** for applications is 12 noon on the week commencing **03 February 2025.** **Interviews** will take place on the week commencing **10 February** , and will be held either face to face or virtually. """ . "false"^^ . . . . _:N560cc9b400fd403bb412693759026f13 "Oxford" . _:N7c77a59480a74d03adaac3859203df86 . "latitude" . "NTriples description of Senior Developer- BI" . _:N7c77a59480a74d03adaac3859203df86 "+44-1865-270708" . "text/turtle" . . "Voice"@en . . . . . . . "Business Services and Projects" . "Alex Purbrick" . "E2"^^ . _:N2463404989c24e69b0a71dacc2d71221 "United Kingdom" . "sede principale"@it . _:Nf0b3d3beb34241119298eada99fcca2f . . . "label" . . . . "longitude" . "RDF/XML description of Senior Developer- BI" . . . "Senior Developer- BI" . "Description of Senior Developer- BI" . "Is Part Of"@en . . . "OxPoints"@en . . . "value" . . . "department" . "based near" . "text/html" . "Dartington House" . . "HTML description of Senior Developer- BI" . . . _:N2463404989c24e69b0a71dacc2d71221 "Oxford" . . "I.T. Services" . . "IT Services" . _:N2463404989c24e69b0a71dacc2d71221 . . "IT Services, Dartington House, Oxford" . . _:Nd80d2768362d4779adcf5f01f9c825d2 . . "address"@en . . . . "country name"@en . . . "7-19 Banbury Road" . "true"^^ . . "text/plain" . "Title"@en . . . _:Nd80d2768362d4779adcf5f01f9c825d2 . . . _:Nf0b3d3beb34241119298eada99fcca2f . . . "occupies" . . "8HP0" . _:Nf0b3d3beb34241119298eada99fcca2f . . _:Nf6bbec29b91943c4b018b3691b599981 "United Kingdom" . . . _:Nf6bbec29b91943c4b018b3691b599981 "Wellington Square" . . . . "has primary place" . . . "Standard Grade 8: £48,235 - £57,255" . . . "Gibson Building" . . "2025-01-13T09:00:00+00:00"^^ . "has site"@en . _:Nf6bbec29b91943c4b018b3691b599981 . . _:N2463404989c24e69b0a71dacc2d71221 . _:N560cc9b400fd403bb412693759026f13 . . "site principal"@fr . . . . "IT" . "Turtle description of Senior Developer- BI" . . . "text/n3" . "Job Description 177263 - Senior Developer- BI" . . . "name" . _:Nd80d2768362d4779adcf5f01f9c825d2 "+44-1865-270000" . . . . . . . "page" . . . . "comment" . . . "IT Services" . "Address"@en . "I.T." . "ITS" . . . "image" . "8HP0"^^ . "subOrganization of"@en . . . . . . . "itserv"^^ . . . . "University Administration and Services (UAS)" . "23233683"^^ . . . . . . . . "building" . . . . . "extended address"@en . "Format"@en . . . . "101"^^ . "51.758797"^^ . . "I. T. Services" . "es suborganización de"@es . . . . . _:N560cc9b400fd403bb412693759026f13 . . "License"@en . . . "sotto-Organization di"@it . _:Nf6bbec29b91943c4b018b3691b599981 "OX1 2JD" . . . . . "locality"@en . . . . "notation"@en . . . . . "7-19 Banbury Road" . "-1.261062"^^ . "hidden label"@en . . "Title"@en . "application/xhtml+xml" . "depiction" . _:Nf6bbec29b91943c4b018b3691b599981 "Oxford" . . . "account" . . _:N2463404989c24e69b0a71dacc2d71221 "7-19 Banbury Road" . "telephone"@en . "Fax"@en . "primary Site"@en . "101" . . . . "false"^^ . . . . """Job Description _________________________________________________________________________ Summary Job title Senior Developer - BI Division University Administrative Services Department IT Services Location Central Oxford Grade and salary Grade 8: £48,235 – £57,255 per annum Hours Full-time Contract type Permanent Reporting to BI Team Leader, Data Reporting, Architecture and Modelling Team Vacancy reference 177263 • Additional information • Whist this is a full-time post, we welcome applications from candidates who wish to work part-time (minimum 30 hours/0.8 FTE) and/or flexibly. Hybrid working is available The role The Senior Developer – BI post is in the BI team of the Data Reporting, Architecture and Modelling part of the Software Solutions group of IT Services. The BI team is responsible for supporting the University’s central Data Warehouse and Reporting Tools as well as providing project resource for Business Intelligence projects. The post holder will take a lead role in the Software Solutions Group in developing and supporting applications built on the Microsoft BI technology stack. In particular they will be responsible for development of the Extract, Transform, Load (ETL) processes used to move data for source systems and remodel it into warehouse structures that are easily consumable by reporting tools. The post-holder will have a thorough knowledge of the use of the Microsoft BI stack, will be a source of technical expertise to the team and will lead the design, coding and testing of developments in this technology. In addition, they will be willing to learn and take the lead on other BI technologies when necessary and appropriate. Flexible working • • Whist this is a full-time post, we welcome applications from candidates who wish to work part-time (minimum 30 hours/0.8 FTE) and/or flexibly. Hybrid working is available Responsibilities • Understand the technical issues and data challenges of the University and provide technical input as to how these may be met. • Take a lead role in the design, coding, testing and documentation of developments, working from functional specifications or detailed change requests. • Liaise closely with the Functional Analysts, Business Analysts and users through all stages of design, development and testing to ensure that developments meet the users’ requirements. • Prioritise, estimate and schedule work. Report any scheduling or work load/resource issues. • Provide support and maintenance for production systems. • In areas of technical specialism, implement, review, manage and maintain common approaches for the entire team. Provide leadership, training and supervision, where appropriate, to other developers. • Keep up to date with technical developments. Extend skills and knowledge and highlight any potential technical opportunities. Selection criteria Essential selection criteria • Education to degree level in a computing or IT related subject or able to offer the equivalent in terms of professional training and experience. • Broad technical knowledge including expert knowledge of the Microsoft BI stack particularly SQL Server (SQL and TSQL) and SSIS. • Good knowledge of database design, in particular Data Warehousing theories. • A strong understanding of the full lifecycle of software development gained from previous employment in a commercial software development environment or major software implementation project. • Careful attention to detail and an ability to demonstrate an understanding of the need for programming and documentation standards in development work. • The ability to meet tight deadlines through a creative approach to problem-solving along with an adaptable and flexible attitude towards the demands of the job. • The ability to work within, and contribute to, a team environment and build and maintain effective working relationships with customers, users and colleagues within the wider project team. • The ability to manage, plan and take responsibility for a range of tasks involving interaction with other developers, business analysts or users. • The ability to communicate effectively with both technical and non-technical colleagues at all levels in both verbal and written communications. Desirable selection criteria • Experience of BI development in Azure, hopefully Fabric • Experience of working with Power BI • Experience of working in the higher education sector or with higher education institutions. Job Description 177263 – Senior Developer- BI 2 Pre-employment screening Standard checks If you are offered the post, the offer will be subject to standard pre-employment checks. You will be asked to provide: proof of your right-to-work in the UK; proof of your identity; and (if we haven’t done so already) we will contact the referees you have nominated. If you have previously worked for the University we will also verify key information such as your dates of employment and reason for leaving your previous role with the department/unit where you worked. You will also be asked to complete a health declaration so that you can tell us about any health conditions or disabilities for which you may need us to make appropriate adjustments. Please read the candidate notes on the University’s pre-employment screening procedures at: https://www.jobs.ox.ac.uk/pre-employment-checks About the University of Oxford Welcome to the University of Oxford. We aim to lead the world in research and education for the benefit of society both in the UK and globally. Oxford’s researchers engage with academic, commercial and cultural partners across the world to stimulate high-quality research and enable innovation through a broad range of social, policy and economic impacts. We believe our strengths lie both in empowering individuals and teams to address fundamental questions of global significance, while providing all our staff with a welcoming and inclusive workplace that enables everyone to develop and do their best work. Recognising that diversity is our strength, vital for innovation and creativity, we aspire to build a truly diverse community which values and respects every individual’s unique contribution. While we have long traditions of scholarship, we are also forward-looking, creative and cutting-edge. Oxford is one of Europe's most entrepreneurial universities and we rank first in the UK for university spin-outs, and in recent years we have spun out 15-20 new companies every year. We are also recognised as leaders in support for social enterprise. Join us and you will find a unique, democratic and international community, a great range of staff benefits and access to a vibrant array of cultural activities in the beautiful city of Oxford. For more information, please visit www.ox.ac.uk/about/organisation. IT SERVICES The role of IT Services is to ensure that the University of Oxford has the robust, reliable, and high-performing IT facilities it requires to support the distinctive needs of those engaged in teaching, learning, research, administration and strategic planning. IT Services, headed by the University’s Chief Information Officer, has around 320 staff across 2 buildings, an annual revenue budget of £22m and an IT capital plan of £60M across three years. The department is divided into groups covering infrastructure services, projects and programmes, software development, and customer services. Our aim is to attract and retain a workforce that is diverse, skilled, creative, and committed. We encourage flexibility in how we work, and welcome part time and flexible working arrangements. As a department we encourage a culture where we respect each other, are accountable for what we do, where we collaborate, give and receive constructive feedback and challenge one another. IT Services is a place where we value and recognise both our own and the contributions of others. By doing so we want to create a great culture to work in and a place where we all feel we belong. For more information please visit: http://www.it.ox.ac.uk/ Job Description 177263 – Senior Developer- BI 3 University Administration and Services (UAS) University Administration and Services (UAS) is the collective term for the professional services departments of the University. UAS comprises structures to: • • • support the University’s core academic purposes of teaching, learning and research; ensure the University can meet the requirements of government, funding bodies and other external agencies; and facilitate the attainment of the objectives set out in the University’s Strategic Plan. The offices of the UAS sections are spread across the city centre, with the main University Offices located in Wellington Square. For more information please visit: http://www.admin.ox.ac.uk How to apply Applications are made through our online recruitment portal. Information about how to apply is available on our Jobs website https://www.jobs.ox.ac.uk/how-to-apply. Your application will be judged solely on the basis of how you demonstrate that you meet the selection criteria stated in the job description. As part of your application you will be asked to provide details of two referees and indicate whether we can contact them now. You will be asked to upload a CV and a supporting statement. The supporting statement must explain how you meet each of the selection criteria for the post using examples of your skills and experience. This may include experience gained in employment, education, or during career breaks (such as time out to care for dependants) Please upload all documents as PDF files with your name and the document type in the filename. All applications must be received by midday UK time on the closing date stated in the online advertisement. If you currently work for the University please note that: - as part of the referencing process, we will contact your current department to confirm basic employment details including reason for leaving although employees may hold multiple part-time posts, they may not hold more than the equivalent of a full time post. If you are offered this post, and accepting it would take you over the equivalent of fulltime hours, you will be expected to resign from, or reduce hours in, your other posts(s) before starting work in the new post. Information for priority candidates A priority candidate is a University employee who is seeking redeployment because they have been advised that they are at risk of redundancy, or on grounds of ill-health/disability. Priority candidates are issued with a redeployment letter by their employing department(s). If you are a priority candidate, please ensure that you attach your redeployment letter to your application (or email it to the contact address on the advert if the application form used for the vacancy does not allow attachments). Job Description 177263 – Senior Developer- BI 4 If you need help Application FAQs, including technical troubleshooting advice is available at: https://staff.web.ox.ac.uk/recruitment-support-faqs Non-technical questions about this job should be addressed to the recruiting department directly. To return to the online application at any stage, please go to: www.recruit.ox.ac.uk. Please note that you will receive an automated email from our online recruitment portal to confirm receipt of your application. Please check your spam/junk mail if you do not receive this email. Important information for candidates Data Privacy Please note that any personal data submitted to the University as part of the job application process will be processed in accordance with the GDPR and related UK data protection legislation. For further information, please see the University’s Privacy Notice for Job Applicants at: https://compliance.admin.ox.ac.uk/job-applicant-privacypolicy. The University’s Policy on Data Protection is available at: https://compliance.admin.ox.ac.uk/dataprotection-policy. The University’s policy on retirement The University operates an Employer Justified Retirement Age (EJRA) for very senior research posts at grade RSIV/D35 and clinical equivalents E62 and E82 of 30 September before the 70th birthday. The justification for this is explained at: https://hr.admin.ox.ac.uk/the-ejra. For existing employees on these grades, any employment beyond the retirement age is subject to approval through the procedures: https://hr.admin.ox.ac.uk/the-ejra. There is no normal or fixed age at which staff in posts at other grades have to retire. Staff at these grades may elect to retire in accordance with the rules of the applicable pension scheme, as may be amended from time to time. Equality of opportunity Entry into employment with the University and progression within employment will be determined only by personal merit and the application of criteria which are related to the duties of each particular post and the relevant salary structure. In all cases, ability to perform the job will be the primary consideration. No applicant or member of staff shall be discriminated against because of age, disability, gender reassignment, marriage or civil partnership, pregnancy or maternity, race, religion or belief, sex, or sexual orientation. Job Description 177263 – Senior Developer- BI 5 Benefits of working at the University Employee benefits University employees enjoy 38 days’ paid holiday, generous pension schemes, flexible working options, travel discounts including salary sacrifice schemes for bicycles and electric cars and other discounts. Staff can access a huge range of personal and professional development opportunities. See https://hr.admin.ox.ac.uk/staff-benefits Employee Assistance Programme As part of our wellbeing offering staff get free access to Health Assured, a confidential employee assistance programme, available 24/7 for 365 days a year. Find out more https://staff.admin.ox.ac.uk/health-assured-eap University Club and sports facilities Membership of the University Club is free for University staff. It offers social, sporting, and hospitality facilities. Staff can also use the University Sports Centre on Iffley Road at discounted rates, including a fitness centre, powerlifting room, and swimming pool. See www.club.ox.ac.uk and https://www.sport.ox.ac.uk/. Information for staff new to Oxford If you are relocating to Oxfordshire from overseas or elsewhere in the UK, the University's Welcome Service includes practical information about settling in the area, including advice on relocation, accommodation, and local schools. See https://welcome.ox.ac.uk/ There is also a visa loan scheme to cover the costs of UK visa applications for staff and their dependants. See https://staffimmigration.admin.ox.ac.uk/visa-loan-scheme Family-friendly benefits We are a family-friendly employer with one of the most generous family leave schemes in the Higher Education sector (see https://hr.web.ox.ac.uk/family-leave). Our Childcare Services team provides guidance and support on childcare provision, and offers a range of high-quality childcare options at affordable prices for staff. In addition to 5 University nurseries, we partner with a number of local providers to offer in excess of 450 full time nursery places to our staff. Eligible parents are able to pay for childcare through salary sacrifice, further reducing costs. See https://childcare.admin.ox.ac.uk/. Supporting disability and health-related issues (inc menopause) We are committed to supporting members of staff with disabilities or long-term health conditions, including those experiencing negative effects of menopause. Information about the University’s Staff Disability Advisor, is at https://edu.admin.ox.ac.uk/disability-support. For information about how we support those going through menopause see https://hr.admin.ox.ac.uk/menopause-guidance Staff networks The University has a number of staff networks including for research staff, BME staff, LGBT+ staff, disabled staff network and those going through menopause. Find out more at https://edu.admin.ox.ac.uk/networks The University of Oxford Newcomers' Club The University of Oxford Newcomers' Club is run by volunteers that aims to assist the partners of new staff settle into Oxford, and provides them with an opportunity to meet people and make connections in the local area. See www.newcomers.ox.ac.uk. Research staff The Researcher Hub supports all researchers on fixed-term contracts. They aim to help you settle in comfortably, make connections, grow as a person, extend your research expertise and approach your next career step with confidence. Find out more https://www.ox.ac.uk/research/support-researchers/researcher-hub Oxford’s Research Staff Society is a collective voice for our researchers. They also organise social and professional networking activities for researchers. Find out more https://www.ox.ac.uk/research/supportresearchers/connecting-other-researchers/oxford-research-staff-society Job Description 177263 – Senior Developer- BI 6 """^^ . . . . . "application/pdf" . . . . "application/rdf+xml" . . . "ha sede"@it . _:Nf6bbec29b91943c4b018b3691b599981 . "homepage" . . . . "logo" . . . . . "OUCS code" . . "00000000"^^ . . . . . "OpenStreetMap feature identifier" . . . "2025-02-03T12:00:00+00:00"^^ . . . "BSP" . "tiene sede principal en"@es . "Notation3 description of Senior Developer- BI" . . . . . . . "preferred label"@en . . . . . . . "valid through (0..1)"@en . "ICTST" . . _:N2463404989c24e69b0a71dacc2d71221 "OX2 6NN" . "Subject"@en . . _:N7c77a59480a74d03adaac3859203df86 . _:N560cc9b400fd403bb412693759026f13 "University Offices, Wellington Square" . . "tiene sede en"@es . . . . . "Unit price specification"@en . . . "University of Oxford" . "31337175"^^ . . . . _:N560cc9b400fd403bb412693759026f13 "United Kingdom" . . "OxPoints"@en . . . . . . . "itserv" . . "University Administration and Services (UAS)" . _:N560cc9b400fd403bb412693759026f13 "OX1 2HS" . . "true"^^ . "has exact match"@en . "Oxford, University of" . . "2025-02-03T12:00:00+00:00"^^ . . _:Nf0b3d3beb34241119298eada99fcca2f . . . . "23-38 Hythe Bridge Street" . "Dartington House" . "Source"@en . . . . . "177263"^^ . . . . "a un site"@fr . . "Past vacancies at the University of Oxford" . . . . "type" . "23-38 Hythe Bridge Street" . . "university" . "Document" . . "sous-Organization de"@fr . "postal code"@en . . "way/50593345" .