ETL Data Architect - Fully REMOTE - Must be LOCAL to Ohio

Interviews will be via Microsoft Teams

Key Responsibilities

Data Architecture Design

Develop and maintain enterprise data models, schemas, and standards. o Define data flows and integration patterns between systems, including cloud-native platforms such as Snowflake.

Database Management

Oversee logical and physical database design for performance and scalability. o Collaborate with DBAs on optimization, capacity planning, and Snowflake performance management.

Data Governance

Establish data quality, security, and compliance standards. o Implement metadata management and maintain a data dictionary.

Integration & ETL

Design and optimize ETL/ELT processes for data warehousing and analytics, with hands-on experience using Snowflake's ingestion and transformation capabilities. o Ensure interoperability between on-prem and cloud systems.

Collaboration

Work with business analysts, developers, and stakeholders to translate requirements into data solutions. o Provide guidance on data modeling best practices.

Performance & Security

Ensure data architecture meets performance SLAs and security requirements. o Implement encryption, access controls, and audit mechanisms across both traditional DBMS and Snowflake environments.

Innovation

Evaluate emerging technologies (cloud, big data, AI/ML) for adoption. o Recommend improvements to existing data architecture, including Snowflake optimization and new cloud capabilities.

Skill	Required /Desired	Amount	of Experience
experience in data architecture, database design, and data modeling	Required	5	Years
experience in SQL Server/Oracle or similar RDBMS	Required	5	Years
experience with Cloud Platforms(Azure, AWS)	Required	5	Years
experience with ETL tools, API's and integration framework	Required	5	Years
Expertise with modern cloud data warehouses such as Snowflake.	Required	5	Years

No.	Question
Question1	Do you understand, and will abide by, the provision in your subcontract with OST that it is PROHIBITED for government equipment to be taken or used outside of the United States by your contractors? The consequences of this occurring can and will result in repercussions to you, the prime vendor, regardless if the candidate works for a sub-vendor of yours. It will also result in immediate termination of the contractor and make them ineligible for rehire in the program.
Question2	Please note: The selected candidate(s) must accept the offered position within 48 hours of vendor notification. Failure to do so will result in DRC moving to their next candidate choice. Do you accept?
Question3	Once a candidate accepts an offered position, ALL DRC compliance items listed under the "Compliance" tab on the candidate record must be completed within 5 business days and uploaded into Vector. Failure to do so will result in DRC moving to their next candidate choice. Do you accept?
Question4	Selected candidate will be required to have a Fingerprint check performed. Does your candidate agree?
Question5	Candidates must be local to Ohio. Where does your candidate currently reside?