Job Title: Data Engineer
Team: Technology & Innovation
Service: Resources & Commercial Services
Responsible to: Improvement & Performance Manager
Job Summary
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,983 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
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
Creativity & Innovation
Innovate in methods of providing a data service to the business, by recommending new tools, technologies or changes to internal processes that will improve or grow the service overall.
Use own competence and expertise to design reports and analyse data, to ensure the information you give is accurate.
To analyse complex information and present clearly using a variety of methods.
The ability to problem solve and use own initiative.
Be competent in the use of a wide range of ICT products and be able to use own initiative to achieve a high-quality management information service to the company.
Have a flair for report design to produce reports that are clear, easily interpreted and attractive in order to engage the users.
Work with an outline of requirements, investigate, design, plan and implement appropriate robust changes.
Contacts & Relationships
Excellent interpersonal and communication skills required.
The ability to network and establish a good working relationship with customers, suppliers, 3rd party support and key professionals building a network of trust and sharing of innovation.
Daily correspondence at all levels in the company in order to ensure performance data is shared appropriately and understood.
Coordinate tasks with internal and external technical resources, collaborating to achieve the best possible outcome.
Daily contact with team members where complex systems issues are discussed and resolve or escalated.
Daily correspondence at all levels in the company in order to make complex decisions relating to the data we process.
Skills, Competence, 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 Friday 24 October
We are committed to building an inclusive workplace that reflects the diversity of the communities we serve. We welcome applications from individuals of all backgrounds, including those from ethnically diverse communities, disabled individuals, and others who may require workplace adjustments. If you require any support during the application process, please let us know, and we will be happy to assist