Data Architect

We are seeking an experienced Data Architect to support a major public sector infrastructure programme. The successful candidate will focus on enterprise data modelling, reviewing existing data warehouse models, reverse engineering Legacy data structures and improving data documentation across a complex enterprise environment.

This role is suited to a hands-on data modelling specialist who can analyse existing data structures, produce accurate architecture documentation and work collaboratively with technical and enterprise architecture teams., * Review, refresh and maintain existing enterprise data warehouse models.

• Reverse-engineer existing systems and databases to understand data structures, relationships and dependencies.
• Develop and maintain conceptual, logical and physical data models.
• Produce and update entity relationship diagrams, data-flow diagrams and other modelling artefacts.
• Document data structures, metadata, data lineage and relationships between applications and systems.
• Support data cataloguing and map data flows across the enterprise architecture landscape.
• Maintain modelling standards, version control, technical documentation and user guidance.
• Support data governance, data standards, metadata management and architecture assurance.
• Work with technical architects, enterprise architects and delivery teams to validate data models against business and technical requirements.
• Identify inconsistencies in existing models and recommend improvements to data architecture documentation.
• Contribute to data design reviews and ensure alignment with enterprise architecture principles.

• Strong experience as a Data Architect, Enterprise Data Architect or Data Modeller.
• Hands-on experience with data modelling tools such as Sparx Enterprise Architect, ERwin or SAP PowerDesigner.
• Strong understanding of conceptual, logical and physical data modelling.
• Experience reverse-engineering existing databases, Legacy systems or data warehouse models.
• Experience reviewing, updating and documenting complex enterprise data models.
• Knowledge of data governance, metadata management, data cataloguing and data lineage.
• Experience creating data dictionaries, entity relationship diagrams, data-flow diagrams and technical documentation.
• Understanding of data standards, data quality and architecture assurance.
• Ability to translate complex technical data structures into clear documentation for technical and business stakeholders.
• Experience working in large, complex organisations, ideally within government, public sector, infrastructure, construction, financial services, energy or telecommunications.
• Strong communication, analytical and stakeholder-management skills.

Desirable Skills

• Experience with Orbus iServer or similar enterprise architecture repositories.
• Experience working with enterprise data warehouses and complex Legacy data environments.
• Familiarity with master data management (MDM) and enterprise metadata repositories.
• Knowledge of Agile delivery environments and data architecture standards.