Solution Architect/Modeler

Role: Solution Architect/Modeler locations: Canada, US, and Mexico-Remote hands-on Snowflake + hands-on dbt + strong data modeling experience + clickstream tracking/analytics experience.Required Skills & Experience 8+ years in data/solution architecture roles, including at least 3+ years in cloud data warehouse-based medallion (Bronze/Silver/Gold) architectures (e.g., Snowflake, Databricks, BigQuery). Hands-on experience with event-driven data collection platforms such as Snowplow, Segment, or mParticle as a source system. Strong dbt and workflow orchestration experience (e.g., Airflow); familiarity with managed orchestration bridges (e.g., Astronomer Cosmos) is a plus. Experience architecting real-time or near-real-time analytics pipelines for high-concurrency, low-latency use cases (media/publishing/editorial analytics experience strongly preferred). Experience with data migration/parity validation projects—legacy vendor analytics tool to modern in-house replacement. Working knowledge of front-end/full-stack architecture sufficient to coordinate with a UI-build team (role does not require hands-on front-end development). Experience operating in T&M, staff-augmentation delivery models with a client-owned PMO. Strong client-facing communication skills; comfortable representing technical positions directly to enterprise client stakeholders. Experience managing or technically directing offshore delivery teams. Familiarity with SSO/Okta-based role access models and enterprise data governance frameworks.