Data Engineer

at  Independent Office for Police Conduct

JOB SUMMARY

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.

JOB DESCRIPTION

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.

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.

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.

Feedback will only be provided if you attend an interview or assessment.

NATIONALITY REQUIREMENTS

This job is broadly open to the following groups:

• UK nationals
• nationals of the Republic of Ireland
• nationals of Commonwealth countries who have the right to work in the UK
• nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities with settled or pre-settled status under the European Union Settlement Scheme (EUSS) (opens in a new window)
• nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities who have made a valid application for settled or pre-settled status under the European Union Settlement Scheme (EUSS)
• individuals with limited leave to remain or indefinite leave to remain who were eligible to apply for EUSS on or before 31 December 2020
• Turkish nationals, and certain family members of Turkish nationals, who have accrued the right to work in the Civil Service

Further information on nationality requirements (opens in a new window)

MAIN RESPONSIBILITIES

• 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 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.