Data Architect

End Client: State of Ohio

Job Title: Data Architect

Duration: 08/31/2026 – 06/30/2027

Location: Remote – Ohio

Hours Per Week: Full-time

Interview Type: Microsoft Teams

Job Code: 809182

Scope of Project

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.

Responsibilities

Data Architecture Design

• Develop and maintain enterprise data models, schemas, and standards.
• 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.
• Collaborate with DBAs on optimization, capacity planning, and Snowflake performance management.

Data Governance

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

Integration & ETL

• Design and optimize ETL/ELT processes for data warehousing and analytics.
• Apply hands-on experience with Snowflake ingestion and transformation capabilities.
• Ensure interoperability between on-premises and cloud systems.

Collaboration

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

Performance & Security

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

Innovation

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

Required/Preferred Skills

• Data Architecture, Database Design & Data Modeling: 5+ years — Required
• SQL Server, Oracle, or Similar RDBMS: 5+ years — Required
• Cloud Platforms such as Azure or AWS: 5+ years — Required
• ETL Tools, APIs, and Integration Frameworks: 5+ years — Required
• Modern Cloud Data Warehouses such as Snowflake: 5+ years — Required