IS Specialist, Business Intelligence Data Designer/Developer
Computing and Information Services
Grade 7: - Full range
Open-Ended/Permanent - Full Time
Contracted Hours per Week: 35
Closing Date: 06-Mar-2020, 7:59:00 AM
Job Family: Estates and Information Infrastructure Services
OUR CHARACTERISTICS: We are welcoming, collegiate and inclusive.
OUR VALUES: We are motivated, inquisitive, challenging, rigorous and innovative.
Durham University is one of the world's top universities with strengths across the Arts and Humanities, Business, Sciences and Social Sciences. We are home to some of the most talented scholars and researchers from around the world who are tackling global issues and making a difference to people's lives.
The University sits in a beautiful historic city where it shares ownership of a UNESCO World Heritage Site with Durham Cathedral, the greatest Romanesque building in Western Europe. A collegiate University, Durham recruits outstanding students from across the world and offers an unmatched wider student experience.
Durham University seeks to promote and maintain an inclusive and supportive environment for work and study that assists all members of our University community to reach their full potential. Diversity brings strength and we welcome applications from across the international, national and regional communities that we work with and serve.
It is expected that all staff within the University:
- Contribute to our learning culture by engaging in mentoring, training and coaching.
- Positively contribute to fostering a collegial environment; as well as demonstrating commitment to equality, diversity and inclusion.
- Have due regard to Health and Safety requirements appropriate to grade and role.
Family key attributes
Roles in this family manage and maintain the integrity of University buildings, estates and information services.
Overall family purpose
- Ensure safe, sustainable and fit for purpose buildings, internal and external environments in and on which to conduct University business.
- Liaise and engage with stakeholders across the University to identify and plan infrastructure projects to update and improve services and facilities.
- Align services to meet organisational strategic and operational objectives.
- Design new, adapt existing and implement services, working with external contractors and suppliers.
- Manage and monitor systems, mechanisms and processes to ensure compliance with internal and external regulations.
- Implement procedures to ensure safe and secure buildings, facilities, estates and information networks.
- Design and construct real and virtual test environments to ensure the most fit for purpose technology and services are available to underpin University business needs.
- Manage technology driven services and third-party platforms to underpin teaching, learning, research and administrative activities across the University.
- Engage with external suppliers, contractors, manufacturers and developers to ensure the highest-standards and quality of buildings, estates and information services.
- Work collaboratively and network across the University with staff in other families to ensure a smooth, timely and high-quality delivery of service.
Link to key strategic plan
- An economically sustainable approach to delivering infrastructure services across the University;
- Develop an academic estate that will allow the University to deliver world-class education, research and student experience;
- Ensure the long-term availability of suitable residential accommodation;
- Ensure the continuing renewal and maintenance of our estate;
- Improve the environmental sustainability and ease of travel around our estate and city locations;
- Support and facilitate a first-rate digital learning environment and experience on a par with the best in the UK;
- Running and ongoing development of a first-rate digital learning environment on a par with the best in the UK
- A stakeholder-focused orientation, offering satisfying careers to all staff;
- Ensure that an increasingly diverse workforce is treated equally, fairly and with respect, and that all staff are demonstrably valued and actively engaged.
The Department and role purpose
The Computing and Information Services Department (CIS) has an annual operational budget in the order of £10m, multi-million pound programmes of change within year, and approximately 140 staff who are predominately based at the Durham University campus. The Senior Leadership Team report directly to the Chief Information Officer with the following portfolios: Strategy and Change; Operations; and Information Systems. CIS provides academic, teaching and administrative services across the organisation that underpin the day-to-day activities of the whole organisation.
Recent infrastructure improvements include investment in a new network backbone, including new cabling which runs throughout the city to all of the Universities core buildings, new scalable user facing storage, and a new hosting environment. Corresponding business led investment also continues to be made with a new Oracle Enterprise Resource Planning suite, investment in research administration, and maximising the breadth of opportunities available to the University through Office365, alongside numerous other important initiatives.
CIS is a friendly, but demanding department, where much is expected and can be achieved by competent, self-motivated individuals who are demonstrable in their team work ability.
The University uses Microsoft SQL Server 2017 SSIS, SSAS and Power BI (with some SSRS) to design, build and implement self-service business intelligence and reporting solutions to support senior management decision making. The purpose of this role is to design and develop the ETL processes and the data (including the dimensional databases, cubes and tabular models) required to do this. The post holder will require a high level of technical knowledge, experience of customer service delivery, risk management skills and the ability to convert business requirements into viable technical solutions.
- Recognised professional practitioner and service specialist.
- Implement changes to the design and development of service processes, techniques and deliverables for one or more service strands or project streams.
- Provide specialist expertise and support with complexity of data and information sources, interpretation and analysis.
- Contribute to development of operational service activities to ensure excellence in the stakeholder experience.
- Collect and analyse stakeholder feedback to help define needs and requirements and the design and planning of services.
- Internal and external relationship development and partnership working, networking and participation to engage and influence future services and the University reputation.
- Identify and design activities to meet learning objectives and outcomes.
- Deliver training, teaching and/or development delivery for stakeholders.
- Maintain an awareness of current policy for University business goals such as widening participation and access, and provision of advice using specialist knowledge.
- Contribute to and lead business meetings, working groups and sub-committees at departmental and operational service levels.
- Responsible for managing small budgets for consumables and some capital items, keeping records and processing invoices.
- Work directly with colleagues in other University departments to understand and refine information and reporting requirements
- Translate user requirements provided by business users, business analysts, subject matter experts and working groups into technical designs and documentation.
- Provide management for the delivery of high-quality estates and infrastructure support services across the University.
- Promote and foster positive and highly collaborative approaches to problem solving and project implementation, helping to motivate, mentor and coach project team members.
- Act as a point of contact for service colleagues and stakeholders to interpret and resolve complex infrastructure, architecture and technical problems.
- Make decisions about the nature and level of problem solving, physical and analytical tools, techniques and protocols to deliver project and service objectives, providing advice and making recommendations for resolution as appropriate.
- Collaborate with other specialists within the Service and across the University, regarding the use of modelling and analytical tools, methods and standards to deliver integrity and consistency with service delivery.
- Schedule and monitor maintenance and installation works, projects and work streams across the University.
- Provide regular status reports and identify risk management and contingency planning to other service staff, specialists, users and managers.
- Liaise with internal and external agencies, local authorities, industries and visitors where appropriate.
- Take responsibility for monitoring and updating risk assessments and safety procedures, providing guidance to others where necessary.
- Develop, modify and optimise protocols and methodologies.
- Any other reasonable duties.
Specific role requirements
This role will involve occasional work outside of normal working hours.
Recruiting to this post
In order to be considered for interview, candidates must evidence each of the essential criteria required for the role in the person specification above (including those listed in the section ‘Realising Your Potential Approach’).
In some cases, the recruiting panel may also consider the desirable criteria, so we recommend you evidence all criteria in your application.
Please note that some criteria will only be considered at interview stage.
How to apply
We prefer to receive applications online.
Please note that in submitting your application Durham University will be processing your data. We would ask you to consider the relevant University Privacy Statement https://www.dur.ac.uk/ig/dp/privacy/pnjobapplicants/ which provides information on the collation, storing and use of data.
What aryou e required to submit
- A CV;
- A covering letter which details your experience, strengths and potential in the requirements set out above;
- Answers to the questions evidencing how you meet the essential criteria. Examples of how you satisfy the Realising Your Potential Approach criteria in your cover letter.
Please ensure that you submit all documentation listed above or your application cannot proceed to the next stage.
For further information please contact;
Julie McIntyre, Senior IS Specialist (Reporting and Business Intelligence)
Durham University Computing and Information Services
T: +44 (0)191 334 2733 E: email@example.com
At Durham University, our aim is to create an open and inclusive environment where everyone can reach their full potential and believe our staff should reflect the diversity of the global community in which we work. We welcome and encourage applications from members of groups who are under-represented in our work force including people with disabilities, women and black, Asian and minority ethnic communities.
We will notify you on the status of your application at various points throughout the selection process, via automated emails from our e-recruitment system. Please check your spam/junk folder periodically to ensure you receive all emails.
Person specification - skills, knowledge, qualifications and experience required
Criteria- Please provide evidence of meeting the criteria (candidate to complete):
- Excellent oral and written communication skills and the ability to develop excellent working relationships both internally and externally.
- Proven general IT skills, including use of Microsoft Office.
- Educated to degree level (or equivalent professional qualification).
- Ability to solve problems and resolve issues, plan solutions and make pragmatic decisions.
- Thorough understanding of Data Warehouse and Business Intelligence methods and practices.
- Thorough understanding of and able to apply information security principles and implications of legislation such as GDPR.
- Able to design, build, test and deploy complex ETL solutions using SSIS 2012 or later.
- Able to create complex views and SQL Server stored procedures.
- Able to design and build complex dimensional databases and tabular models in a Microsoft BI environment.
- Able to provide 3rd line support for the applications that have been developed and manage change using version control techniques.
- Experience of being able to network effectively and develop strong and productive working relationships.
- Relevant industry and professional recognition and certification of achievement of skills and knowledge.
- Continuing professional development required to maintain professional recognition.
- Experience of delivering and developing specialist services for IT provision.
- Knowledge and experience of ensuring compliance with regulatory and organisational policy and guidelines.
- Experience of providing specialist advice and guidance to a range of customers and colleagues, including more senior colleagues.
- Knowledge and experience of SSAS cube design and deployment.
- Able to design and develop reports and dashboards using Power BI.
- Able to design and develop reports using SSRS.
- Good knowledge and experience of DAX.
- Involvement in project definition and gathering of business requirements.
- Ability to carry out overall data architecture design.
- ITIL Foundation.
DBS Requirement: Not Applicable.