Senior Data Architect
Arbor TekSystems
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.
- Find a JobJoin IDR Internal TeamStaffing ServicesConsultantsAbout UsBlogSenior
- Job Description Job Description About Carvana At Carvana, we sell cars but we aren't car salesmen. Our promise is simple: we won't sell a car to a customer that we wouldn't sell to our own Mom. Period. To make sure our cars are in first-rate condition, we'...SeniorHourly payPrice workFull timeImmediate startAfternoon shift
- EnableComp LLC in Franklin, TN seeks a visionary VP of Implementation to oversee client onboarding, system integrations, and service delivery. You will lead an implementation team and ensure timely delivery, while aligning executive stakeholders to maximize client satisfaction...Senior
- 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
- Soni Resources Group is seeking an experienced Accounts Payable Specialist to join our Franklin, TN team. The role focuses on accurate invoice processing, discrepancy resolution, and vendor account reconciliation in a fast-paced environment. Responsibilities include reviewing...Senior
- ...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
- Schneider Electric USA, Inc. seeks an Advanced Product Owner - Integrated Residential Energy Systems in Franklin, TN. You will lead strategy, development, and the product roadmap for integrated residential energy solutions, aligning multiple divisions and stakeholders to...SeniorRemote job
- ...admissions and transfers, and document care with accuracy to maintain safety and dignity. Ideal candidates hold Tennessee LPN/LVN licensure, BLS certification, strong clinical skills, and excellent communication. ACLS is preferred. #J-18808-Ljbffr Triple Crown Senior LivingSeniorPart timeNight shift
- ...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
- Wellpath is seeking a Senior Director of Artificial Intelligence to shape and lead our enterprise AI strategy across clinical and business operations. You will drive innovation, governance, and scalable AI implementations with measurable outcomes. This role requires deep...Senior
- Innovative Renal Care is seeking a Vice President of Corporate Development to lead the company’s inorganic growth strategy across the US market. This remote role reports to the CGO and drives sourcing, evaluation, negotiation, and closing of acquisitions, divestitures, ...SeniorRemote job
- Community Health Systems, Inc. is seeking a Principal Engineer for Unified Communications, focusing on Cisco Webex Dedicated Instance architecture across global sites. You will drive design, standards, and strategic direction, while hands-on implementing voice, video, and...SeniorRemote work
- Maximum Salary (US): 193000Minimum Salary (US): 131000Job 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...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
- ...Southall Farm & Inn is a premier destination bringing nature, produce and people together in a powerful and unique way. The Senior Food & Beverage Manager is responsible for upholding the highest standards of luxury hospitality, with a particular focus on Forbes...SeniorWeekly payFull timeTemporary workPart timeSeasonal workWeekend workAfternoon shift
- Charter Senior Living of Franklin is seeking a Licensed Practical Nurse (LPN) for PRN opportunities with 16-hour shifts (6am-10pm) in Franklin, Tennessee. You will provide compassionate nursing care to residents in Assisted Living and Memory Care settings, perform assessments...SeniorReliefFlexible hoursShift work
- ...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
- Schneider Electric is seeking a Senior Manager, Strategic Supplier Leader for its North America contract manufacturing network. The role drives supplier partnerships, commercial strategy, and capabilities to enable growth, productivity, and risk management across a multi...SeniorContract work
- Legacy Healthcare Services, Inc. is seeking a Physical Therapy Assistant (PTA) for a weekend PRN role at Charter Senior Living of Franklin. The PTA will join an on-site rehab care team, delivering patient-centered therapies to senior residents and collaborating with clinicians...SeniorReliefWeekend work
- 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
- Vitality Living Group seeks a Wellness Coordinator to lead the wellness team and ensure residents receive compassionate, dignified care. You will help maintain staffing schedules, coordinate coverage for absences, and support smooth transitions for new residents into the...Senior
- ...Drive, Franklin, TN 37064. We offer On-Demand Pay, a 401(k) retirement plan, and opportunities for professional growth in a supportive environment. This position emphasizes dignity, comfort, and high-quality care for residents. #J-18808-Ljbffr Triple Crown Senior LivingSeniorPart timeDay shift
- 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
- ...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
- NTT DATA Services in Franklin, TN is seeking a Senior Tax Analyst to support the corporate Tax Department with tax accounting, compliance, research, planning, and special projects. This role collaborates with Tax, Accounting, and Finance teams to ensure accurate and timely...SeniorRemote jobWork at office
- ...relevant certifications like CNA or HHA, and experience in caregiving. Benefits include competitive pay, health insurance starting at $75/month, and a $1,000 employee referral bonus. Join us in making a difference in the lives of seniors! #J-18808-Ljbffr Somerby FranklinSeniorFull timePart time
- Somerby Franklin is looking for dedicated Care Associates to join our team in Franklin, TN. In this role, you'll assist residents with Activities of Daily Living (ADL) and ensure their comfort and care. Ideal candidates should have a high school diploma and relevant certifications...SeniorDaily paidAfternoon shift
- 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
- ...Senior Vice President of Litigation & Risk Management About the Company National healthcare organization providing medical, dental... ...risk-management processes, and developing the necessary data and reporting capabilities to support financial forecasting and...Senior
- ...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
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 software design engineer Franklin, TN
- senior manager accenture Franklin, TN
- senior accountant remote Franklin, TN
- senior devops engineer remote Franklin, TN
- international tax senior Franklin, TN
- senior activities Franklin, TN
- srs Franklin, TN
- senior net developer remote Franklin, TN
- senior financial analyst fp&a Franklin, TN







