What are the responsibilities and job description for the Data Architect position at Integrated Technology Strategies, Inc.?
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.