Data Architect

W2 Contract | Data Architect 1 – Remote Opportunity | Ohio Local Only

• Job Title: Data Architect 1 (AR1)
• Job Location: Ohio – Remote
• Work Mode: Remote
• Job Type: Contract

• Job Overview
• We are seeking an experienced Data Architect to design, implement, and maintain enterprise data architecture that ensures data integrity, scalability, security, and accessibility. The ideal candidate will have strong expertise in data modeling, database architecture, cloud platforms, ETL/ELT, and modern cloud data warehouses such as Snowflake.
• Key Responsibilities
• Develop and maintain enterprise data models, schemas, standards, and data architecture.
• Define data flows and integration patterns across enterprise systems and cloud-native platforms.
• Design logical and physical databases for performance, scalability, and reliability.
• Collaborate with DBAs on database optimization, capacity planning, and performance management.
• Establish data quality, security, compliance, metadata management, and data dictionary standards.
• Design and optimize ETL/ELT processes for data warehousing and analytics.
• Utilize Snowflake ingestion and transformation capabilities.
• Ensure interoperability between on-premises and cloud environments.
• Collaborate with business analysts, developers, and stakeholders to translate requirements into scalable data solutions.
• Provide guidance on data modeling and architecture best practices.
• Ensure data architecture meets performance SLAs and security requirements.
• Implement encryption, access controls, and auditing mechanisms across database and cloud data environments.
• Evaluate emerging cloud, big data, and AI/ML technologies and recommend architectural improvements.
• Optimize Snowflake environments and identify opportunities to leverage modern cloud capabilities.

• Required Qualifications
• 5+ years of experience in data architecture, database design, and data modeling.
• 5+ years of experience with SQL Server, Oracle, or similar RDBMS.
• 5+ years of experience with cloud platforms such as Azure and AWS.
• 5+ years of experience with ETL tools, APIs, and integration frameworks.
• 5+ years of experience/expertise with modern cloud data warehouses, particularly Snowflake.
• Strong understanding of data governance, security, integration, and performance optimization.
• Excellent collaboration and communication skills.

Key Skills

Data Architecture | Data Modeling | SQL Server | Oracle | Azure | AWS | Snowflake | ETL/ELT | APIs | Data Integration | Data Governance | Database Design | Cloud Data Warehousing | Data Security | Metadata Management