Haystack
← Back to Jobs
Remote
Technology
ID

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

Info Dinamica IncUnited States🇺🇸United StatesPosted 24 Aug 2026

Why This Role Stands Out

Leverage your expertise in Snowflake, Databricks, or BigQuery to drive impactful data solutions in this remote Solution Architect role. If you excel at bridging technical teams and leading projects from design to production, you'll thrive in this opportunity to shape innovative data architectures. Apply now to make a significant contribution and advance your career in a flexible, collaborative environment.

Quick Overview

Seniority
Mid Senior
Work mode
Remote
Location
United States
Posted
1 week ago
SSOSnowflakeAirflowBigQueryDatabricksStakeholder Managementdbt

Job Description

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.

Similar jobs