Lead Data Architect (Contract) - Snowflake, Kimball, Remote

Forward Role; Manchester; Remote; GBP 111,000 - 185,000; Part time

Job summary

Forward Role is seeking a seasoned data architect to lead a new data architecture function for a well-known UK business. You will own analytics data modelling standards, guide a capable team, and drive ownership from day one in a remote role with occasional on-site travel.

You will shape how data is modeled for analytics, collaborate with business stakeholders, and coach others while setting the standards for the practice.

Qualifications

• Proven experience as a data architect or senior data modeller leading analytical model design.
• Strong Kimball and dimensional modelling expertise, including grain and conformed dimensions.
• Hands-on experience with Snowflake and working knowledge of dbt.
• Confidence working with business stakeholders and translating requirements into clear designs.
• Track record of setting standards and coaching or mentoring others.

Responsibilities

• Understand how the business operates, including processes, events, and data creation points.
• Collaborate with business teams to define measurement needs and build a shared data language.
• Design dimensional models and data marts in Snowflake.
• Decide grain, keys, and dimensions reusable across the business.
• Transform complex source data into clean, business-friendly models.
• Produce conceptual, logical and physical data models.
• Partner with the solution architect and hand designs to data/BI engineers in dbt.
• Set modelling standards and coach the team.

Skills

Data architecture

Dimensional modelling

Kimball method

Stakeholder engagement

Team coaching

Retail/ecommerce experience

Tools

Snowflake

dbt

Job description

Forward Role is seeking a seasoned data architect to lead a new data architecture function for a well-known UK business. You will own analytics data modelling standards, guide a capable team, and drive ownership from day one in a remote role with occasional on-site travel.

You will shape how data is modeled for analytics, collaborate with business stakeholders, and coach others while setting the standards for the practice.