Domain Data Modeller

Southern Water•Worthington, MN

3d•Hybrid

About The Position

Southern Water is undergoing a significant data transformation to establish a modern, trusted data platform that will enhance operational performance, support regulatory compliance, and improve decision-making across the organization. Data modelling is a crucial component of this transformation, forming the foundation for analytics, reporting, and data products throughout the company. As a Domain Data Modeller, you will be an integral part of a domain-aligned agile squad, tasked with designing and maintaining scalable, business-aligned data models that support analytics, reporting, and data products. You will collaborate closely with Product Owners, Data Engineers, BI Engineers, architects, and business stakeholders to ensure data models accurately reflect business domains and adhere to enterprise architecture and governance frameworks. A key aspect of this role involves ensuring the accuracy and trustworthiness of metadata, lineage, and catalogue information across the data platform. This position is well-suited for individuals who thrive at the intersection of business and technology, influencing how data is structured, governed, and utilized within an organization.

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