Data Architect Job Columbia South Carolina USA,IT/Tech

Columbia, United States | Posted on 10/14/2026

Client Name South Carolina Department of Revenue
Date Opened 10/14/2026
Job Type Contract
Required Skills
- State Government Experien...
Work Experience 10 years
Final date to receive applications 10/20/2026 16:00
No. of Hours 2080
Target Date 11/17/2026
Contract End Date 11/17/2027
Industry Government & Public Sector
City Columbia
State/Province South Carolina
Country United States

Job Description

This is an onsite role; only local candidates will be considered.

The Data Architect will support the South Carolina Department of Revenue. This role provides expertise in enterprise data architecture, advanced SQL development, Adobe Experience Manager (AEM) 6.5, and Java application development within an agency environment that uses AEM and Power BI for forms, workflows, dashboards, and reporting. Working under limited supervision, the Data Architect will collaborate with developers, consultants, database administrators, business users, and agency leadership to design, develop, maintain, optimize, and support critical agency technology systems.

The role is technically hands-on and combines database design, application development, system integration, and production support. The Data Architect will also participate in Agile development activities and shared 24/7 on-call support.

Responsibilities

Design and develop logical data models and relational database architectures, serving as lead database designer for assigned application systems.
Develop and implement database design standards, including standards for stored procedures, database access, and error handling.
Write, maintain, and optimize advanced SQL queries, stored procedures, SSIS packages, database scripts, and supporting utilities.
Analyze data volumes, application usage patterns, and database performance, and partner with database administrators to resolve performance issues.
Support Adobe AEM 6.5 applications and related workflows, and perform Java application development, design, and coding activities.
Support Power BI reporting and dashboard technology, and configure system settings and application options as needed.
Develop technical specifications and system documentation, and plan and execute unit, integration, and acceptance testing.
Assist with deployments and application migrations across Development, QA, and Production environments while following secure development and deployment practices.
Investigate and resolve application and production issues, troubleshoot backup and recovery problems, perform software upgrades, and develop technical workarounds when appropriate.
Maintain accurate Helpdesk documentation and ticket updates, provide timely status updates, and communicate effectively with technical peers, business users, IT leadership, and outside vendors.

Requirements

Minimum Qualifications

10 years of experience in database modeling, architecture, and development.
Experience designing logical and relational data models.
Experience implementing database architecture and design standards.
9 years of state government experience.
Direct experience supporting state government technology environments.
Understanding of state agency operations and enterprise application requirements.
10 years of advanced SQL experience.
Experience with database optimization and troubleshooting.
Experience with relational database development.
5 years of Adobe Experience Manager (AEM) 6.5 experience.
Hands-on experience supporting, developing, or maintaining applications using AEM.
Understanding of AEM-based enterprise application environments.
4 years of Java development, design, and coding experience.
Experience developing and maintaining enterprise applications.
Experience troubleshooting and supporting Java-based systems.
5 years…