Senior Data Designer

About the Position

We are looking for a Senior Data Designer with strong expertise in enterprise data modeling to design and document high quality data solutions. You will contribute to data ingestion design, transformation logic, and data harmonization while working closely with stakeholders and platform teams.

About the Project

This project focuses on building and enhancing an enterprise data warehouse platform that supports data driven decision making across complex business domains. The work involves designing scalable data models, ingestion pipelines, and transformation logic to ensure high quality and consistent data.

About the Team

You will be part of a collaborative data team working alongside data designers, data engineers, and platform specialists. The team operates in an agile environment, shares knowledge actively, and follows established data design standards and review practices.

Responsibilities

• Design and document ingestions from existing sources.
• Collaborate with Principal Data Designer to design and document ingestions from new sources.
• Collaborate with stakeholders and data platform teams to create designs that meet requirements, align with principles, and ensure supporting documentation is delivered accurately and on time.
• Keep up to date with the data design principles and be able to explain their benefit and relevance to others.
• Identify potential new data design principles.
• Contribute to improvements to ways of working and documentation templates.
• Peer review colleagues’ designs to ensure that they meet the requirements and principles.
• Support other workstreams by picking up additional design work when capacity allows.

Requirements

• Strong Data modelling for enterprise data warehouses.
• Works with existing network to expand knowledge.
• Gathers and documents relevant information beyond provided guidance.
• Understands deliverables and analyses available information to make appropriate decisions.
• Works collaboratively in agile development process.
• Engages with key stakeholders inside and outside of own area and experts in the wider team to make good design decisions.
• Strong attention to detail.
• Supports the wider design team by considering other perspectives and constructively challenging decisions during design review sessions.
• Communicates clearly and effectively, in a style which elicits trust.
• Proactively works on own development, learning about areas outside own role.

Nice to Have

• Querying and transforming data using SQL, Python / PySpark.
• Conducting detailed data profiling and analysis.
• Modelling data into a complex facts and dimensions, identifying suitable mappings, aggregations and snapshot tables where appropriate.
• Identifying complex data quality rules, considering alternative sources and volumetric analysis.

Technologies

SQL, Python, PySpark, enterprise data warehouse tools, data modelling frameworks, cloud data platforms