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.