EXPERIENCE
Essential skills and experience
- Have Microsoft Azure, particularly with reference to data warehouse architecture (IaaS and PaaS)
- Have database development using SSMS 2014 or higher experience
- Have ETL development / deployment using SSIS 2014 or higher experience
- Have data modelling / validation experiences
- Have DBA skills (server management, SQL jobs management, scheduling, scaling, backup / restore, security, account management / permissions, server objects, replication)
- Have process automation experience
- Have BI tools (particularly Tableau / PowerBI) experience
- Have experience of different flavours of SQL (MySQL, Postgres etc)
- Have experience of Python, PowerShell, Bash
- Have experience of source control (preferably Git)
- Have experience of orchestration options
- Have experience of collaboration tools (e.g. MS Teams / Slack / JIRA)
- Have experience of Agile working methods
Nice-to-have skills and experience
- Communicate effectively, with a friendly, approachable manner
- Collaborate with / challenge / assist HEE staff to identify, develop and deploy best practice approaches to data warehousing
- Work using our own agile project management approach, taking independent responsibility for significant work
- Work with analysts to assist with data set specifications and the formulation of data models for data set representation in the data warehouse.
- Assess analysts' abilities to conduct their own on-boarding activities, configuring jobs and automation, identifying suitable data sets and providing training as appropriate
- Support process design and maintain documentation, including training manuals / user guidance
- Work within a healthcare domain with awareness of maintaining confidentiality and implementing data protection legislation / information governance requirements
- Identify and manage / report risks