Domain Data Modeller

Southern Water•Worthington, MN

21h•Hybrid

About The Position

Southern Water is on a major data transformation journey to build a modern, trusted data platform that supports operational performance, regulatory outcomes and better decision‑making across the business. Data modelling is a core capability within this transformation, underpinning analytics, reporting and data products across our organisation. As a Domain Data Modeller, you will be a key member of a domain‑aligned agile squad, responsible for designing and maintaining scalable, business‑aligned data models that support analytics, reporting and data products. You’ll work closely with Product Owners, Data Engineers, BI Engineers, architects and business stakeholders to ensure data models accurately represent business domains and align with enterprise architecture and governance frameworks. You will also play a critical role in ensuring that metadata, lineage and catalogue information remains accurate and trusted across the data platform. This role is ideal for someone who enjoys working at the intersection of business and technology, shaping how data is structured, governed and consumed across an organisation.

Requirements

Proven experience in domain or enterprise data modelling on large‑scale data platforms
Strong understanding of data architecture, metadata management and data governance
Experience using data modelling tools such as Erwin or equivalent
Experience working with cloud‑based data platforms (e.g. Azure Data Lake, Databricks)
Familiarity with data cataloguing and lineage tools
Strong SQL skills and experience with relational and dimensional modelling
The ability to translate complex business concepts into clear data structures
Experience working in agile delivery environments, including use of Jira and Confluence
Excellent problem‑solving, communication and stakeholder engagement skills
The ability to manage multiple modelling activities across different business domains
Hands‑on experience in data modelling projects
Experience collaborating with data engineers, analysts and business stakeholders

Nice To Haves

Enterprise and business architecture principles
Data governance frameworks such as DAMA
Data privacy, classification and handling principles
Change management practices for data models in distributed environments
Understanding of how data models support BI and analytics use cases
Degree in Computer Science, Information Systems, Data Science or a related discipline
Relevant certifications such as Certified Data Management Professional (CDMP) or Microsoft Azure Data Engineering certifications

Responsibilities

Designing, implementing and maintaining conceptual, logical and physical data models aligned to business domains
Ensuring metadata and lineage are accurately captured and maintained within the enterprise data catalogue
Translating business requirements into clear, well‑structured data models in collaboration with Product Owners and delivery teams
Contributing to solution architecture discussions, ensuring data models support scalability and long‑term strategy
Working closely with Data Engineers to validate models against ingestion pipelines and sample data
Providing high‑quality model documentation to support downstream development and analytics
Maintaining data modelling standards and best practices across squads
Applying change management principles to ensure consistency and traceability of model changes
Supporting governance and metadata management using recognised data modelling tools
Capturing and maintaining domain knowledge and model documentation
Engaging with architects, SMEs, governance and compliance teams as needed
Managing and contributing to modelling work within the squad’s agile backlog
Actively participating in agile ceremonies, backlog refinement and sprint planning