Remote Data Engineer — Power BI & Data Pipelines

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

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.