Data Architect

Data Architect - Enterprise Data Modelling

Location: Birmingham, West Midlands
Contract Duration: Until March 2027, with potential extension
Working Arrangement: Hybrid - minimum 3 days onsite per week
IR35 Status: Inside IR35

Job Description

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.

Key Responsibilities

• 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.

Essential Skills and Experience

• 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.