Senior Data Architect: Snowflake, dbt & AI-Ready Platform

Revel IT; Columbus (OH); Hybrid; USD 160,000 - 190,000; Full time

Job summary

Revel IT is seeking a seasoned Data Architect to design and govern data models for a modern cloud data platform built on Snowflake, dbt, Airflow, Iceberg, and AWS. The role concentrates on a governance-driven data strategy, delivering trusted data products for Membership, Marketing, Education, and Sales, with hands-on delivery responsibilities across multiple stakeholder groups.

The position requires local presence in Columbus, with on-site work two days a week (Tuesday and Wednesday).

Qualifications

• 8+ years of progressive experience in data architecture, data engineering, or solutions architecture, including 3+ years as the architect of record for a modern cloud data platform.
• Deep hands-on experience with Snowflake in production: data modeling, RBAC, performance tuning, and cost management.
• Production experience with dbt for transformation-layer design, testing, and documentation.
• Production experience with Apache Airflow for orchestration at scale.
• Experience designing and operating Apache Iceberg-based lakehouses on AWS (S3, Glue, IAM, container compute).
• Strong data modeling skills (dimensional, normalized, and entity-centric) and experience building a Customer/Member 360.
• Experience with membership, association, or subscription data, and with marketing and sales application data (marketing automation, CDP, CRM, e-commerce).
• Hands-on experience with a CRM or membership-system migration, including data mapping, cleansing, reconciliation, and cutover; netFORUM-to-Salesforce strongly preferred.
• Strong SQL and Python skills with a Git-based, code-first development workflow.
• Proven ability to explain architecture and trade-offs to non-technical executives and business stakeholders.
• Bachelor's degree in computer science, engineering, information systems, or equivalent practical experience

Responsibilities

• Own the conceptual, logical, and physical data models for client data: members, customers, organizations, memberships, orders, subscriptions, events, learning, and engagement.
• Design a unified Member/Customer 360 model, with entity resolution and deduplication that produce one trusted record across Membership, Marketing, Education, Scientific Research and commerce systems.
• Extend the model for organizational and institutional accounts as the client expands from B2C into B2B selling.
• Set modeling standards for each medallion layer (naming, keys, history and slowly changing dimensions, conformed dimensions) and review designs from the engineering team.
• Own the SDS medallion architecture: Bronze as Parquet on Amazon S3, Silver as Apache Iceberg tables, and Gold as native Snowflake, using External, Iceberg, and Dynamic Tables where each fits.
• Implement Snowflake Open Catalog (Polaris) as the near-term catalog for Iceberg metadata, with AWS Glue Data Catalog where needed.
• Design Snowflake environments (dev, stage, prod), role hierarchy, RBAC, and AWS IAM Identity Center access patterns.
• Own Snowflake performance and cost: warehouse sizing, resource monitors, clustering, query tuning, and credit reporting.
• Lead the 60-day Snowflake proof-of-value on the Salesforce source and turn the results into reusable patterns for every other source.

Skills

Snowflake

dbt

Apache Airflow

AWS

Education

Bachelor's degree in CS/Engineering/IS or equivalent

Tools

Snowflake

dbt

Apache Airflow

AWS

Job description

Revel IT is seeking a seasoned Data Architect to design and govern data models for a modern cloud data platform built on Snowflake, dbt, Airflow, Iceberg, and AWS. The role concentrates on a governance-driven data strategy, delivering trusted data products for Membership, Marketing, Education, and Sales, with hands-on delivery responsibilities across multiple stakeholder groups.

The position requires local presence in Columbus, with on-site work two days a week (Tuesday and Wednesday).