Solution Architect / Data Modeler (Strong exp with Snowflake, Databricks, or BigQuery) - Remote

Role: Solution Architect / Data Modeler (Strong experience with Snowflake, Databricks, or BigQuery) Remote (Canada, US or Mexico) Job Type: Contract Experience: 8+ Years Looking for a candidate who is a hands-on Data/Solution Architect who can bridge data engineering, architecture, and UI teams, communicate directly with enterprise clients, and provide strong technical leadership from design through production. Key Skills Cloud Data Architecture + Bronze/Silver/Gold + Snowflake/Databricks/BigQuery + dbt + Airflow + Snowplow/Segment/mParticle + Real-Time Analytics + Data Migration/Validation Role Overview We are looking for a Solution Architect / Data Modeler to own the technical architecture and delivery of data pipelines and their integration with real-time web applications. The role will work closely with the client's Data Engineering team and provide technical direction to offshore teams.

Key Responsibilities

• Own architecture for Gold-layer data pipelines using dbt and Airflow on cloud data platforms.
• Design integration between data pipelines, Real-Time Newsroom UI, and Audience Goals Dashboard.
• Work directly with client Data Engineering, Data Collection, and Program Management teams.
• Translate business requirements into clear technical designs and specifications.
• Resolve architecture and data dependencies across Bronze/Silver/Gold layers.
• Provide technical guidance and review designs/implementations from offshore teams.
• Ensure data quality, validation, observability, and production readiness.
• Manage technical risks, dependencies, timelines, and delivery priorities.
• Support post-production activities, knowledge transfer, and documentation.

Must-Have Skills

• 8+ years of experience in Data/Solution Architecture.
• 3+ years working with cloud data warehouse Medallion Architecture (Bronze/Silver/Gold).
• Strong experience with Snowflake, Databricks, or BigQuery.
• Hands-on experience with Snowplow, Segment, mParticle, or similar event-data collection platforms.
• Strong dbt + Airflow/workflow orchestration experience.
• Experience designing real-time/near-real-time analytics pipelines.
• Experience with data migration, data reconciliation, and parity validation.
• Understanding of frontend/full-stack architecture to work effectively with UI teams.
• Experience leading/directing offshore engineering teams.
• Strong client-facing communication and stakeholder management skills.
• Knowledge of SSO/Okta, role-based access, and data governance.