Associate Data Engineer

As an Associate Data Engineer, with a specialization in Power 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., 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 to comply with all Health and Safety regulations in accordance with the Warwickshire Police Health and Safety Policy.

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

Knowledge: Educated to degree level or with equivalent experience. Proficiency in Power BI development, including DAX (Data Analysis Expressions). Familiarity with data modelling concepts and best practices. Basic knowledge of SQL for data extraction and transformation.

Desirable

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

Desirable

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.

/*generated inline style */

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.