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

Position is full-time remote. Interviews will be via Microsoft Teams The Data Architect is responsible for designing, implementing, and maintaining the organization's data architecture to ensure data integrity, scalability, and accessibility.

This role defines how data is stored, consumed, integrated, and managed across systems, aligning with business objectives and technology standards.

The architect will also leverage modern cloud data platforms, including Snowflake, to support advanced analytics and scalable data solutions.Key ResponsibilitiesData Architecture DesignDevelop 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 ManagementOversee logical and physical database design for performance and scalability. o Collaborate with DBAs on optimization, capacity planning, and Snowflake performance management.Data GovernanceEstablish data quality, security, and compliance standards. o Implement metadata management and maintain a data dictionary.Integration & ETLDesign 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.CollaborationWork with business analysts, developers, and stakeholders to translate requirements into data solutions. o Provide guidance on data modeling best practices.Performance & SecurityEnsure data architecture meets performance SLAs and security requirements. o Implement encryption, access controls, and audit mechanisms across both traditional DBMS and Snowflake environments.InnovationEvaluate emerging technologies (cloud, big data, AI/ML) for adoption. o Recommend improvements to existing data architecture, including Snowflake optimization and new cloud capabilities.

Required/Desired Skills SkillRequired /DesiredAmountof Experienceexperience in data architecture, database design, and data modelingRequired5Yearsexperience in SQL Server/Oracle or similar RDBMSRequired5Yearsexperience with Cloud Platforms(Azure, AWS)Required5Yearsexperience with ETL tools, API's and integration frameworkRequired5YearsExpertise with modern cloud data warehouses such as Snowflake.Required5Years Questions No.QuestionQuestion1Do 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.Question2Please 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?Question3Once 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?Question4Selected candidate will be required to have a Fingerprint check performed. Does your candidate agree?Question5Candidates must be local to Ohio.

Where does your candidate currently reside?

Remote Skills: Access Control, Application Programming Interface (API), Architectural Design, Artificial Intelligence (AI), Best Practices, Big Data, Business Analysis, Capacity and Performance Management, Cloud Computing, Cryptography, Data Analysis, Data Modeling, Data Processing, Data Quality, Data Warehousing, DataArchitect Data Modeling Tool, Database Administration, Database Design, Database Extract Transform and Load (ETL), Database Management Software/Systems (DBMS), Emerging Technology, Government, Information/Data Security (InfoSec), Interoperability, Metadata, People Management, Regulatory Compliance, Requirements Management, Service Level Agreement (SLA), Snowflake Schema, Standards Development, Systems Administration/Management undefined: RICEFW Technologies Inc