Data Architect 1(AR1)

Job Title: Data Architect 1(AR1)
Location: Columbus, OH
Work Model: Remote
Compensation: $104-108k

POSITION OVERVIEW
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.

WHAT YOU WILL BE DOING
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.

WHAT’S NEEDED
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

COMPENSATION & BENEFITS
• Medical, dental, and vision insurance
• 401(k)
• Other standard benefits as applicable

ABOUT UNICON

UNICON is a workforce solutions provider with over 35 years of experience supporting organizations across a variety of industries. We partner with our clients to deliver skilled professionals while maintaining a strong focus on quality, compliance, and long-term relationships. UNICON is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.