Data Architect / Business Analyst (Brussels)

Data Architect / Business Analyst

Bridge351 is looking for a Data Architect / Business Analyst to join a strategic project for the Comisión Europea.

This role sits at the core of an enterprise data transformation initiative, focused on designing the target Data Warehouse and Lakehouse architecture (Kimball/Inmon methodologies, Microsoft Fabric) and rationalising the current Data Hub/Data Warehouse landscape, complemented by business analysis and stakeholder facilitation activities.

Knowledge and skills:

Data Architecture and Data Modelling (core focus)

• Minimum 7 years of experience in enterprise data architecture, data modelling and data warehouse design.

• Strong expertise in conceptual, logical and physical data modelling.

• Proven experience designing enterprise Data Warehouse solutions.

• Strong knowledge of Kimball dimensional modelling methodologies, including star schemas, fact and dimension modelling, conformed dimensions and data marts.

• Good knowledge of Inmon Corporate Information Factory (CIF) principles and enterprise data warehouse architecture.

• Experience designing enterprise information models and business data models.

• Experience analysing and rationalising complex legacy data models.

• Experience defining target-state enterprise data architectures and migration roadmaps.

• Strong understanding of master data management (MDM), reference data management and metadata management.

• Experience performing data mapping, data lineage analysis and impact assessment.

• Experience defining data governance principles, business glossaries and data ownership models.

• Experience with data quality assessment and data quality improvement initiatives.

• Experience modelling analytical data structures supporting business intelligence and reporting.

Modern Data Platforms

• Experience designing Lakehouse architectures.

• Experience with Microsoft Fabric or comparable modern cloud data platforms.

• Good understanding of Delta Lake architecture and the design of Bronze, Silver and Gold data layers.

• Experience defining data ingestion, transformation and storage patterns for analytical platforms.

• Experience with ELT/ETL architecture and modern data integration patterns.

• Experience supporting migration from traditional data warehouses to cloud-based analytics platforms.

Data Platform Transformation

• Experience analysing legacy data platforms and defining target architectures.

• Experience planning data migration and transition strategies.

• Experience identifying opportunities for data model harmonisation and platform consolidation.

• Experience performing gap analysis and impact assessments.

• Experience working with complex enterprise data ecosystems.

Business Analysis

• Minimum 6 years of experience as a Business Analyst in enterprise data or information management projects.

• Strong experience in business process analysis and requirements engineering.

• Experience facilitating workshops with business and technical stakeholders.

• Experience documenting business capabilities, functional requirements and operating models.

• Strong analytical and problem-solving skills.

Business Architecture and Service Design

• Experience defining business capabilities and service catalogues.

• Experience analysing existing service portfolios.

• Experience defining future operating models.

• Experience developing business cases and cost models.

• Experience supporting governance model definition.

Stakeholder Management

• Strong communication and facilitation skills.

• Experience working with executive management, business owners and technical teams.

Certifications:

• DAMA Certified Data Management Professional (CDMP) is considered a strong asset.

• TOGAF Foundation or Certified is considered a strong asset.

• CBAP (Certified Business Analysis Professional) or equivalent is considered a strong asset.

• Certification in Data Architecture, Enterprise Architecture or Information Management is considered a plus.

Tasks:

Data Analysis and Data Model Design (core deliverable)

• Analyse the existing enterprise data models, metadata and information architecture.

• Analyse the current Data Warehouse and Data Hub schemas, data structures and integration patterns.

• Identify common, shared and system-specific business entities, data domains and subject areas.

• Perform data profiling, data mapping and data lineage analysis.

• Define conceptual, logical and physical enterprise data models.

• Design the target enterprise Data Warehouse architecture following recognised methodologies such as Kimball (Dimensional Modelling) and/or Inmon (Corporate Information Factory), selecting the most appropriate approach for each business domain.

• Design fact and dimension models, conformed dimensions, star schemas and subject-oriented data marts where appropriate.

• Define the target Lakehouse architecture using Microsoft Fabric, including the organisation of Bronze, Silver and Gold layers based on Delta Lake principles.

• Define data ingestion, transformation and storage patterns supporting both analytical and operational reporting workloads.

• Define master data, reference data and business glossary structures.

• Identify opportunities for data model harmonisation, simplification and standardisation across the Data Warehouse and Data Hub.

• Define data quality, data governance and metadata management principles.

• Produce enterprise data architecture, modelling and design documentation.

Data Hub Rationalisation and Cost Model

• Analyse existing Data Hub services.

• Review custom developments and temporary solutions.

• Assess operational complexity.

• Analyse service usage and client dependencies.

• Support rationalisation of services.

• Define future operating model.

• Develop service costing approach.

• Support governance model definition.

• Produce recommendations for long-term sustainability.

Migration Strategy and Transition Planning

• Define migration principles.

• Analyse migration dependencies.

• Identify migration risks and constraints.

• Define transition architecture.

• Develop phased migration roadmap.

• Support prioritisation of migration activities.

• Define coexistence strategy where applicable.

• Support change impact assessment.

• Contribute to implementation planning.

Current State Assessment and Business Analysis

• Analyse business and functional requirements.

• Analyse the current Data Warehouse architecture and data model.

• Analyse the current Data Hub architecture and data model.

• Identify business processes supported by each platform.

• Identify business stakeholders and data owners.

• Analyse existing client usage and service consumption.

• Identify custom implementations, workarounds and technical debt.

• Facilitate business and technical workshops.

• Produce current-state documentation.

Future Service Design and Business Architecture

• Analyse current service offerings.

• Assess business value of existing services.

• Identify redundant or obsolete services.

• Define future service portfolio.

• Analyse client requirements and service consumption patterns.

• Support business capability modelling.

• Define business processes supporting future services.

• Contribute to governance model definition.

• Support business case preparation.

Documentation, Stakeholder Support and Knowledge Transfer

• Produce business analysis documentation.

• Produce functional specifications.

• Maintain data architecture documentation.

• Support project governance activities.

• Facilitate workshops with business and technical stakeholders.

• Support solution validation.

• Deliver knowledge transfer sessions.

• Contribute to final project documentation.

Language: Advanced English

Location: Brussels

Work mode: Hybrid