As a Data Engineer you will be welcomed into a dynamic and inclusive team working to improve and maintain the IOPC’s BI reporting capacity. The IOPC is on a journey to develop its culture, perspectives and ethos to support the organisation’s core outcomes and this is your opportunity to enter into the varied world of IOPC Business Intelligence, allowing you to develop your mindset and approaches to contribute to improving the police complaints system in England and Wales.
The post holder will report to the Business Intelligence Manager and will join the Business Intelligence Team. The team bring Business Intelligence and Data Warehouse expertise in-house, as part of the continuous development of the Enterprise Data Warehouse (EDW).
They will be responsible for enabling these stakeholders to better report on the performance of the IOPC and the complaints system and make better use of the information it holds or will hold by providing a focussed, hands-on approach to maintaining and improving upon the IOPC’s BI and reporting systems.
The post holder will have the opportunity to learn on-the-job about data warehousing and database administration. This role would suit a professional with experience in Business Intelligence and understanding of Data Warehousing.
We are looking for a team player, with experience of EDW methodologies, SQL, Power BI, who is eager to be part of a reciprocal learning environment.
Given the sensitive nature of the data, the role requires that the successful candidate is prepared to undergo and receive SC clearance.
We'll assess you against these Level 3 behaviours during the selection process:
- Changing and Improving
- Making Effective Decisions
- Communicating and Influencing
- Working Together
- Managing a Quality Service
- Delivering at Pace
This vacancy is using Success Profiles, to find out more, please click here.
Throughout the recruitment process we will assess your Experience, Strengths, Technical skills, Ability and Values. As part of the application process you will be asked to complete four sift stage questions based on the essential criteria.
Anticipated assessment and interview dates are week commencing 27th March 2023.
- Maintain and develop close and collaborative relationships with colleagues, engage with and lead them in constructive communication to discern, negotiate, and prioritise requirements, and translate them into technical code (e.g. SQL, Power BI, SSRS)
- Identify, recommend and implement BI and Data Warehouse (DW) initiatives resulting from the impact of changes to business/counting rules, or existing ETL processes from various data sources.
- write ELT (extract, load, transform) scripts and code to ensure the ELT process performs optimally.
- re-engineer manual data flows to enable scaling and repeatable use.
- Maintain and improve the IOPC’s BI reporting systems capacity and capability by developing and deploying software (code) in support of business requirements and best practice.
- Maintain the document library (version control etc.) and produce the appropriate support and guidance materials.
- Ability to influence key stakeholders on how to make the most of BI tools to better report on IOPC organisational performance, providing them with expert guidance regarding data, processes, and best practice, and enhancing their user experience.
- Supporting administration of Power BI apps and the resolution of problems and incidents relating to the BI platform and EDW
- Managing UAT of changes and additions to BI objects
The Ideal Candidate
- Experience in BI and system analysis and understanding of data warehousing methodologies, such as Data Vault, Snowflake and Star Schemas, and ability to translate technical BI concepts into business terms for user and super-users
- Hands-on experience of BI platforms, such as Power BI, SSRS and Report Builder, of writing languages such as SQL and Python, and familiarity with the Azure platform
- Familiarity and awareness of case management systems and working knowledge of one or more of the IOPC’s corporate applications such as SharePoint or Trim
- Experience of working with outsourced IT service delivery teams and awareness of ITIL incident and problem management principles
- Excellent listener, with the ability to elicit requirements from key stakeholders, analysing and translating these into new production code according to time and quality factors. Strong customer focus and experience of building strong working relationships with stakeholders and end users
- Experience of working in a secure environment
- Awareness of the legal issues relating to IS/IT e.g. Data Protection, Freedom of Information and Computer Misuse Acts, copyright, intellectual property rights
- Ability to undertake BI systems administration
- Ability to work as part of a team but under their own steam
- Communication skills
- Positive can-do attitude and flexibility of approach.
The IOPC is a diverse and inclusive workplace and we want to help you demonstrate your full potential whatever type of assessment is used. We are open to providing you with the tools you need to succeed, from extra time to formatting changes, to name a mere few. If you require any reasonable adjustments to our recruitment process, please email firstname.lastname@example.org
- 27.5 days paid annual leave (increasing with service to 32.5 days)
- Options to carry over, buy or sell annual leave
- Civil Service pension
- PAM employee assistance programme
- Access to Civil Service Sports Council (CSSC) membership
- Staff networks focused on each of the protected characteristics – run for staff, by staff
- Learning and development tailored to your role
- An environment with flexible working options
- A culture encouraging inclusion and diversity behaviours
The IOPC is not eligible to participate in the Civil Service transfer process, therefore successful candidates will not be able to transfer to the IOPC on their existing terms and conditions.
The IOPC does not participate in the UK Visa Sponsorship Scheme therefore, candidates will have to provide evidence of their Right to Work in the UK if offered a role with us.
This role is exempt from the Rehabilitation of Offenders Act 1974, therefore a standard Disclosure and Barring Service (DBS) check will be carried out for the successful candidate during the pre-employment process.
Due to high volume of applicants we reserve the right to close the application early. Applicants are encouraged to submit their application as soon as possible
About the Company
As a completely independent organisation, the IOPC seeks to uphold the rights of the public and investigate the most serious matters, including deaths following police contact, to promote learning and influence change in policing. The IOPC is an organisation steeped in history, influenced by significant figures such as Stephen Lawrence and Sir William Macpherson. We are looking for people to uphold our core values, and in return we will give you a supportive and inclusive work environment to flourish in.
The IOPC is committed to promoting equality and valuing diversity in everything we do. Our vision is to be, and to be seen as, a leader in inclusive employment and services, demonstrating this ethos in everything that we do.
- As a silver standard Stonewall employer, we continue to commit to being a LGBTQ+ employer through the work of our Pride LGBTQ+ Staff Network, creating welcoming environments for lesbian, gay, bi and queer people.
- We are pleased to share that we are a signatory of the Business in the Community Race at Work Charter. The Charter is composed of five calls to action for leaders and organisations across all sectors.
- Being a Disability Confident employer, the IOPC is dedicated to removing the barriers for disabled people to thrive in the workplace.
- Our Staff Networks are constantly working to make the IOPC the leaders of inclusive employment, from our Allyship Programme to Operation Hotton, to Welsh Language Standards and our Know the Line Policy, we are constantly seeking new ways to create an environment for all to develop and thrive.
This role offers flexible locations, however, there is an expectation to attend your chosen office. Details can be discussed at the interview with the hiring manager.