- Experience of database design and data modelling for data warehouse / big data environments.
- Experience understanding user requirements; understanding data sources and creating data models.
- Knowledge of data architecture concepts / technologies e.g. data warehouse, data lakes, big data platforms.
- Experience of developing data solutions on Oracle, Cloudera or Horton Works platforms.
- Hands on experience of Erwin or comparable modelling software.
- Experience of one or more programming languages (SQL, PL\SQL, python, scala).
Roles and Responsibilities:
- Translate business requirements to ensure they are clear and robust, and can be transformed into effective data models;
- Shape solutions in a fit for purpose way; following the agreed principles and contribute to the overall Data Engineer Development lifecycle;
- Perform data profiling and quality measurements;
- Identify, manage resolve issues preventing the delivery or continuous development of products;
- Collaborate across teams and liaise with Senior Data Engineers and Technical Architects to investigate technical solutions;
- Responsible for maintaining the support and implementation of continuous improvement to Data Engineering standards;
- Provide coaching and mentoring to colleagues and peers: support the growth of the team, by keeping abreast of market and industry trends, and sharing knowledge and experience with the rest of the team;
- Supporting the growth of the team, by keeping abreast of market and industry trends, and sharing knowledge and experience with the rest of the team.
- Development of complex data models for new and existing data sources to provide accessible and reusable data for DWP, other Government Departments, and Private Sector Partners;
- Contribute to the overall Data Engineering Development Lifecycle Process.
We'll assess you against these behaviours during the selection process:
Changing and Improving
Managing a Quality Service
We'll assess you against these technical skills during the selection process:
Communicating, Analysis & Insight
- Learning and development tailored to your role
- An environment with flexible working options
- A culture encouraging inclusion and diversity
- An employer pension contribution of up to 27%
- A generous annual leave allowance
Existing Civil Servants who secure a new role on lateral transfer should maintain their current salary.
Existing Civil Servants who gain promotion may move to the bottom of the next grade pay scale or 10% increase in salary whichever would be the greater. Only in very few circumstances (where there have been exceptional skills demonstrated which are in limited supply for example) may existing Civil Servants be able to negotiate their starting salary if the role has been advertised externally, prior to accepting the post.