Domain Data Modeller

• Designing, implementing and maintaining conceptual, logical and physical data models aligned to business domains
• Maintain and enhance the enterprise data catalogue, ensuring metadata, lineage and business definitions remain accurate and trusted
• Translating business requirements into clear, well-structured data models in collaboration with Product Owners, Technical Lead 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

We’re looking for a skilled data modeller with strong technical foundations and the ability to collaborate effectively across technical and non-technical teams.

You’ll have:

• 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 (e.g. Microsoft Purview)
• 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, * 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, * Significant hands-on experience in data modelling projects, with experience designing and delivering Gold-layer data products in Databricks or a comparable modern lakehouse platform
• Strong ability to understand business processes, information flows and source systems, translating them into conceptual, logical and physical data models that accurately represent business domains and provide a trusted foundation for analytics, reporting and data products
• Experience in systems and database design, including relational and dimensional modelling techniques.
• Experience collaborating with data engineers, analysts and business stakeholders and demonstrating ability to influence and build relationships across technical teams, architects, Product Owners and business stakeholders.
• Hands-on Databricks experience, including SQL/Python
• Strong communication skills and experience working with technical and business stakeholders.
• Understanding of data quality, classification, privacy and governance principles, with the ability to embed them into model design

Desirable

• Degree in Computer Science, Information Systems, Data Science or a related discipline
• Experience applying data quality, governance, metadata, lineage, security and privacy principles to BI and analytical solutions
• Relevant certifications such as Certified Data Management Professional (CDMP) or Microsoft Azure Data Engineering certifications

• Play a foundational role in shaping Southern Water’s new data platform
• Work on meaningful, in-demand business-critical data products
• Collaborate with multidisciplinary teams across technology and the business
• Hybrid and flexible working
• Competitive salary, pension, bonus and a comprehensive benefits package