Data Information Architect - Contract - Columbia, SC Onsite

Job Description

Job Description

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:

Database Architecture & Development

• 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 necessary.
  
• Perform software and equipment upgrades as required.
  
• Maintain familiarity with current computer, server, and networking technologies.
  
• Follow information security guidelines and promote secure practices across the team.
  
• Manage support tickets, document issue resolution, and provide timely status updates to stakeholders.
  
• Prioritize incidents and service requests according to severity and established service levels.
  
• Participate in shared 24/7 on-call support responsibilities.
  
• Perform other duties and special projects as assigned.
  

Communication & Collaboration

• Communicate effectively with technical peers, business users, management, vendors, and stakeholders at all organizational levels.
  
• Provide feedback on product issues, enhancements, and new features.
  
• Proactively identify and implement process improvements.
  
• Manage multiple assignments simultaneously and provide regular status updates.
  
• Maintain strong customer service, attention to detail, and responsiveness to support requests.
  
• Build and maintain effective working relationships across technical and business teams.
  

Required Skills & Experience:

• 10+ years of experience in database modeling, architecture, and development.
  
• 9+ years of state government experience.
  
• 10+ years of advanced SQL experience.
  
• 5+ years of experience with Adobe Experience Manager (AEM) 6.5.
  
• 4+ years of Java development, design, and coding experience.
  
• 5+ years of experience working with Agile methodologies.
  
• Strong knowledge of relational database design, data modeling, stored procedures, and database performance optimization.
  
• Experience supporting application development, testing, deployment, and migration across multiple environments.
  
• Strong troubleshooting, analytical, and problem-solving skills.
  
• Excellent communication, organizational, and time-management skills.
  

Preferred Skills

• Experience with cloud-based solutions and infrastructure.
  
• Experience supporting enterprise application environments and data architecture modernization.
  
• Familiarity with secure web programming, continuous integration, and automated testing practices.
  

Education:
Bachelor’s or Master’s Degree in Information Technology, Computer Science, or a related field.

Preferred Certifications

• Project Management Professional (PMP) certification.
  
• Other certifications issued by the Project Management Institute (PMI).