Building data solutions is a cornerstone of the data strategy. The purpose of this role is to identify and map data sources, design the underlying data models and transformation logic, and support the design and building of data solutions as part of projects and BAU (Business as Usual) activities. The Data Architect will define and govern the organisation's data architecture mapping the current ("as-is") data landscape, designing the target ("to-be") landscape, and guiding the analysis and integration of data sources feeding into the enterprise. The role bridges strategy and delivery: translating business and technology needs into coherent data architectures, master data structures, and reusable data capabilities that data engineering and solution teams can build against.
Key Responsibilities
- Document and maintain the current-state data landscape: systems, data flows, integration points, and how data moves across the organization.
- Design the target-state data landscape aligned to business strategy and future data needs, and produce roadmaps and transition plans (gap analysis) from current to target state.
- Identify and catalogue data sources (internal systems, external feeds, APIs, third-party data) relevant to a given business or solution need, mapping source structures to target models and tracing data lineage from source through to consumption.
- Design the transformation logic required to move data from source structures into target models, including mapping rules, business logic and calculations.
- Produce and maintain conceptual, logical and physical data models across source, integration and consumption layers, applying appropriate modelling standards (e.g. dimensional modelling).
- Define the master data model(s) (e.g. customer, product, supplier, location) and rules for creation, stewardship and lifecycle management, working with data governance teams on golden-record strategies and data quality standards.
- Design and support the build of data-heavy solutions, including those delivered on the data platform, translating business requirements into practical, well-modelled data solutions.
- Work hands-on with delivery teams through design, build and testing to ensure solutions match the intended architecture and data models, defining what is sourced, how it's transformed, where it lands and how it's consumed.
- Contribute to data architecture designs and standards in support of projects and programmes, and participate in design reviews to assure alignment with the target landscape.
- Ensure knowledge and best practices are transferred to colleagues via mentoring, knowledge sharing sessions and participation in the Data Community.
Experience
- Bachelor's degree in business, computer science, computer engineering, electrical engineering, system analysis or a related field of study, or equivalent experience
- Expert in conceptual, logical and physical data modelling
- Significant experience identifying and mapping data sources, and designing source-to-target transformation logic
- Proven experience designing and building data solutions, including data-heavy solutions delivered on a data platform
- Broad experience in data standardisation procedures and best practices
- Significant experience designing, implementing and supporting data management solutions across Master Data, Meta Data and Reference Data domains
- Experience in data cleansing and maintenance techniques for the data life-cycle