A large public-sector registry maintains central administrative records used by many government services, and the data architecture team is formalising domain models and reusable canonical structures. This role will use Archi and ArchiMate to capture conceptual and logical models and help establish a robust master data management approach, working across data warehouse and integration concerns.
The mission
The programme is mapping domain expertise and existing documentation into formal conceptual and logical data models that will be the single source of truth for downstream services. The technical landscape includes PostgreSQL for persistent storage, Spark for batch processing, containerised deployment with Docker and Kubernetes, and requirements for encryption and Identity and Access Management. The models will cover core administrative domains and expected reuse across multiple consumer systems.
Day to day you will translate stakeholder requirements into deliverables such as a conceptual model per domain, data flows and integration diagrams, logical data models with attribute definitions and key policies, and a canonical model tied to master data management. You will work in a cross-functional team of architects, data engineers and product owners, producing documentation in Archi/Archimate and coaching domain stewards to maintain the business glossary and ownership model.
Your responsibilities
- Design and deliver conceptual and logical data models per domain, with diagrams and semantic definitions that can be consumed by engineers and analysts.
- Define and maintain a canonical model and reusable entities, ensuring alignment with master data management principles and consumer integration patterns.
- Establish the business glossary, assigning term definitions, domains and stewardship responsibilities to reduce ambiguity across systems.
- Specify data flows and integration patterns, including how data moves between PostgreSQL, the data warehouse and Spark jobs, and how canonical entities are mapped.
- Advise on security and deployment requirements, including encryption at rest and in transit, Identity and Access Management controls, and container orchestration with Docker and Kubernetes.
- Review and validate logical models against key policies: primary keys, normalization levels and hierarchical data structures, and provide migration guidance where needed.
Your profile
Essential skills
- 3+ years of practical experience in data architecture delivering conceptual and logical models, including ERD and domain-driven design practices.
- Proven use of Archi and ArchiMate for modelling and documentation.
- Experience defining or operating Master Data Management (MDM) solutions and canonical models.
- Strong SQL and operational experience with PostgreSQL and familiarity with Spark for batch processing.
- Practical knowledge of containerisation and orchestration, specifically Docker and Kubernetes.
- Understanding of encryption best practices, hierarchical database modelling, and Identity and Access Management for data access controls.
- Ability to engage with domain experts, produce clear semantic definitions, and support the assignment of stewards for a business glossary.