JOB DESCRIPTION
Post title: / QlikView DeveloperAcademic Unit/Service: / iSolutions (Operationally Deployed to NETSCC)
Faculty: / PSG
Career pathway: / MSA / Level: / 4
*ERE category: / N/A
Posts responsible to: / Senior QlikView Developer
Posts responsible for: / N/A
Post base: / Office-based (see job hazard analysis)
Job purpose
· To support the Reporting & Business Intelligence Team with the delivery of QlikView applications and other reporting and information services, including database development, SQL-based report writing and information analysis.
· To ensure these activities contribute to the security, reliability and data quality of core business information systems.
· To identify and deliver improvements and enhancements through controlled change management processes to improve the delivery of information services to NETSCC.
· To participate (where required) in NETSCC-wide projects, and to support the continual review of information needs across NETSCC, NIHR and DH whilst also ensuring, accordingly, that existing information related standards and policies are up to date and being met.
· To support the delivery of the NETSCC and NIHR Information Strategies
· To work with other members of the team to deliver a quality service (and provide cover for them), with the objective of allowing the team to continue to meet business needs when other supporting roles are unavailable or require additional capacity to deliver a high priority task.
Glossary:
NETS: NIHR Evaluation, Trials and Studies
NETSCC: NIHR Evaluation, Trials and Studies Coordinating Centre
NIHR: National Institute for Health Research
DH: Department of Health
Key accountabilities/primary responsibilities / % Time /
1. / Gathering reporting requirements from business users. Developing analytical reports and dashboards, including visualisations which meet user requirements and provide them with insights into their area of the NETSCC business or the wider NIHR. Maintain technical documentation associated with your developed solutions / 35%
2. / To work closely with other members of the Reporting & Business Intelligence Team to develop the suite of transactional, management information and decision support reports and dashboards available to the business / 25%
3. / Support NETSCC in capturing the information and reporting needs of users in all areas of the NETSCC business / 10%
4. / Provides production support for developed reports and applications - including working with users to identify and resolve issues / 10%
5. / To contribute to the delivery of the NETSCC and NIHR Information Strategies such that NETSCC is able to maximise business benefits from its information assets, maintain the quality and security of such assets, and respond flexibly to challenges and opportunities. / 10%
6. / Identify data quality issues, investigate the cause and work with business users to implement resolutions. / 5%
7. / Any other duties as allocated by the line manager following consultation with the post holder. / 5%
Internal and external relationships /
· The post holder will be expected to work productively with other iSolutions staff as part of an integrated team, so that NETSCC information management is developed within the University-wide framework appropriately adapted to local needs.
· The post holder will be expected to help establish robust working relationships with suppliers based on clearly defined service levels and standards, working practices and change management procedures. They will work with other staff within NETS programmes to understand their database and information needs and support the team in factoring these into the Information Strategy, business planning and budgeting.
· The post holder will work with external staff, for example at DH or NIHR, to provide information as appropriate and to be aware of DH guidance on matters such as the Data Protection Act.
PERSON SPECIFICATION
Criteria / Essential / Desirable / How to be assessedQualifications, knowledge & experience / Degree or equivalent experience in a technical/numerate subject
Previous project management experience
Advanced knowledge of Microsoft SQL (T SQL) including: stored procedures, triggers, functions
Experienced in delivering end-to-end development of QlikView application design and development including:
· Requirement gathering,
· SQL data modelling,
· QlikView scripting/QVD development,
· QlikView application design,
· Set analysis,
· Testing and sign off process
An understanding of database design.
Proficient user of Microsoft Office applications: Excel, Word, Visio, MS Project / Prince 2 and/or ITIL qualification
Experience of developing with Microsoft BI Products: SSIS, SSAS, SSRS
Experience of development with other Qlik products: QlikSense, NPrinting, GeoQlik and other extension objects
Experience of Dashboard development
Experience of database troubleshooting and query optimisation
Experience of Data Warehousing and ETL (Extract, Transform and Load). / CV, Application and Interview
Planning & organising / Ability to plan and manage own work to meet challenging deadlines
Ability to prioritise tasks and client requirements in line with the wider team and NETSCC as a whole
Accurate, thorough, analytical approach and attention to detail / CV, Application and Interview
Problem solving & initiative / Able to develop understanding of long-standing and complex problems and to apply professional knowledge and experience to solve them.
Ability to identify a business need or opportunity for enhancing the business by the provision of reporting and information
Ability to demonstrate a methodical approach to fault diagnosis and problem resolution / CV, Application and Interview
Management & teamwork / Able to proactively work with colleagues in other work areas to achieve outcomes / Previous experience of mentoring or supervising junior development staff
Able to delegate effectively, understanding the strengths and weaknesses of team members to build effective teamwork / CV, Application and Interview
Communicating & influencing / Excellent oral and written communication skills
Ability to convey technical principles to a non-technical audience
Ability to produce clear technical documentation for systems
Confidence in presenting to a variety of audiences, both internal and external, and at all levels of the organisation / Ability to identify user training requirements and to assist in the development of training materials
Able to present results and put forward recommendations through the provision of advice, briefings, presentations or written reports, to facilitate the interpretation of specific issues/problems and support decision making / CV, Application and Interview
Other skills & behaviours / Methodical, calm and clear-thinking under pressure
Able to work in a pressurised environment, which changes rapidly.
Knowledge of best practice in data and service quality
Strong analytical skills / CV, Application and Interview
Special requirements / This role may occasionally require work outside of normal office hours
Some travel to other sites may be required as part of this role / CV, Application and Interview
JOB HAZARD ANALYSIS
Is this an office-based post?
☒ Yes / If this post is an office-based job with routine office hazards (eg: use of VDU), no further information needs to be supplied. Do not complete the section below.☐ No / If this post is not office-based or has some hazards other than routine office (eg: more than use of VDU) please complete the analysis below.
Hiring managers are asked to complete this section as accurately as possible to ensure the safety of the post-holder.
## - HR will send a full PEHQ to all applicants for this position. Please note, if full health clearance is required for a role, this will apply to all individuals, including existing members of staff.
ENVIRONMENTAL EXPOSURES / Occasionally(<30% of time) / Frequently
(30-60% of time) / Constantly
(> 60% of time)
Outside work
Extremes of temperature (eg: fridge/ furnace)
## Potential for exposure to body fluids
## Noise (greater than 80 dba - 8 hrs twa)
## Exposure to hazardous substances (eg: solvents, liquids, dust, fumes, biohazards). Specify below:
Frequent hand washing
Ionising radiation
EQUIPMENT/TOOLS/MACHINES USED
## Food handling
## Driving university vehicles(eg: car/van/LGV/PCV)
## Use of latex gloves (prohibited unless specific clinical necessity)
## Vibrating tools (eg: strimmers, hammer drill, lawnmowers)
PHYSICAL ABILITIES
Load manual handling
Repetitive crouching/kneeling/stooping
Repetitive pulling/pushing
Repetitive lifting
Standing for prolonged periods
Repetitive climbing (ie: steps, stools, ladders, stairs)
Fine motor grips (eg: pipetting)
Gross motor grips
Repetitive reaching below shoulder height
Repetitive reaching at shoulder height
Repetitive reaching above shoulder height
PSYCHOSOCIAL ISSUES
Face to face contact with public
Lone working
## Shift work/night work/on call duties
NETSCC SQL Reporting Developer (HR5).docx2