SQL Developer
Outside IR35
Remote - may be occasion travel to Central London
Role Overview:
We are seeking a skilled and motivated Data Engineer to join our dynamic team. The successful candidate will be responsible for designing, implementing, and optimising data Models and architectures to support our data-driven initiatives. This role requires a strong understanding of data management principles and the ability to work with various database systems and data processing tools.
This role is part of the PDM team responsible for all development and maintenance of the physical data model. This includes management of all the databases that the model resides within and some of the Azure data services (e.g DataBricks) that exist in the ecosystem. The processes and technologies we are using is evolving so there will need to be involved in working with the team to create and adapt designs, assisting the delivery lead with refining team processes.
Key Responsibilities
Key responsibilities will include:
· Perform updates and changes to the physical data model
· Database maintenance and support activities
· Creating and updating Postgres functions (stored procedures)
· Be an SME on the PDM to become a trusted advisor to other teams that have data requirements and translate these into database function(s)
· Collaborate with the PDM Data Architect to improve the PDM and surrounding processes
· Support and mentor members of the physical data model team
· Work with the team to develop issues in Jira that are ready for development
· Working closely with the Logical Data Model (LDM) team on collaborative tasks and helping keep both teams aligned
· Contribution to Data workshops with key stakeholders across business, data and systems areas helping to formalise and document requirements. (Multi-Vendor Environment).
· Development of data architecture and design artefacts aligned to VOA standards.
· Refining of SQL queries and functions to be more performant
· Assisting teams in data migrations activities
· Performing impact analysis on releases to pre-empt any issues these may cause and performing releases post analysis
Job Requirements
Essential skills/experience:
· Minimum 3 years experience with PostgresSQL and pgAdmin
· Strong problem-solving abilities using initiative to find innovative solutions
· Min 3 years’ experience creating and tuning complex SQL queries (e.g. self-referencing hierarchies, KVP structures) including stored functions
· Experience of working with generic/abstract data models
· Minimum 1 year experience with data modelling tools (preferably Sparx)
· Experience creating and maintaining data and design artefacts
· Ability to thrive in a fast-paced environment & work under pressure.
· Experience with working in a multi-vendor environment.
· Experience with MS SQL and/or Oracle an advantage
· GDS