Associate Data Engineer

Warwickshire Police; Leek Wootton; On-site; GBP 45,000 - 65,000; Full time

Job summary

Warwickshire Police are seeking an Associate Data Engineer with a focus on Power BI to build and maintain data pipelines and reporting solutions across various data stores. You will collaborate with data analysts and stakeholders to ensure accessible, high-quality data.

You will work under the Data Engineer to develop semantic models, transform data, and craft Power BI reports and dashboards. Experience with Azure data services and police data systems is advantageous.

Qualifications

• Educated to degree level or with equivalent experience.
• Proficiency in Power BI development, including DAX.
• Familiarity with data modelling concepts and best practices.
• Basic knowledge of SQL for data extraction and transformation.
• Knowledge of Police Systems (NEC Connect / Niche RMS).
• Knowledge of Power Query M.
• Basic knowledge of Databases and Data lakes in the Azure environment.
• Coding in a professional capacity.
• Interest in advanced data approaches (big data, AI, Python, Azure Data Factory).

Responsibilities

• Work with the Data Engineer to ensure data and data flows align with architecture principles.
• Implement data collection pipelines aligned to business requirements.
• Understand data from various sources (databases, APIs, flat files).
• Maintain existing semantic models.
• Assist in developing new semantic models integrating multiple sources.
• Translate business needs into effective BI solutions.
• Create and maintain Power BI reports, dashboards, and visualizations.
• Assist in implementing data transformations, calculated columns, and measures in Power BI.
• Ensure data accuracy, consistency, and reliability in Power BI.
• Collaborate with data analysts to validate results and troubleshoot issues.
• Explore ways to enhance data availability, reliability, and quality.
• Tuning Power BI reports for performance.
• Address bottlenecks in data.

Skills

Analytical skills

Inter-personal skills

Multi-disciplinary teamwork

Detail-oriented

Willing to learn

Education

Degree level education

Equivalent experience

Tools

Power BI

DAX

Power Query M

SQL

Azure

ETL tools

NEC Connect

Niche RMS

Databases / Data lakes

Job description

Please note, if this is a paid role and the role is part time then the salary quoted will be pro rata based on the hours worked per annum.

37

Competency and value framework (CVF) level? 2

24/09/2026, 12:00

Permanent

Full Time

Leek Wootton

As anAssociate Data Engineer,with a specialization inPower BI, your primary responsibility will be to build and maintain data pipelines and reporting solutions using Power BI into a variety of data stores e.g. databases and data lakes. You will work closely with data analysts, and business stakeholders to ensure data accessibility and quality.

Main Responsibilities:

• Work with the Data Engineer to ensure the data and data flows are aligned with the enterprise and data architecture principles.
• Implement data collection pipelines aligned to business requirements.
• Understand data from various sources (databases, APIs, flat files)
• Maintain existing semantic models.
• Under the direction of the Data Engineer, assist in developing new semantic models that integrate data from multiple sources e.g. flat files, databases, and data lakes.
• Work closely with cross-functional teams to understand reporting requirements.
• Translate business needs into effective BI solutions.
• Create and maintain Power BI reports, dashboards, and visualizations.
• Assist the Data Engineer with implementing data transformations, calculated columns, and measures within Power BI.
• Ensure data accuracy, consistency, and reliability in Power BI.
• Collaborate with data analysts to validate results and troubleshoot issues.
• Under the direction of the Data Engineer, explore ways to enhance data availability, reliability, and quality.
• Work with the Data Engineer and other ICT teams to tune Power BI reports for optimal performance.
• Identify and work with others to address bottlenecks in data.
• All members of the workforce are tocomply withall Health and Safety regulationsin accordance withthe Warwickshire Police Health and Safety Policy.

Special Conditions:

Potential exposure to disturbing/unpleasant images or tasks relating to serious sexual offences etc

Person Specification:

Knowledge:

• Educated to degree level or with equivalent experience.
• Proficiency inPower BIdevelopment, including DAX (Data Analysis Expressions).
• Familiarity with data modelling concepts and best practices.
• Basic knowledge of SQL for data extraction and transformation.
• Knowledge of Police Systems (NEC Connect / Niche RMS)
• Knowledge of Power Query M
• Basic knowledge of Databases and Data lakes in the Azure environment
• Coding in a professional capacity
• An interest/knowledge in more advanced data approaches linked to big data, AI, and Machine Learning e.g. NoSQL, Python, Azure Data Factory

Experience:

• Min. 3-5 years’ experience working with data and/or analysis
• Understanding of PowerBI DAX
• Understanding of Data Modelling best practices
• Troubleshooting data and code problems
• Using ETL tools in a support capacity
• Using Reporting tools in a support capacity
• Following Technical Design and Support processes
• Integration with Police systems (NEC Connect / Niche RMS)
• Understanding of Power Query M
• Understanding and use of SQL
• Designed or Supported ETL Systems
• Designed or Supported Reporting Systems
• Experience of working with Microsoft Azure platform
• Experience of working with police data or in a secure setting

Key Skills:

• Strong Software and Data skills
• Ability and desire cross train in new software tools and technologies
• Passion for helping others make data driven decisions
• Excellent inter-personal skills; ability to work as part of multi-disciplinary team with supervision and manage multiple tasks at once
• A passion for learning and able keep abreast of the latest developments in data technology.
• Strong analytical skills and attention to detail.
• Willing to learn and adapt to new technologies.

We want our organisation to be as diverse as the community it serves. We welcome applicants from all sections of the community.

You will be required as part of Warwickshire Police recruitment process to successfully complete vetting and credit checks.

We support the “Happy to talk flexible working” campaign, which aims to encourage uptake of flexible working for individuals, the flexible working options that may be considered for this role include;

Compressed hours and Remote Working.

Why work for Warwickshire Police?

Warwickshire Police has gained a reputation as a pioneering and innovative force, responsible for policing a large diverse, multi-cultural population.
If you are looking for a fresh challenge which offers a genuine opportunity to make a real difference to people’s lives, variety and the chance to broaden your experience, then Warwickshire Police is the force for you.

Equality, diversity and inclusion

Warwickshire Police are committed to equality, diversity and inclusion.
We are working hard to increase diversity and inclusion within the Constabulary, where communities are under-represented, including those from minority ethnicity communities, people of all ages, abilities, faiths, religions and gender, LGBTQ+ communities and those from other disadvantaged or marginalised backgrounds, who share our values and wish to make a difference to the communities we serve.
All applications will be treated on merit, based on the evidence provided in your application and suitability for the role you have applied for.

Recruitment and Selection Policy

Internal applicants who are at risk of redundancy or in need of redeployment and pass the selection process, will be offered the role over the remaining internal and external applicants.

Police Barred and Advisory lists

Individuals placed on the Police Barred and Advisory lists will not be considered for employment by the police for a minimum of 5 years from the date of listing in the case of gross misconduct, or 3 years from the date of listing in the case of poor performance.

Vetting and safeguarding

Warwickshire Police are committed to safeguarding and operate safer recruitment processes, to ensure a police service that employees are proud to work for because they feel safe, valued and part of a happy and supportive work environment. All employees and volunteers therefore will be subject to background checks including vetting and references.

Please note, you will require the following detail to complete this application form; NI Number, ID detail, address information, referee information, full employment history including dates and any qualifications you may have attained. You may also be requested to provide photos of any visible tattoos you have. The application system only remains active on a single page for a period of 60 minutes. Please therefore ensure you allow time to complete this fully as part complete pages will not be saved.