Data Architect

Role: Data Architect / Technical Specialist (802334)
Work Location: Remote (Must report onsite on the first day at 30 E Broad Street, 13th Floor, Columbus, OH 43215)
Interview Type: Video Interview (MS Teams)
Start Date: 07/01/2026
End Date: 06/30/2027

Short Description

This is a remote position; however, the selected candidate must report onsite on the first day to:
30 E Broad Street, 13th Floor, Columbus, OH 43215.
Interviews will be conducted via MS Teams.

Key Responsibilities

• Design and maintain conceptual, logical, and physical data models for enterprise analytics and operational systems.
• Establish and promote data modeling standards, naming conventions, and design patterns.
• Support development of the Agency’s enterprise data architecture roadmap.
• Provide architectural guidance to ensure solutions are reusable, interoperable, and aligned with integration standards.
• Lead technical discussions and define tasks related to implementation, optimization, and ongoing maintenance of data systems.
• Support integrations between agency systems and enterprise platforms including data lakes, data quality, and data curation systems.
• Provide technical leadership for best-practice solutions involving data integration, data cleansing, data classification, and data modeling.

Required Experience

• Minimum 5+ years of proven experience in:
  • Data integration
  • Data cleansing
  • Data classification
  • Data modeling
  •  
• Required / Desired Skills
  Experience with Salesforce platforms
  Experience with Microsoft Environments including Azure and Dynamics
  Demonstrated hands-on experience with Salesforce platform capabilities including Apex, Lightning Web Components, Salesforce Flow, validation rules
  Experience with Snowflake data platform
  Experience with Tableau analytics integration

Preferred Technologies / Environments

• Salesforce Platforms
• Microsoft Azure / Dynamics
• StreamSets Data Integration Pipelines
• AWS S3
• Snowflake
• Tableau
• Microsoft SQL Server

Team Environment

The TS4 will work collaboratively with Database Administrators, Data Engineers, and BI professionals while serving as a senior technical resource influencing architectural direction, data standards, and best practices across the Agency.