Enterprise Data Architect

We are seeking an experienced Enterprise Data Architect with a strong background in data modelling, enterprise data warehousing, and modern cloud data platforms. You will play a key role in designing scalable enterprise data architectures, defining target-state data models, and supporting the transition from traditional data warehouses to modern Lakehouse solutions.

Working closely with business stakeholders, architects, and engineering teams, you will ensure data solutions are aligned with business objectives while promoting strong governance, quality, and scalability, * Design and maintain conceptual, logical, and physical enterprise data models.

• Develop enterprise Data Warehouse architectures using industry best practices.
• Design dimensional models using Kimball methodologies, including star schemas, fact and dimension tables, conformed dimensions, and data marts.
• Apply Inmon Corporate Information Factory (CIF) principles to enterprise data warehouse design where appropriate.
• Define enterprise information models and business data models.
• Analyse, rationalise, and modernise complex legacy data models.
• Develop target-state enterprise data architectures and migration roadmaps.
• Define data governance standards, business glossaries, metadata, and data ownership frameworks.
• Perform data mapping, data lineage analysis, and impact assessments.
• Support master data, reference data, and metadata management initiatives.
• Drive data quality assessments and improvement programmes.
• Design analytical data structures that support business intelligence and reporting.
• Collaborate with engineering teams on scalable ELT/ETL architectures and modern data integration patterns.
• Support migration from traditional enterprise data warehouses to modern cloud-based analytical platforms.

• Minimum 7 years’ experience in enterprise data architecture, data modelling, and data warehouse design.
• Strong expertise in conceptual, logical, and physical data modelling.
• Extensive experience designing enterprise Data Warehouse solutions.
• Excellent knowledge of Kimball dimensional modelling, including:
• Star schema design
• Fact and dimension modelling
• Conformed dimensions
• Data marts
• Good understanding of Inmon Corporate Information Factory (CIF) architecture.
• Experience designing enterprise information and business data models.
• Strong experience analysing and transforming legacy data architectures.
• Experience creating enterprise data architecture strategies and migration roadmaps.
• Strong understanding of:
• Master Data Management (MDM)
• Reference Data Management
• Metadata Management
• Experience with data mapping, lineage analysis, and impact assessments.
• Experience implementing data governance frameworks and data quality initiatives.

Modern Data Platform Experience

• Experience designing Lakehouse architectures.
• Experience with Microsoft Fabric or comparable modern cloud data platforms.
• Good understanding of Delta Lake architecture.
• Experience designing Bronze, Silver, and Gold data layers.
• Experience with modern ELT/ETL architecture and data integration patterns.
• Experience supporting migration from traditional enterprise data warehouses to cloud-based analytical platforms.