Data Engineer: Overall Purpose of Job To be responsible for creating, developing, and supporting the maintenance and rollout of business intelligence solutions; in particular, Power BI. You will work closely with various departments to understand their data needs and provide actionable insights and analysis that drives business decisions. You will have a good understanding of data quality, integrity, modelling, data warehousing, ETL processes and change management and the successful candidate must be proficient in Power Query, DAX and other Power BI tools. Equally, you must have a sound understanding of SQL language to analyse a wide range of data sources. The role will work closely with all areas of the Technology and Innovation team as well as key stakeholders throughout the business. We offer all our employees a great package of benefits too, including: Competitive salary £41,120 which is bench marked against other employers Enrolment on our Aviva pension scheme (9.5% employer contribution) 30 days holiday (plus extra days off for Bank Holidays/Birthdays) Health care scheme Flexible/agile working, plus the option to work from home if your role allows Enhanced maternity/paternity pay Continual professional development including management development. A dedicated health and wellbeing programme (access to a variety of support and free benefits) Time out of work to carry out volunteer opportunities Main Responsibilities Collaborate with stakeholders to understand data requirements and provide accurate and precise solutions. Be inquisitive around the data, understanding how it's collected and challenge where you suspect quality issues. Transform raw data into meaningful insights. Support the maintenance and optimisation of existing Power BI solutions, driving forward it's improvement and rollout. Collaborate with other teams within the business to provide a greater understanding of the data we process and store to inform key decisions. Develop and maintain data orchestration tools, to present data ready for modelling and visualisation. Work closely with colleagues in the Technology & Innovation Team to provide continuous support and rollout of Power BI to the business. Gather, analyse and share reliable information and trends both from internal and external sources. Making observations and recommendations for improving service delivery, customer service and value for money. Provide training and support to end-users. Stay updated with the latest Power BI features and updates. Perform data validation and quality checks. Maintain excellent working relationship with customers, 3rd party support, developers and other key professionals. Proven experience of using data governance and data security practices. Ensuring best practices and industry standards are being adhered to as far as possible ensuring we remain secure and compliant. Experience of business improvement processes and requirements Knowledge, Skill & Experience Required Experience of working to a high standard under pressure and to tight deadlines. Working knowledge of Power BI, DAX, Power query and other Power BI tools is essential. Experience working with many different data sources such as Azure MSSQL, MySQL, Azure Cosmos, Azure Data Lake, Azure OneLake within an enterprise environment. Experience utilising Azure Data Factory and its capabilities for orchestration of ETL and ELT processes. Desirable to have experience of other analytical tools such as Azure Databricks, Azure Synapse Analytics. Experience and knowledge of data governance and compliance including the Data Protection Act and the General Data Protection Regulation. Significant experience in working with data and undertaking complex analysis and reporting. Competent at data manipulation, validation and verification Practical experience of quickly being able to pick up and have a thorough understanding of new technologies. Excellent communication skills and interpersonal skills with the ability to communicate at all levels within the organisation and external agencies. Strong commitment to continual service improvement and delivering quality work at all times. Experience of working on business intelligence projects Excellent organisational skills. Have an overall ICT awareness of software and hardware and skilled in all other general aspects of ICT. Self-motivated individual with the ability to take direction. The ability to openly collaborate with team members. Closing date for applications - Noon Friday 20th December 2024 ADZN1_UKTJ