Senior Data Architect: Snowflake & AI-Ready Data Platform

Royal Cyber

United States

Remote

USD 22,000 - 37,000

Part time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Royal Cyber Inc is seeking a Data Architect for freelancing to design end-to-end Snowflake architecture, define ETL frameworks with Matillion, and guide MDM with Semarchy xDM. The role focuses on AI-ready data, Cortex AI workloads, and governance across the data stack.

You will work with offshore and onshore teams to translate business needs into scalable architecture decisions, ensuring secure access and optimized performance.

Qualifications

  • Strong hands-on Snowflake experience including architecture, modeling, optimization, security, Snowpipe, Streams & Tasks, data sharing.
  • Proven experience designing and implementing Matillion ETL pipelines and frameworks.
  • Exposure to MDM concepts (golden records, match/merge, data quality, governance); Semarchy xDM experience is a strong plus.
  • Good understanding of Snowflake Cortex AI capabilities, semantic models, and data preparation for AI workloads.
  • Solid data modeling (dimensional/Data Vault) and SQL; strong cloud data platform knowledge.
  • Excellent communication and ability to collaborate with offshore and onshore teams.

Responsibilities

  • Design end-to-end Snowflake architecture (data modeling, warehouses, RBAC, performance, cost optimization, secure data access).
  • Define Matillion ETL frameworks, orchestration standards, and reusable pipeline patterns.
  • Guide Semarchy MDM architecture on Snowflake (logical models, match/merge, golden records, data quality, stewardship integration).
  • Architect solutions that support Snowflake Cortex AI (Cortex Analyst, Cortex Search, AI SQL functions, agentic workflows).
  • Establish standards for AI-ready data and semantic models/metrics for Cortex AI workloads.
  • Establish data modeling, security, governance, and integration standards across the stack.
  • Review and approve designs, provide technical leadership and mentoring.
  • Collaborate with stakeholders to translate business requirements into architecture decisions.

Skills

Snowflake architecture
Matillion ETL
MDM concepts (Semarchy xDM)
Snowflake Cortex AI capabilities
Data modeling (Dimensional/Data Vault)
SQL
Communication with offshore/onshore

Job description

Royal Cyber Inc is seeking a Data Architect for freelancing to design end-to-end Snowflake architecture, define ETL frameworks with Matillion, and guide MDM with Semarchy xDM. The role focuses on AI-ready data, Cortex AI workloads, and governance across the data stack.

You will work with offshore and onshore teams to translate business needs into scalable architecture decisions, ensuring secure access and optimized performance.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Snowflake Data Architect — AI-Ready Enterprise Platforms
Snowflake Data Architect — AI-Ready Enterprise Platforms

BlueCloud • United States

On-site
USD 150,000 - 230,000
Snowflake Data Architect: Modernization & AI Platform Lead
Snowflake Data Architect: Modernization & AI Platform Lead

BlueCloud • United States

Remote
USD 180,000 - 240,000
Senior Data Architect - Remote | Snowflake & AI Readiness
Senior Data Architect - Remote | Snowflake & AI Readiness

LG Energy Solution Vertech, Inc. • Westborough (MA)

Remote
USD 150,000 - 210,000
100% employer sponsored medical,Dental
Vision insurance
Life and disability insurance
Senior Data Architect — Snowflake & AI Platform
Senior Data Architect — Snowflake & AI Platform

Signant Health • United States

On-site
USD 140,000 - 190,000
Senior AI Data Warehouse Architect — Snowflake & AI-Driven Platform
Senior AI Data Warehouse Architect — Snowflake & AI-Driven Platform

Madison-Davis • United States

Remote
USD 170,000 - 230,000
Remote Data Architect — AI/ML & Snowflake
Remote Data Architect — AI/ML & Snowflake

Great Plains Communications, LLC • Blair (NE), Omaha (NE)

Hybrid
USD 90,000 - 120,000
Competitive pay
Comprehensive benefits
Professional development
+1
Senior Snowflake Data Architect — Cortex AI Lead
Senior Snowflake Data Architect — Cortex AI Lead

DATAECONOMY Inc • New York (NY)

On-site
USD 150,000 - 210,000
Snowflake Data Architect – Cortex AI
Snowflake Data Architect – Cortex AI

Veriipro • Milwaukee (WI)

On-site
USD 140,000 - 190,000
Senior Snowflake Architect – Data Cloud Solutions
Senior Snowflake Architect – Data Cloud Solutions

CIYIS • United States

Remote
USD 120,000 - 180,000
Remote Snowflake Data Platform Architect
Remote Snowflake Data Platform Architect

Cold Sun Enterprise • United States

Remote
USD 150,000 - 200,000