Overview

Associate Data Engineer

Permanent 

Full Time

Leek Wootton

Grade G (£43,668.00 – £49,716.00)

 

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.

 

Main Responsibilities:

  1. Work with the Data Engineer to ensure the data and data flows are aligned with the enterprise and data architecture principles.
  2. Implement data collection pipelines aligned to business requirements.
  3. Understand data from various sources (databases, APIs, flat files)
  4. Maintain existing semantic models.
  5. 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.
  6. Work closely with cross-functional teams to understand reporting requirements.
  7. Translate business needs into effective BI solutions.
  8. Create and maintain Power BI reports, dashboards, and visualizations.
  9. Assist the Data Engineer with implementing data transformations, calculated columns, and measures within Power BI.
  10. Ensure data accuracy, consistency, and reliability in Power BI.
  11. Collaborate with data analysts to validate results and troubleshoot issues.
  12. Under the direction of the Data Engineer, explore ways to enhance data availability, reliability, and quality.
  13. Work with the Data Engineer and other ICT teams to tune Power BI reports for optimal performance.
  14. Identify and work with others to address bottlenecks in data.
  15. 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

 

Person Specification: 

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.

Before you apply -
Register now and turn on alerts for jobs like this!

  • To apply for this position, receive job notifications and manage your applications, click "Register with Diversity Jobs Group".
  • To apply for this position without registering, click "Apply with Customer".

By registering you agree to our terms and conditions.

Apply with Customer

IMPORTANT: Before applying for this role, please make sure you have the right to work in the country where the role is based. Unless it clearly stipulates within in the job advert above that the hiring company is looking to or able to sponsor applicants it is deemed that the hiring employer will only consider applications from those able to comply with and work in the country where the role is based.