Job Introduction
As a Data Engineer, you will be welcomed into a dynamic and inclusive Finance and Corporate Services team reporting into the Business Intelligence Manager and as a pivotal member of the Business Intelligence Team.
The Data Engineer will be responsible for enabling stakeholders to better report on the performance of the IOPC and the complaints system. The Data Engineer will play a pivotal role and have a hands-on approach to maintain and improve the Enterprise Data Warehouse (EDW) and all other BI capabilities, including reporting.
We'll assess you against these Level 3 behaviours during the selection process:
- Changing & Improving
This vacancy is using Success Profiles, to find out more, please click here.
Throughout the recruitment process we will also assess your Experience, Strengths, Technical skills and Values. As part of the application process, you will be asked to complete a statement of suitability based on the essential criteria. For canddiates shortlisted, you will be suitably informed of the behavious assessed at the next stage.
Anticipated assessment and interview dates are 29th July 2024 and onwards
#IND
Main Responsibility
- 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
Essential Experience
- Hands-on experience of SQL, and BI platforms, such as Power BI, SSRS and Report Builder. Familiarity with the Azure platform.
- 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.
- 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.
- Ability to work collaboratively as part of a team, but confident to work independently when required.
- Communication skills.
- Positive can-do attitude and flexibility of approach.
Desirable
- Experience of working with outsourced IT service delivery teams and awareness of ITIL incident and problem management principles.
- Familiarity and awareness of case management systems and working knowledge of one or more of the IOPC’s corporate applications such as SharePoint.
- 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.
- Knowledge of Python.
Successful candidates will need to undergo Security Check (SC) clearance as a minimum requirement for this appointment. Please note that SC Clearance requires 5 years’ continuous residency in the UK.
National security vetting: clearance levels - GOV.UK (www.gov.uk)
Reasonable Adjustments
- Extra time for presentations or interview questions
- Formatting changes such as colours for text or background on written assignments
- Questions presented in writing during interviews
If you require any reasonable adjustments to our recruitment process, please email campaigns@policeconduct.gov.uk
Package Description
- 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
- Civil Service maternity leave package
- PAM employee assistance programme
- Access to Civil Service Sports Council (CSSC) membership
- Cycle to work scheme
- Opportunity to enjoy the latest home and electronics in a more affordable way provided by Vivup
- Car Leasing Scheme
- Staff networks focused on each of the protected characteristics – run for staff, by staff: Enable Network, Welsh Network, Pride and LGBTQI+ Network, Sex and Family Network, Race, Religion and Belief Network
- Learning and development tailored to your role An environment with flexible working options A culture encouraging inclusion and diversity behaviours
Additional Information:
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.
Any move to the Independent Office for Police Conduct from another employer will mean you can no longer access childcare vouchers. This includes moves between government departments. You may, however, be eligible for other government schemes, including Tax Free Childcare. Determine your eligibility at https://www.childcarechoices.gov.uk
Emotional Consideration:
In performing this role, you may have occasional exposure to distressing material which will likely be impactful, traumatic and challenging. Given the nature of the work, it is also possible that you will have contact with individuals who are experiencing extreme distress. The IOPC recognises this and offers all staff a range of wellbeing provisions, including TRiM (Trauma Risk Management) peer-to-peer support, a dedicated Wellbeing Advisor, and access to free confidential counselling. All staff are strongly encouraged to proactively access and engage with the support available. If you would like to speak about this element of the role with somebody already doing similar work at the IOPC, please contact humanresources@policeconduct.gov.uk and this can be arranged.
Rydym yn croesawu ymgeiswyr i ymgeisio am rolau trwy gyfrwng y Gymraeg fel eu dewis iaith.
Hybrid Working:
The IOPC is currently consulting with its consultative bodies about proposed changes to our hybrid working policy which will require all staff to work 20% of their contractual hours at their office base (or another office for business reasons) from 1 September 2024 and increased to 40% from April 2025. Office attendance time includes in-person training, meetings with stakeholders and families, and attending events. We are currently awaiting clarification once the consultation period has come to a close.
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.
Be yourself
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 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.
