Database Structure Analyst Job at York Full Time NEW

Data ModellerLocation: Remote (occasional travel to York, 1–2 times per month)Contract Length: 6 months initiallyIR35 Status: Outside IR35Start Date: ImmediateDaily rate: Up to £600/dayWRK digital is proud to partner with a highly recognisable and trusted UK brand to recruit an experienced Data Modeller for an exciting new contract opportunity. This is a fantastic chance to join a thriving Data function at the forefront of modern technology and innovation.We are seeking a skilled and detail-oriented Data Modeller with strong Amazon Redshift experience to design, develop, and maintain scalable enterprise data models that support analytics, reporting, Machine Learning, AI, and operational business intelligence initiatives.This role is pivotal in ensuring data is structured, governed, and optimised for performance across cloud-based data platforms. The successful candidate will work closely with data engineers, architects, analysts, and business stakeholders to translate complex business requirements into logical and physical data models that enable trusted, high-quality, and accessible data solutions.The successful candidate will play a key role in developing dimensional models, improving data consistency, supporting data integration initiatives, and optimising Redshift data warehouse performance across the organisation.Key CompetenciesStrong experience in enterprise data modelling, including conceptual, logical, and physical data models.Proven experience designing and optimising data models within Amazon Redshift environments.Strong understanding of dimensional modelling techniques including star and snowflake schemas.Experience working with AWS technologies including Redshift, Glue, and S3.Strong SQL skills and experience working with large-scale analytical datasets.Experience supporting ETL/ELT data integration processes and cloud-based data platforms.Knowledge of data governance, metadata management, and data quality standards.Strong collaboration skills with engineering, analytics, architecture, and business teams.Ability to translate business requirements into scalable and maintainable data structures.Understanding of data security, privacy, and regulatory compliance requirements including GDPR.Excellent communication, stakeholder management, and documentation skills.