Job summary
The Data Warehouse (Advanced-Adastra) Developer role is key to supporting the IUEC delivery of operational reporting for London Ambulance Service. The role sits within the Business Intelligence & Analytics directorate where you will be involved in all aspects of development and support within the 111/IUC data warehousing context. It is imperative therefore that you must have at least 5 years' experience in the development and maintenance of the Advanced/Adastra data warehouse environment. You will be a key player in the directorate, supporting the organisation by maintaining platforms for reporting data. This will involve working closely with IM&T and operational colleagues, therefore a strong team working and relationship development and management skillset is also required.
Main duties of the job
An exciting opportunity has arisen for a substantive post as a Data Warehouse (Advanced-Adastra) Developer with 5 years Advanced and Adastra experience to help deliver the expansion of our data architecture and facilitate more advanced analytics. We are looking for a well-rounded candidate who is pro-active and committed, with the ability to effectively communicate with members of staff across the organisation and build key working relationships. The role will require knowledge and proficiency in the following areas:
- Full Microsoft BI Stack (SSIS, SSAS, SSRS)
- Expert level SQL coding
- Database analysis skills
- Data visualisation and reporting (Power BI, Tableau and Visual Studio)
- Software development methodologies
- 5 years Advanced and Adastra experience
- Experience in Avaya (Desirable)
About us
London Ambulance Service NHS Trust is the busiest ambulance Trust in the UK. We are seeking someone who will fit with the Trust values of being caring, respectful and supports teamwork. The Data Services team is newly established in the organisation and central to strategic and operational planning. We are part of the wider Business Intelligence directorate who together cover data quality, business intelligence, and forecasting and planning for urgent and emergency healthcare services. The directorate is key to ensuring that LAS is a data driven organisation, with decisions being informed by timely and high quality analysis.
Annual leave starts at 27 days rising to 33 days, plus bank holidays, in line with Agenda for Change. Employees can access Blue Light (emergency services) discounts as well as NHS discount schemes.
Job description
Job responsibilities
The Data Warehouse (Advanced-Adastra) Developer post comes with a recruitment and retention premium of 30%.
An electronic copy of the job description and main responsibilities for this post has been attached in the Document section
Job description
Job responsibilities
The Data Warehouse (Advanced-Adastra) Developer post comes with a recruitment and retention premium of 30%.
An electronic copy of the job description and main responsibilities for this post has been attached in the Document section
Person Specification
Qualifications
Essential
- Educated to Master's Degree level in a related subject or equivalent extensive experience and expertise in business intelligence systems development in a work environment
- GCSE Mathematics or equivalent
Experience
Essential
- Extensive experience of specifying and designing Advanced/Adastra information systems for use within and outside the information department
- Extensive experience of using, creating and developing relational databases in SQL Server in a work environment, including designing and building highly complex database systems, creating highly complex queries using Structured Query Language to interrogate the data, creating procedures and reports
- Extensive experience of the lifecycle of software development, including the process of progressing a project through five development stages: Specification, Development, System Test, User Acceptance Test and Live
- Experience in Performance Tuning and Optimisation (PTO), using native monitoring and troubleshooting tools
- Extensive experience with Database Administration for MSSQL Server
- Extensive experience of developing business intelligence applications
- Extensive experience of developing ETL packages using SSIS
- Extensive experience of developing OLAP cubes using SSAS
- Extensive experience of developing reports using SSRS
- Experience in troubleshooting and resolving database problems
- Experience with backups, restores and recovery models
- Extensive experience of working with highly complex, conflicting and contentious information
- Experience of managing staff and being a role model for staff
- Experience of using Power BI
Desirable
- Experience in developing applications in Windows forms, ASP.net, MVC and knowledge of C#
- Experience of Avaya telephony systems
- Experience of working in an agile environment
- Microsoft Certified Professional certification in a relevant subject or proven equivalent experience
- A Level mathematics or equivalent
- Experience of working with sensitive / confidential information
Knowledge
Essential
- Extensive knowledge of SSIS
- Extensive knowledge of SSAS
- Extensive knowledge of SSRS
- Extensive knowledge of Relational Database Management Systems (RDBMS)
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server
- General knowledge of computer hardware and software and constant updating of that knowledge
- Knowledge of database development methodologies
- Extensive knowledge of SQL server and T-SQL including programming and database and server administration
- Extensive knowledge of ETL (Extract, Transform, Load) techniques
- Knowledge of use of web services
- Extensive knowledge of Windows OS, Windows server
- Knowledge of Microsoft Office suite
- Ability to write information system specifications and documentation to an agreed standard
- Ability to maintain an effective overview of potential technical risks before they become issues
- Ability to tailor information systems to meet users requirements
- Accurate with attention to detail
- Ability to concentrate intensely when carrying out detailed analysis over sustained periods
- Excellent written and oral communication skills
- Excellent interpersonal skills, including ability to negotiate and persuade
- Ability to identify and grasp highly complex technical issues arising from business plans and user specifications and able to communicate these issues to staff in a clear unambiguous way
- Flexible with an ability to adapt to rapidly evolving technology
- Ability to use different influencing skills appropriate to the outcomes of findings, especially when findings do not support initial assumptions or expectations
- Ability to work under pressure
- Ability to analyse complex and sometimes conflicting data sets, with a logical approach
- Highly organised and logical thinker
- Strong analytical skills
- Diplomatic and tactful
- Advanced keyboard skills, including ability to input a large amount of data quickly and accurately
- Ability to manage / organise own and development team's workload and plan work according to changing priorities and deadlines
- Ability to diagnose and identify system efficiency improvements or areas for innovation based on current service requirements.
- Able to interpret and implement local and national Information Management strategies
- Able to apply creative problem solving and ideas generation to large-scale and complex business critical IT issues
- High level of personal motivation with the ability to work independently using own initiative, or as part of a team
- Ability to make own decisions on how issues should be resolved and how results are best achieved, implementing those decisions as appropriate
- Ability to delegate and supervise the work of others within the department
- Ability to promote and deliver a customer focused service
- A demonstrable track record of reliability and delivering on commitments and objectives
Person Specification
Qualifications
Essential
- Educated to Master's Degree level in a related subject or equivalent extensive experience and expertise in business intelligence systems development in a work environment
- GCSE Mathematics or equivalent
Experience
Essential
- Extensive experience of specifying and designing Advanced/Adastra information systems for use within and outside the information department
- Extensive experience of using, creating and developing relational databases in SQL Server in a work environment, including designing and building highly complex database systems, creating highly complex queries using Structured Query Language to interrogate the data, creating procedures and reports
- Extensive experience of the lifecycle of software development, including the process of progressing a project through five development stages: Specification, Development, System Test, User Acceptance Test and Live
- Experience in Performance Tuning and Optimisation (PTO), using native monitoring and troubleshooting tools
- Extensive experience with Database Administration for MSSQL Server
- Extensive experience of developing business intelligence applications
- Extensive experience of developing ETL packages using SSIS
- Extensive experience of developing OLAP cubes using SSAS
- Extensive experience of developing reports using SSRS
- Experience in troubleshooting and resolving database problems
- Experience with backups, restores and recovery models
- Extensive experience of working with highly complex, conflicting and contentious information
- Experience of managing staff and being a role model for staff
- Experience of using Power BI
Desirable
- Experience in developing applications in Windows forms, ASP.net, MVC and knowledge of C#
- Experience of Avaya telephony systems
- Experience of working in an agile environment
- Microsoft Certified Professional certification in a relevant subject or proven equivalent experience
- A Level mathematics or equivalent
- Experience of working with sensitive / confidential information
Knowledge
Essential
- Extensive knowledge of SSIS
- Extensive knowledge of SSAS
- Extensive knowledge of SSRS
- Extensive knowledge of Relational Database Management Systems (RDBMS)
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server
- General knowledge of computer hardware and software and constant updating of that knowledge
- Knowledge of database development methodologies
- Extensive knowledge of SQL server and T-SQL including programming and database and server administration
- Extensive knowledge of ETL (Extract, Transform, Load) techniques
- Knowledge of use of web services
- Extensive knowledge of Windows OS, Windows server
- Knowledge of Microsoft Office suite
- Ability to write information system specifications and documentation to an agreed standard
- Ability to maintain an effective overview of potential technical risks before they become issues
- Ability to tailor information systems to meet users requirements
- Accurate with attention to detail
- Ability to concentrate intensely when carrying out detailed analysis over sustained periods
- Excellent written and oral communication skills
- Excellent interpersonal skills, including ability to negotiate and persuade
- Ability to identify and grasp highly complex technical issues arising from business plans and user specifications and able to communicate these issues to staff in a clear unambiguous way
- Flexible with an ability to adapt to rapidly evolving technology
- Ability to use different influencing skills appropriate to the outcomes of findings, especially when findings do not support initial assumptions or expectations
- Ability to work under pressure
- Ability to analyse complex and sometimes conflicting data sets, with a logical approach
- Highly organised and logical thinker
- Strong analytical skills
- Diplomatic and tactful
- Advanced keyboard skills, including ability to input a large amount of data quickly and accurately
- Ability to manage / organise own and development team's workload and plan work according to changing priorities and deadlines
- Ability to diagnose and identify system efficiency improvements or areas for innovation based on current service requirements.
- Able to interpret and implement local and national Information Management strategies
- Able to apply creative problem solving and ideas generation to large-scale and complex business critical IT issues
- High level of personal motivation with the ability to work independently using own initiative, or as part of a team
- Ability to make own decisions on how issues should be resolved and how results are best achieved, implementing those decisions as appropriate
- Ability to delegate and supervise the work of others within the department
- Ability to promote and deliver a customer focused service
- A demonstrable track record of reliability and delivering on commitments and objectives
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Additional information
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
