Senior Azure Data Warehouse Developer

Jisc Job description template V1.0 
Job Description
Job title: Senior Azure Data Warehouse Developer (Security Specialist)
Grade: TDA3
Directorate: Data Collection & Statistics
Department & Location: Data Management (Data Infrastructure & Statistics)
Reports to: People Manager (Data Infrastructure & Statistics)
Working style: Hybrid (see description below)
Contract: 2 years
Hybrid: A blend of working from your hub office and home working. Days in the office are not 
mandated, and the frequency of time worked in the office is agreed with your manager. Meeting in 
person is something we value so you may need to travel on occasion to our hub offices. 
About the team: The role sits within the Data Collection and Statistics Directorate and will be part of the 
smaller but versatile data warehouse team involving many aspects of data life cycle and interactions with 
the business unit but with a specific emphasis on data security management. The team also develops 
transactional, relational, object oriented and star schema databases, for the business community. 
About the role and project: 
The HESA Security Architecture project, also known as Project Vulcan, aims to review the current 
architecture and security controls to ensure the implementation of appropriate security measures to 
protect, detect, and respond to any security incidents affecting any part of the architecture, web services 
and including database security and integrity. 
This is a role that requires experience in both data warehousing, Azure environments and data security
and will be linked to a specific project. You will be working with other data warehouse developers, and 
you will be responsible for reviewing and implementing solutions in light of any key decisions made from 
Project (Vulcan) and its deliverables. You will be liaising with the Jisc business security team to ensure 
their needs are met.
Key responsibilities and deliverables
• Review of overarching Azure architecture using zero trust architecture in database and security 
first methodologies.
• Review access permissions applied to logical database servers in Azure which host critical Azure 
SQL Server instances and data sets.
• To review and recommend perimeter and database security controls to protect, detect and 
respond to security and database issues.
• To review and recommend database security controls to protect data, including least privilege 
principle and need to know.
• Identify all data sets within Azure infrastructure which contain Personal Data (PD). Review the 
business need and ensure appropriate granular separation is in place with firewall rules to limit 
access.
• To review and make recommendations on non-production environments. 
• Assess where data content should be deleted or moved into a higher security archive location 
with strong protection assigned to these.
• To review authentication and authorisations methodologies across the service and databases.
• To review backup processes in accordance with the business and regularity requirements to 
ensure integrity and confidentiality is applied, including whether to adopt customer managed 
encryption keys.
• Work with internal teams to test any security controls implemented to protect the services. 
• To review azure architecture in accordance with best practices defined by the vendor. 
• Work with the Jisc Business Continuity Team to ensure that their Business Continuity, Disaster 
Recovery, and Incident Response processes are in place and tested accordingly to protect the 
business and the data. Ensuring that Recovery Time Objective (RTO) and Recovery Point 
Objective (RPO) have been agreed. 
Experience
Need to have 
• Extensive and demonstrable experience of data security & protocols.
• Comprehensive understanding of data warehouse analysis and design experience, with knowledge 
of data warehouse methodologies and data modelling.
• Strong understanding of relational database structures, theories, principles, and practices.
• Experience of data warehouse architecture review activity
• Understanding of fundamentals of Business Continuity and disaster recovery in line with database 
platforms
• Experience of working with Azure, Cloud and Data Warehouse factory
• Understanding of Microsoft Active Directory Optimisation of performance within a secure 
environment
Skills & personal qualities
Need to have 
• Ability to analyse project requirements into technical solutions according to specifications. 
• Ability to work in a team-oriented, collaborative environment. 
• Good oral communication, presentation and interpersonal skills. 
• Good analytical, conceptual, and problem-solving abilities. 
• Self-motivated and able to prioritise and execute tasks. 
• Undertake a methodical approach to work, especially when working under pressure
• Organise own time in order to meet deadlines and work commitments
• Work accurately and paying scrupulous attention to detail
Qualifications & training (if applicable)
Need to have 
• Microsoft DBA fundamentals – example Azure Data fundamentals
• Or SQL applied qualification – certification 
• M365 certification 
DBS required or enhanced background screening: This position requires the successful candidate to 
undergo enhanced background screening checks, which include but is not limited to 
• Basic / Enhanced UK criminal record check 
• Credit check 
• International fraud and sanctions. 
We are constantly changing and evolving at Jisc, so this job description just gives a flavour of what the 
role involves. It will change as our operations develop.