Associate Data Engineer

Associate Data Engineer

Permanent

Full Time

Leek Wootton

Grade G (43,668.00 - 49,716.00)

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:

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 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: