Data Solution Architect

Apply Digital; Vancouver; Hybrid; CAD 100,000 - 130,000; Full time

Job summary

A leading digital transformation partner is seeking a Solution Architect in Vancouver. In this role, you will design modern data platforms, lead large-scale data modernization initiatives, and provide strategic advisory to clients. The ideal candidate has 10+ years of experience in data architecture or consulting, with proven expertise in platforms like Snowflake and cloud environments. This position offers flexible work arrangements to foster a balanced work-life culture.

Benefits

Flexible personal time (PTO)

Generous training budgets

Customizable health benefits

Inclusive workplace culture

Great projects with international brands

Qualifications

• 10+ years of experience in data architecture or solution architecture within enterprise settings.
• Proven experience with large-scale data modernization using Snowflake.
• Strong understanding of data architectures including data lake, warehouse, and mesh.

Responsibilities

• Design modern, scalable data platforms across multi-cloud environments.
• Evaluate client data ecosystems and create modernization roadmaps.
• Define governance frameworks and architectural standards.

Skills

Data architecture

Cloud platforms (AWS, GCP, Azure)

Data governance

ETL/ELT pipeline design

Consultative mindset

Education

Snowflake SnowPro Advanced Architect certification

Tools

dbt

Apache Airflow

Terraform

Job description

ABOUT APPLY DIGITAL

Apply Digital is a global experience transformation partner. We drive AI-powered change and measurable impact across complex, multi-brand ecosystems. Leveraging expertise that spans across the customer experience lifecycle from strategy, design to engineering and beyond, we enable our clients to modernize their organizations and maximize value for their business and customers.

Our 750+ team members have helped transform global companies like Kraft Heinz, NFL, Moderna, Lululemon, Dropbox, Atlassian, A+E Networks, and The Very Group.

Apply Digital was founded in 2016 in Vancouver, Canada. In the past nine years, we have grown to ten cities across North America, South America, the UK, Europe, and India.

At Apply Digital, we believe in the “One Team” approach, where we operate within a ‘pod’ structure. Each pod brings together senior leadership, subject matter experts, and cross-functional skill sets, all working within a common tech and delivery framework. This structure is underpinned by well-oiled scrum and sprint cadences, keeping teams in step to release often and retrospectives to ensure we progress toward the desired outcomes.

Wherever we work in the world, we envision Apply Digital as a safe, empowered, respectful and fun community for people, every single day. Together, we work to embody our SHAPE (smart, humble, active, positive, and excellent) values and make Apply Digital a space for our team to connect, grow, and support each other to make a difference.

Visit our Careers page to learn how we can unlock your potential.

LOCATION

Apply Digital is hybrid/remote friendly. The preferred candidate should be based in either the Greater Toronto Area or the Greater Vancouver Area of Canada, working in hours that align to ET (Eastern Timezone) or PT (Pacific Timezone).

THE ROLE

Are you passionate about designing modern, scalable, and secure data architectures? Do you thrive at the intersection of technology strategy and business transformation? We’re looking for a Solution Architect to lead large-scale data platform modernization initiatives — someone with the technical depth to design elegant architectures, the consulting acumen to guide enterprise clients through transformation, and the leadership to inspire cross-functional teams. In this hands-on architecture role, you’ll design next-generation data ecosystems powered by Snowflake, GCP, and the modern data stack. You’ll define blueprints, lead migrations, and establish scalable data patterns that enable analytics, marketing, and AI at global scale. As part of Apply Digital’s Data & AI practice, you’ll work directly with client executives and data leaders to turn strategy into impact. This role demands deep expertise across data warehousing, governance, and real-time processing in cloud-native architectures (Snowflake, GCP, AWS, Azure) — and the consulting skills to translate complexity into clarity and action.

RESPONSIBILITIES

• Design and architect modern, scalable, and composable data platforms across multi-cloud environments (AWS, GCP, Azure), supporting real-time analytics, AI/ML, and customer experience use cases.
• Assess client data ecosystems and create strategic modernization roadmaps—from on-prem to cloud migrations, to enabling unified customer data and activation.
• Create and enforce architectural standards, governance models, and reference architectures across data lakehouse, mesh, and medallion patterns.
• Evaluate and recommend data storage and compute technologies (e.g., BigQuery, Snowflake, Redshift, Delta Lake, Apache Iceberg) based on performance, scalability, cost, and security trade-offs.
• Design robust, scalable ETL/ELT pipelines using both batch and streaming tools (e.g., dbt, Airflow, Kafka, Kinesis, Pub/Sub), and optimize data flows for speed and reliability.
• Define and enforce data governance frameworks, including RBAC/ABAC models, lineage tracking, metadata management, and compliance (GDPR, CCPA, SOC2).
• Develop architectural guidance for AI/ML data pipelines, including the design of feature stores, real-time inference pipelines, and MLOps alignment.
• Recommend tools and practices for data cataloging, quality, observability, and security, leveraging platforms such as Collibra, DataHub, or Apache Atlas.
• Provide strategic advisory to business and technical stakeholders, aligning data architecture decisions with broader digital transformation and ROI goals.
• Create clear, client-facing deliverables: reference architectures, integration strategies, migration plans, and governance models.

REQUIREMENTS

• 10+ years of experience in data architecture, platform engineering, or solution architecture within enterprise or consulting environments.
• Proven experience architecting and implementing large-scale data modernization programs using Snowflake (required) and/or GCP, AWS, Azure.
• Snowflake SnowPro Advanced Architect certification (nice to have GCP Professional Data Engineer or Architect certification)
• Expertise in data modeling (dimensional, Data Vault), schema evolution, and building systems to handle both structured and unstructured data.
• Strong understanding of data lake, data warehouse, lakehouse, and data mesh architectures, and when to apply each.
• Experience designing high-performance, scalable pipelines using dbt, Apache Airflow, Kafka, Kinesis, Pub/Sub, or similar tools.
• Knowledge of Terraform for Infrastructure as Code (IaC) in data environments.
• Experience integrating CDPs and MarTech/AdTech platforms for real-time personalization.
• A consultative mindset — you’re comfortable assessing ambiguous environments, providing strategic guidance, and influencing stakeholders toward long-term, scalable solutions.

LIFE AT APPLY DIGITAL

At Apply Digital, people are at the core of everything we do. We value your time, safety, and health, and strive to build a work community that can help you thrive and grow. Here are a few benefits we offer to support you:

Great projects: Broaden your skills on a range of engaging projects with international brands that have a global impact.

An inclusive and safe environment: We’re truly committed to building a culture where you are celebrated and everyone feels welcome and safe.

Learning opportunities: We offer generous training budgets, including partner tech certifications, custom learning plans, workshops, mentorship, and peer support.

Generous vacation policy: Work-life balance is key to our team’s success, so we offer flexible personal time offer (PTO); allowing ample time away from work to promote overall well-being.

Customizable benefits: Tailor your extended health and dental plan to your needs, priorities, and preferences.

Flexible work arrangements: We work in a variety of ways, from remote, to in-office, to a blend of both.

Apply Digital is committed to building a culture where differences are celebrated and everyone feels welcome. That’s why we value equal opportunity and nurture an inclusive workplace where our individual differences are recognized and valued.

For more information, visit the Diversity, Equity, and Inclusion (DEI) section of our website. If you have accommodation needs at this stage of the recruitment process, please inform us as soon as possible by emailing [e-mail].