Leads the team this role joins
Heads the group this role sits in
In-house, owns the opening
From your own Gmail and LinkedIn.
About the role
This is a 12-month remote contract for a senior data architect based in Canada, with at least 8 years of experience in data engineering and enterprise data warehousing. The lead owns the data architecture and model design, runs requirement discussions with business and technology stakeholders, and directs offshore developers through implementation. Snowflake experience and hands-on data modelling are mandatory.
What you’ll do
- Own the end-to-end data architecture and data modelling work.
- Lead requirement discussions with business and technology stakeholders, clarify business rules and close gaps.
- Design logical and physical data models, including fact and dimension tables, keys, grain and hierarchies.
- Define data warehouse architecture, integration patterns and transformation logic.
- Build and tune scalable Snowflake data warehouse solutions.
- Turn architecture and models into development specifications and implementation plans.
- Direct offshore development teams, review their designs and code, and clear technical blockers.
- Confirm that development follows the approved architecture, modelling standards and data quality rules.
What they’re looking for
- 8 or more years in data engineering, data architecture and enterprise data warehousing.
- Hands-on Snowflake experience, including schema design, SQL development and performance optimisation.
- Strong conceptual, logical and physical data modelling, including dimensional modelling, star and snowflake schemas, and slowly changing dimensions.
- Strong SQL and working knowledge of ETL, ELT and data integration.
- A track record of converting business requirements into detailed data models and technical designs.
- Strong stakeholder management and communication, with experience leading technical discussions.
- Experience directing offshore development teams.
Nice to have
- Exposure to Snowplow and event-tracking data architecture.
- Experience with streaming ingestion tools such as Kafka or AWS Kinesis.
- Exposure to dbt, Airflow and a major cloud data platform (AWS, Azure or GCP).
- Knowledge of data governance, lineage and data quality frameworks.
What’s on offer
- Remote work within Canada.
- 12-month contract term.
Skills
Questions about this role
Is this role remote?
Yes. The role is remote within Canada.
How long is the contract?
The contract runs for 12 months.
How many years of experience do I need?
The posting asks for at least 8 years in data engineering, data architecture and enterprise data warehousing.
Is Snowflake experience required?
Yes. Hands-on Snowflake experience is listed as mandatory.