Senior Data Architect

Arbor TekSystems Β· United States
Work typeOn-site Β· Contract
Pay Β· estimate~$140k – $190kMarket rate Β· not set by employer
PostedNov 19, 2026
LevelSenior
In short We are seeking an experienced Data Architect to lead the design and implementation of modern data products and drive our migration from Oracle to Snowflake, including the…
SQLPYTHONAWSSNOWFLAKE

πŸ“‹ About the job

LocationFranklin, Tennessee Onsite day 1
Job typeContract

Job Summary

We are seeking an experienced Data Architect to lead the design and implementation of modern data products and drive our migration from Oracle to Snowflake, including the re-platforming of existing Informatica Intelligent Cloud Services (IICS) workflows onto Snowflake. The ideal candidate combines strong architectural expertise with hands-on experience in data governance, data modeling, and cloud data platforms, and can translate business needs into scalable, governed, and reusable data products.

Key Responsibilities

  • Define and own the end-to-end data architecture for data products, from source ingestion through to consumption layers.
  • Design and maintain conceptual, logical, and physical data models using erwin Data Modeler, ensuring consistency and alignment with enterprise standards.
  • Lead the migration strategy and execution for moving data and workloads from Oracle to Snowflake, including schema conversion, data migration, validation, and performance tuning.
  • Re-engineer and migrate existing IICS (Informatica Intelligent Cloud Services) workflows to Snowflake-native pipelines (e.g., Streams, Tasks, Stored Procedures, Snowpipe) or modern ELT patterns.
  • Design and implement data products with clear ownership, documentation, SLAs, and reusability in mind.
  • Establish and enforce data governance standards, including data quality, metadata management, lineage, cataloging, and access controls.
  • Define data modeling standards and modern architecture patterns such as the Medallion architecture (Bronze/Silver/Gold).
  • Implement role-based access control (RBAC), data security, and compliance measures within Snowflake.
  • Partner with data engineers, analysts, and business stakeholders to align architecture with business and product goals.
  • Provide technical leadership, conduct design/code reviews, and mentor engineering teams.
  • Optimize for performance, scalability, and cost efficiency across the Snowflake platform.
  • Create and maintain architecture documentation, data models, migration runbooks, and governance artifacts.

Required Skills & Qualifications

  • Proven experience as a Data Architect designing and delivering enterprise data solutions.
  • Hands-on experience implementing data products and data platform architectures.
  • Strong hands-on experience with erwin Data Modeler for designing and managing enterprise data models.
  • Strong experience in data governance (data qu…
πŸ“„ Read the full description β†’ The rest of this listing is on the hiring partner’s site.
Interested in this role?Apply in one click β€” no JobQ account needed.
Apply now β†’
Senior Data ArchitectArbor TekSystems
Apply now