Data Architect / Physical Modeller - OUTSIDE IR35 - Remote
This role is part of the PDM (Physical Data Modelling) 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 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 client 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.
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
Data Architect / Physical Modeller - OUTSIDE IR35 - Remote
Damia Group Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept our Data Protection Policy which can be found on our website.
Please note that no terminology in this advert is intended to discriminate on the grounds of a person's gender, marital status, race, religion, colour, age, disability or sexual orientation. Every candidate will be assessed only in accordance with their merits, qualifications and ability to perform the duties of the job.
Damia Group is acting as an Employment Business in relation to this vacancy and in accordance to Conduct Regulations 2003