Loading, Please wait..!!
Senior Data Architect
-
Posted on: Nov 17, 2026
-
Franklin, Tennessee
-
Onsite
-
Full-time
Curious about compensation?
Explore the historical salary trends, average pay, and estimated compensation for Senior Data Architect roles in Tennessee.
View Salary Guide →Find your match !
Job Title :
Senior Data Architect
Job Type :
Full-Time
Job Location :
Franklin Tennessee United States
Remote :
No
Job Description :
Job Description
Job Title: Data Architect
\nLocation: Franklin, Tennessee Onsite day 1
\nJob Type: Contract
\nJob Summary:
\nWe 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.
\nKey Responsibilities:
\nDefine and own the end-to-end data architecture for data products, from source ingestion through to consumption layers.
\nDesign and maintain conceptual, logical, and physical data models using erwin Data Modeler, ensuring consistency and alignment with enterprise standards.
\nLead the migration strategy and execution for moving data and workloads from Oracle to Snowflake, including schema conversion, data migration, validation, and performance tuning.
\nRe-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.
\nDesign and implement data products with clear ownership, documentation, SLAs, and reusability in mind.
\nEstablish and enforce data governance standards, including data quality, metadata management, lineage, cataloging, and access controls.
\nDefine data modeling standards and modern architecture patterns such as the Medallion architecture (Bronze/Silver/Gold).
\nImplement role-based access control (RBAC), data security, and compliance measures within Snowflake.
\nPartner with data engineers, analysts, and business stakeholders to align architecture with business and product goals.
\nProvide technical leadership, conduct design/code reviews, and mentor engineering teams.
\nOptimize for performance, scalability, and cost efficiency across the Snowflake platform.
\nCreate and maintain architecture documentation, data models, migration runbooks, and governance artifacts.
\nRequired Skills & Qualifications:
\nProven experience as a Data Architect designing and delivering enterprise data solutions.
\nHands-on experience implementing data products and data platform architectures.
\nStrong hands-on experience with erwin Data Modeler for designing and managing enterprise data models.
\nStrong experience in data governance (data quality, lineage, metadata, cataloging, access management).
\nPractical experience with Oracle (data modeling, PL/SQL, performance tuning).
\nWorking knowledge of Snowflake (warehouses, stages, Streams, Tasks, Stored Procedures, Time Travel, RBAC).
\nExperience with IICS (Informatica Intelligent Cloud Services) for data integration and ETL/ELT workflows.
\nHands-on experience with database/platform migration, ideally Oracle to Snowflake.
\nStrong SQL skills, including complex queries and query optimization.
\nSolid understanding of data warehousing concepts, dimensional modeling, and ELT best practices.
\nExcellent communication skills and the ability to work with both technical teams and business stakeholders.
\nGood to Have (Preferred):
\nExperience with cloud platform AWS and cloud storage (e.g., S3) for staging and integration
\nExperience with schema conversion / migration accelerator tools (e.g., SnowConvert).
\nKnowledge of Python or Snowpark for data transformation and automation.
\nExposure to CI/CD, Git-based workflows, and DataOps practices.
\nSnowPro Advanced Architect certification.
\nEducation:
\nBachelor's or master’s degree in computer science, Information Technology, Data Engineering, or a related field.
\nSimilar Jobs You May Be Interested In
Senior Data Architect
Senior Data Enterprise Architect
Senior Data Architect
Senior Data Architect (SDA)
Senior Data Architect - Enterprise Analytics
Senior Databricks Data Architect
Senior Power BI Data Architect - Mortgage Insurance
Senior Presales Architect- Data Solutions
Senior Databricks Architect & Senior Data Analyst (Databricks) - 2 Positions
Senior Data Architect (Microsoft Fabric)
Senior Data Modeler / Data Architect
Senior Data Engineer / Databricks Data Architect (TDM & Data Governance)
Position Details
Posted:
Nov 17, 2026
Reference Number:
35ac6a0647b79e02
Employment:
Full-time
City:
Franklin
Job Origin:
ziprecruiter
Share this job:
Please wait..!!

