Data Architect

JOB DESCRIPTION:


Job Title: Data Architect (Data Modelling)
Employment Type: 1 Year Contract
Work Location: Remote


JOB CONTEXT:
We're on the lookout for a Data Architecht who thrives in a high-performance, fast-paced technology environment. In this role you will drive the creation and continuous evolution of enterprise-grade dimensional models using Kimball best practices, crafting intuitive fact tables, dimensions, conformed dimensions, and smart surrogate key strategies that power meaningful analytics. Youll ensure these models are finely tuned for peak performance on Amazon Redshift, optimizing distribution styles, sort keys, and query patterns so insights are delivered quickly and efficiently. Youll also take ownership of reviewing and elevating existing modelsrefactoring them to improve usability, boost performance, and support future growth across the organization.


DUTIES AND RESPONSIBILITIES:
Senior Data Modelling & Design

• Lead the design and maintenance of enterprise-grade dimensional models using Kimball standards.
• Design fact tables, dimensions, conformed dimensions, and surrogate key strategies.
• Ensure models are optimized for Redshift performance (distribution styles, sort keys, query patterns).
• Review and refactor existing models to improve usability, performance, and scalability.

Hands-on SQL & Redshift Expertise

• Write and optimize complex SQL queries on Amazon Redshift for analysis, validation, and performance tuning.
• Profile source data to validate assumptions and inform modelling decisions.
• Support downstream analytics and BI teams with query optimization and model usage guidance.
• Partner with data engineers and analysts to align modelling decisions with ELT implementation.

Stakeholder Engagement & Workshops

• Facilitate requirements and modelling workshops with business stakeholders and data knowledge workers.
• Translate business concepts, KPIs, and metrics into well-defined dimensional structures.
• Act as a trusted advisor to business and analytics teams on data interpretation and usage.
• Communicate complex data concepts clearly to non-technical audiences.

Data Quality, Governance & Standards

• Define and enforce modelling standards, naming conventions, and design patterns.
• Document data definitions, business rules, and assumptions.
• Support data lineage, impact analysis, and enterprise data consistency.
• Contribute data governance and best-practice frameworks.

Leadership & Ment