Data Engineer (MH101)Methods

Engineering:

• Working with other members of the delivery team across a mix of large and small projects and be responsible for translating data into valuable insights that inform decisions for small to large transformation projects and programmes.
• Working with other members of the delivery team you will be responsible for identifying and using the most appropriate analytical techniques, developing fit-for-purpose, resilient, scalable and future-proof data services that meet user needs and design and write and iterate code from prototype to production-ready.
• Communicating effectively across organisational, technical and political boundaries to understand the context and how to make complex and technical information and language simple and accessible for non-technical audiences.

• Creating effective data visualisation, appropriate to the audience.
• Working with the Lead Data Engineer to support the growth and development of the team.
• Aware of, and keep up to date with advances in digital analytics tools and data manipulation products.
• Collecting, collating, cleansing, synthesising and interpreting data to derive meaningful and actionable insights.
• Understanding of how to expose data from systems (for example, through APIs), link data from multiple systems and deliver streaming services.

• Producing data models and have an understanding of where to use different types of data models.
• Provide training, support and mentoring to a team of Data Engineers and helping to grow the team.
• Ensuring that risks associated with deployment are adequately understood and documented.

Skills & Experience

Essential

• Experience of creating PowerBI solutions and dashboards from row level data including data structure optimisation through to visualisation and dashboard creation.
• Strong T-SQL Development including debugging & troubleshooting.
• Experience in SQL Server Integration Services (SSIS).

• Solid Relational Database design skills with an eye for performance optimisation.
• an ability to translate business requirements into technical specifications.
• Attention to detail and ability to QA own and other team member's work.
• Good experience with ETL

• Infrastructure, Azure Data Factory / SSIS, SQL (On-prem/Cloud).

• Good experience with Analytical/Reporting

• SQL (On-prem/Cloud), Analysis Services / Tabular Data Model, Power BI/Tableau/T-SQL.

• Understanding of analytical tools; you are numerate.

Desirable

• Experience with NoSQL type environments, Data Lakes, Lake-Houses (Cassandra, MongoDB or Neptune).
• Have experience with Python, Scala or Java.
• Have cloud based experience, preferably with AWS and/or Azure.
• Knowledge of statistics principles necessary to interpret data and apply models. For example, knowledge of errors and confidence intervals to understand whether a relation seen in the data is real.
• Exposure to high performing, low latency or large volume data systems (i.e. 1 billion+ records, terabyte size database).

• Working within a continuous integration environment with automated builds, deployment and unit testing.
• Exposure to iterative/agile development methodologies such as SCRUM.
• Experience of working in a consultancy.

Additional

This role will require you to have or be willing to go through Security Clearance. As part of the onboarding process candidates will be asked to complete a Baseline Personnel Security Standard; details of the evidence required to apply may be found on the government website Gov.UK. If you are unable to meet this and any associated criteria, then your employment may be delayed, or rejected. Details of this will be discussed with you at interview.