Senior Data Architect, Snowflake 360° Platform (Hybrid)

Revel IT; Columbus (OH); Hybrid; USD 120,000 - 150,000; Full time

Job summary

Revel IT is seeking a hands-on Data Architect to lead the design of a modern data platform built on Snowflake, dbt, Airflow, and AWS. You will own end-to-end data modeling for members, marketing, and sales data, and drive a Salesforce migration to create a governed, AI-ready data foundation.

The role requires 8+ years in data architecture, deep Snowflake expertise, and strong SQL/Python skills. This hybrid Columbus-based position offers a 12‑month contract-to-hire arrangement with local

Qualifications

• 8+ years in data architecture and data engineering

Responsibilities

• Own the conceptual, logical, and physical data models for members, customers, organizations, subscriptions, orders, events, learning, and engagement
• Design a unified Member/Customer 360 with entity resolution and deduplication across multiple source systems
• Own the medallion architecture: Bronze on S3, Silver as Apache Iceberg, and Gold in Snowflake
• Design Snowflake environments, RBAC, and access patterns, and own performance and cost
• Lead a 60-day Snowflake proof-of-value on the Salesforce source and turn the results into reusable patterns
• Architect orchestration on Apache Airflow and the dbt transformation layer, with testing, lineage, and CI/CD through Git
• Act as data lead for a membership platform migration to Salesforce, covering mapping, cleansing, reconciliation, and cutover
• Help stand up a data governance program covering ownership, definitions, quality rules, and certified data products
• Design data products for engagement scoring, churn and retention, and leadership KPIs
• Advise business and executive stakeholders, produce architecture decision records and solution designs, and guide onshore and offshore engineers

Skills

Data architecture

SQL

Python

Git workflow

Executive communication

CRM data understanding

Data modeling

Education

Bachelor’s degree in CS/Engineering/IS

Tools

Snowflake

dbt

Apache Airflow

AWS (S3, Glue, IAM, ECS Fargate, RDS PostgreSQL)

Apache Iceberg

Job description

Revel IT is seeking a hands-on Data Architect to lead the design of a modern data platform built on Snowflake, dbt, Airflow, and AWS. You will own end-to-end data modeling for members, marketing, and sales data, and drive a Salesforce migration to create a governed, AI-ready data foundation.

The role requires 8+ years in data architecture, deep Snowflake expertise, and strong SQL/Python skills. This hybrid Columbus-based position offers a 12‑month contract-to-hire arrangement with local