Senior Data Architect
Arbor TekSystems
Job Description
Job Title: Data Architect
Location: Franklin, Tennessee Onsite day 1
Job Type: Contract
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 quality, lineage, metadata, cataloging, access management).
Practical experience with Oracle (data modeling, PL/SQL, performance tuning).
Working knowledge of Snowflake (warehouses, stages, Streams, Tasks, Stored Procedures, Time Travel, RBAC).
Experience with IICS (Informatica Intelligent Cloud Services) for data integration and ETL/ELT workflows.
Hands-on experience with database/platform migration, ideally Oracle to Snowflake.
Strong SQL skills, including complex queries and query optimization.
Solid understanding of data warehousing concepts, dimensional modeling, and ELT best practices.
Excellent communication skills and the ability to work with both technical teams and business stakeholders.
Good to Have (Preferred):
Experience with cloud platform AWS and cloud storage (e.g., S3) for staging and integration
Experience with schema conversion / migration accelerator tools (e.g., SnowConvert).
Knowledge of Python or Snowpark for data transformation and automation.
Exposure to CI/CD, Git-based workflows, and DataOps practices.
SnowPro Advanced Architect certification.
Education:
Bachelor's or master’s degree in computer science, Information Technology, Data Engineering, or a related field.
- ...What Our Client Needs Our client is seeking a Principal / Senior Mechanical Engineer to lead the design, development, and optimization... ...controls, and risk management. You work independently, analyze data rigorously, manage competing priorities, and communicate...SeniorTemporary workFlexible hours
- ...Senior Estimator The Senior Estimator assists the preconstruction team through the development of cost estimates, value management, and estimate proposal reports. The position requires the knowledge and expertise to quantify, price and qualify all building systems...SeniorFor contractorsFor subcontractor
- ...SHR Talent is partnering with a residential homebuilding client in Nashville, TN in its search for a Senior Accountant. This is a primarily onsite opportunity offering significant long-term growth potential for an experienced accounting professional who wants broad exposure...Senior
- Nissan is seeking a Senior Paralegal in Franklin, TN to support litigation matters, supervise outside counsel, and craft defense or settlement strategies. The role requires strong state and federal court knowledge and effective communication with diverse teams. Candidate...SeniorWork at office
- Maristone of Franklin is seeking a Life Engagement Director to develop, implement, and oversee a comprehensive program that enriches residents' physical, emotional, spiritual, social, and intellectual well-being at 347 Riverside Drive, Franklin, TN. Responsibilities include...Senior
- ...Position Summary: The Senior AI Engineer is a hands-on individual contributor who builds, trains, and evaluates machine learning models. The role combines knowledge engineering and data analysis with applied reinforcement learning, and owns work end to end, from data...SeniorFull timeRemote work
- Job SummaryThe Senior Project Manager is responsible for overseeing and managing projects while also serving as the Scrum Master, specializing in Project Management Change Management and Agile Methodology. The primary responsibilities include ensuring successful project...Senior
- ...Civil Constructors is looking for a Senior Estimator to join our team. Essential Duties and Responsibilities Analyze construction drawings and project specifications to prepare accurate cost estimates. Interpret and understand contract terms and conditions...SeniorContract workFor subcontractor
- Publicis Digital Experience is seeking a seasoned marketer to manage direct and digital programs for automotive clients. You will coordinate production schedules, client communications, and performance reporting while guiding project delivery and budgets. Strong multitasking...Senior
- Publicis Groupe seeks a Client Account Executive in a hybrid Franklin, TN setting to coordinate multi-channel campaigns and manage timelines. You will partner with Creative, Analytics, and Legal teams to ensure timely, high-quality deliverables and clear client communications...Senior
- ...Senior Teller PositionPosition at FirstBankThe Senior Teller serves as a first point of contact for customers by providing FirstBank service excellence, processing transactions in accordance with bank policies and procedures, assisting with customer inquiries, and recognizing...SeniorBank staff
- Position Summary: This position is responsible for the day-to-day administrative operations of the clinical staff of Bone and Joint Institute of Tennessee. Duties include hiring, training, annual evaluations and doing corrective actions with the clinical staff of Bone...SeniorWork at officeFlexible hours
- ...into clear and actionable requirements, identifying process and data dependencies, and ensuring development teams have the... ...with business stakeholders, subject matter experts, developers, architects, and other technical teams. Elicit, analyze, document, and validate...Senior
- Position Title Maintains strong client relationships and, in conjunction with the Sr. Account Director, plans, coordinates, and directs the client-approved strategic direction for assigned projects. Key Responsibilities • Functions as primary contact and liaison...SeniorWork at officeFlexible hours3 days per week
- ...Responsibilities ECS Limited is seeking an experienced Geotechnical Senior Project Engineer to manage key client projects in our Nashville... ...Supervise field exploration programs and interpret geotechnical data from boring layouts, utility clearances, and laboratory tests....SeniorWork at office
- Job Summary The Senior Technical Lead is a pivotal role within our development team, responsible for managing technology in complex... ...Certified: Azure Developer Associate (Optional But Valuable). 2. Microsoft Certified: Azure Solutions Architect Expert (Optional But Valuable).Senior
- Job SummaryThe Senior Technical Lead is responsible for overseeing and leading technical projects involving Google BigQuery, SQL, Python, Google dataflow, and CA Erwin Data Modeler. The role involves driving the technical design, development, and implementation of solutions...Senior
- Maximum Salary (US): 198000Minimum Salary (US): 114000Job Summary The Senior Technical Specialist in DevOps Solutions, React.js, full stack java is responsible for providing expertise in designing, developing, and implementing technical solutions using DevOps practices...Senior
- ...across North America, andwe'relooking for talented people to grow with us. Position Summary Details Xsolis is hiring a Senior Manager, Data Science to set the vision for how we use predictive, generative and agentic AI, and to build and lead the team that delivers...Senior
- ...About the role: The Senior Strategy and Value Creation Associate will be responsible for leading and executing critical strategy projects... ...with functional leaders Perform analysis with company data to drive to critical insights Socialize and implement findings...SeniorLocal area
- Responsible for planning, managing and coordinating multiple public and private construction projects. Responsible for the conceptual development of a construction project and oversee its organization, scheduling, budgeting, and implementation while developing the best...SeniorFull timeContract workFor subcontractorLocal area
- ...automation technologies used to deliver business and clinical solutions. This role will work closely with Solution Architects, Full Stack Developers, Data Engineers, Automation Developers, Automation Analysts, infrastructure teams, security teams, and application owners...Senior
- ...Position Summary: The Senior AI Engineer is a hands-on individual contributor who builds, trains, and evaluates machine learning models. The role combines knowledge engineering and data analysis with applied reinforcement learning, and owns work end to end, from...SeniorRemote work
$300k - $350k
...Senior Retirement Advisor with Summit Wealth Strategies $120,000 base salary + benefits + new-business and ongoing client-service bonuses $200,000-$250,000 first year target total compensation Build Your Career. Help Build the Future of Summit. Summit Wealth...SeniorFull time- ...Senior Paralegal Location(s): Franklin, TN Job Schedule: Full-time – Hybrid - in office Monday-Thursday Education Requirement: Bachelor's and Professional Certification as a paralegal from an ABA certified program. Sponsorship: No Come Drive Innovation...SeniorFull timeWork at officeLocal area
- ...Senior Consultant Company: Specialist Resources Global, Inc Location: 318 Seaboard Lane, Ste. 110, Franklin, TN 37067 Position... ...improvement. This role combines client engagement, technical diagnostics, data analysis, and coordination of deployments to support business-...SeniorRemote work
- ...(GCP).Build and maintain microservices-based architectures and RESTful APIs.Collaborate with Business Analysts, Product Owners, Architects, and QA teams throughout the Software Development Lifecycle (SDLC).Participate in application modernization and cloud migration initiatives...Senior
- ...Job Overview The Senior Estimator assists the preconstruction team through the development of cost estimates, value management, and estimate proposal reports. The position requires the knowledge and expertise to quantify, price and qualify all building systems and...SeniorFull timeFor contractorsFor subcontractorSecond jobLocal areaImmediate start
- Citrix Administrator, Senior The Citrix Administrator, Senior serves as a subject matter expert responsible for the architecture, implementation, and optimization of our enterprise Citrix infrastructure. Operating heavily within a Citrix App Layering and Citrix NetScaler...Senior
- Job Summary The Senior Technical Lead (.net,azure,c#) will be responsible for leading the technical team in designing, developing,... ...specified timelines. Key Responsibilities 1. Lead the team in architecting, designing, and implementing scalable and secure .net...Senior
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Data Architect. Be the first to apply!
- senior living Franklin, TN
- senior accountant manufacturing Franklin, TN
- senior magento developer Franklin, TN
- senior software design engineer Franklin, TN
- senior manager accenture Franklin, TN
- senior accountant remote Franklin, TN
- senior software engineer Franklin, TN
- senior devops engineer remote Franklin, TN
- international tax senior Franklin, TN
- senior activities Franklin, TN






