Data Information Architect Columbia, SC Onsite

Full time | SUNSHINE ENTERPRISE USA LLC | United States

Posted On 10/18/2026

IT Services

Work Experience 4-5 years

City Columbia

State/Province South Carolina

29212

Data Information Architect

Location:

Columbia, SC Onsite

Interview Process: 1 Round of Onsite Interviews
Duration: 12 Months

Employment Type:

Contract
Experience

Required:

10+ Years

Candidate location: Candidate must be a CURRENT SC resident. No relocation allowed.

Project Scope:

The Systems Software Programmer – AEM, Power BI & Data Architecture will support the development, maintenance, and optimization of enterprise applications, data architecture, database systems, and reporting solutions. The role requires extensive experience in database modeling, relational database design, advanced SQL development, Adobe Experience Manager (AEM) 6.5, Java development, and Agile methodologies.

Working under limited supervision and reporting to a functional manager, the contractor will collaborate with application developers, business users, technical teams, and vendors to maintain data integrity, improve application performance, support system deployments, and ensure reliable server and database services. The role also involves developing technical documentation, supporting application testing and migrations, following secure programming practices, and participating in shared 24/7 on-call support.

Key Responsibilities:

• Design and maintain logical data models and data architecture for assigned applications in collaboration with consultants, application developers, and end users.
• Design relational databases within established architectural frameworks to meet application requirements.
• Serve as the lead database designer for assigned application systems.
• Develop, implement, and maintain database design standards and best practices.
• Write and maintain stored procedures, database scripts, and other database access components.
• Establish standards for stored procedures, object-relational mapping (ORM), database access, and application-level database error handling.
• Develop database utilities and SQL Server Integration Services (SSIS) packages as required.
• Analyze anticipated data volumes, usage patterns, and business requirements to improve database performance and efficiency.
• Collaborate with database administrators to troubleshoot and resolve database performance issues.

Application Development & System Support

• Support application developers in resolving database-related issues in development and production environments.
• Configure system settings and options to meet technical and business requirements.
• Plan and execute unit, integration, and user acceptance testing activities as applicable.
• Prepare system specifications, programming documentation, and technical documentation for review and approval.
• Assist with application deployment across Development, QA, and Production environments.
• Support application migrations, upgrades, and deployment activities.
• Follow secure web programming practices, coding standards, unit test coverage requirements, automation practices, and continuous integration procedures.
• Collaborate with internal teams and vendors to maintain effective site architecture, system performance, reliability, and content delivery.
• Support Adobe Experience Manager (AEM) and Power BI solutions used for forms, workflows, dashboards, and reporting.

Operational & Technical Responsibilities

• Monitor, maintain, support, and optimize server infrastructure, data services, and related systems.
• Troubleshoot technical issues and recommend appropriate solutions for customer and application support requests.
• Troubleshoot backup configuration and recovery issues and develop workarounds when…