Data Architect (Local to Ohio)

Engagement Type

Contract



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.

Required/Desired Skills

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