Position: Solution Architect / Data Modeler with Snowflake, Databricks, or BigQuery
Location: Remote
Experience: 10+ Years
Mandatory: Need hands on experience on DBT, data modelling, clickstream tracking, Snowflake & databricks.
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.
Nice to Have
- Tableau integration/repointing experience.
- Newsroom/editorial analytics experience with Parse.ly, Chartbeat, or similar.
- AWS / EKS / Istio experience or AWS certification.
- Experience with managed Airflow solutions such as Astronomer/Cosmos.
Ideal Candidate
The ideal candidate 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 Screening Areas:
Cloud Data Architecture + Bronze/Silver/Gold + Snowflake/Databricks/BigQuery + dbt + Airflow + Snowplow/Segment/mParticle + Real-Time Analytics + Data Migration/Validation + Client Communication.
Never miss an opportunity! Create an alert based on the job you applied for.
