IT - SCDOR - Data/Information Architect - Consultant

Abacus Service Corporation
  • Columbia, SC
  • Instant Apply
Today

Job Description

Position Information

Position Type Staff Augmentation Hours/Week 40
Billing Type Hourly Shift Day
Projected Start Date 11/17/2026 Start Time 8:00 AM
Projected End Date/Duration 12 Months from projected start date End Time 5:00 PM
Bid Limit Per Vendor 2 Number of Positions 1
Desired Career Level Experienced Non-manager Minimum Education Level Bachelor's Degree
Weekend None

Position Location

Address 300A Outlet Pointe Blvd City Columbia
State South Carolina Zip 29210
Country UNITED STATES

Requirements

Travel Required No Security Required Yes
Onboarding Category

The following are required for bid submission:
  • Resume
  • R2R
  • Cover Letter
  • Meets Work Location

Position Description

Please ensure you attach the SC Cover Sheet (attached), a valid Right to Represent, and the candidate's resume with full legal first name, and last name. Posting attachments should be named as AttachmentName_PostingID_LastName_FirstName. Ex: Resume_1234_Last_First, RTR_1234_Last_First, Coversheet_1234_Last_First

Withdrawn candidates will not be permitted to be replaced. If you would like to use a sub vendor, only 1 level deep, please submit the Sub Vendor usage form.

The State of South Carolina is looking for a Data/Information Architect - Consultant
Why is this position open: Rebid for an incumbent currently in the position.
Will close to submissions on October 20th, 2026, 5:00PM EST.
Interview Process: 1 Round of Onsite Interviews
Duration of the Contract: 12 Months
Possibility for Extension: Yes
Work Location: Fully Onsite
Candidate location: Candidate must be a CURRENT SC resident. No relocation allowed.

Scope of the project:

DOR has implemented Adobe Experience Manager (AEM), and Power Business Intelligence (PBI) as its tool set for forms, workflow and Dashboard/Report development. DOR wishes to engage a systems software programmer experienced in AEM, PBI and Data Architecture. The following description details the skills and tasks that are required of the systems software programmer.

Under limited supervision, the contractor will serve as a systems software programmer reporting directly to a functional manager. Contractor will be a team member that ensures the stability and integrity of data, and server services through monitoring, maintenance, support, and optimization of all server infrastructure. This individual has 24/7 on-call responsibilities shared with the group.

KEY DUTIES AND RESPONSIBILITIES:


Works with consultants, application developers and end users to develop the logical data model and data architecture of assigned application. Designs relational databases within the architectural framework to meet application needs. Serves as lead database designer for assigned application systems. Develops and implements standards for database design.

Writes and maintains stored procedures as needed; develops standards for the use of stored procedures, object relational mappers, and other means of database access. Develops standards for application handling of databases, including error handling. Builds database utilities as needed for application use, such as SQL Server Integration Services (SSIS) packages and database scripts.

Analyzes anticipated data volumes and patterns of use; gains knowledge of agency data usage to improve efficiency of database access and manipulation.
Supports application developers. Assists application developers in resolving database related application problems, both in development and in production. Works with Database Administration to resolve database performance problems
Prepares and obtains approval of system and programming documentation.
Configure system settings and options; plans and executes unit, integration and acceptance testing and creates specifications for systems to meet business requirements
Assist in deploying applications to Dev, QA, Production environments and migrations. Follow best practices for secure web programming and deployment. Adhere to internal best practices with respect to coding standards, unit test coverage, automation, and continuous integration.
Work closely with Team or vendor to ensure sound practices regarding site architecture, performance and reliability, and content delivery are in place.
Perform duties and responsibilities in a manner consistent with our mission, values, and client service standards.
Pre-employment Checks
At a minimum, Suppliers will run:
" Nationwide criminal history check, which must include Federal, State, and County records for the states (or countries if applicable) where the Supplier's employee has resided in the past seven years
" Credit history check
" E-Verify

All hired contractors will have their South Carolina tax history checked. Contractors must be current on filings and payments.

Daily Duties / Responsibilities:

Non-Technical
- Effectively interact and communicate with peer to Director-level IT professionals.
- Provide feedback to team regarding product issues, enhancements and new features.
- Must have initiative, drive and be a self-starter.
- Ability to ask pertinent questions of others.
- Proactively seek to identify, communicate and implement process related improvements.
- Effectively manage multiple tasks and activities concurrently and able to provide periodic status updates to key stakeholders
- Collaborate extensively with peers and management to resolve client issues while actively contributing to a growing knowledge network that improves the effectiveness of our team and the information available to our clients.
- Prioritize numerous issues of varying severity, and effectively manage the resolution of all issues within accepted service levels. This includes ownership of the data entered into the Helpdesk system and appropriately updating both client and appropriate employees of status of all issues on a timely basis.
- Good customer skills, be attentive to detail, and responsive to customer tickets.

Technical
- Troubleshoot and recommend technical solutions for customer issues related to backup configuration and recovery.
- Develop workaround solutions as appropriate.
- Perform equipment and software upgrades
- Maintain familiarity with current computer and network products
- Adhere to corporate information security guidelines and promote information security among coworkers
- Performs other duties and special projects as assigned.

Required Skills (rank in order of Importance):
" 10+ Years of database modeling, architecture, and development experience\
" 9+ Years of State Government Experience
" 10+ Years of advanced SQL experience
" 5+ years Adobe AEM 6.5 version
" 4+ years of Java development, design and coding experience.
" 5+ Years of Experience with Agile methodology Preferred Skills (rank in order of Importance):
" Experience with cloud-based solutions

Additional Skills:
" Ability to establish and maintain good working relationships with business users, management, vendors, and peers.
" Strong organizational, multi-tasking, and time-management skills.
" Hands on business knowledge of business processes
" Ability to communicate clearly and concisely, both orally and in writing.

Required Education/Certifications:
" Bachelor's or Master's in Information Technology or related field

Preferred Education/Certifications:
PMP or other PMI Issued Certification

Required Skills

Skill Type
Skill Name
10+ Years of database modeling, architecture, and development experience
9+ Years of State Government Experience
10+ Years of Advanced SQL Experience
5+ years Adobe AEM 6.5 version
4+ years of Java development, design and coding experience.
5+ Years of Experience with Agile methodology
Bachelor's or Master's in Information Technology or related field

Preferred Skills

Skill Type
Skill Name
Experience with cloud-based solutions
PMI Issued PMP or other PMI Issued Certification

Attachment :
Statement of Work (SOW) for Contingent Labor Request
Team Size: 9 Dress Code: Business Casual
Primary Work Location:
300 A Outlet Point Blvd, Columbia, SC 29210
Secondary Work Location:
None
# of Openings: 1 How Many resumes do you want to
review at one time? All Qualified
Company / Department Culture
The SC Dept. of Revenue is among the most sought-after agency in the state sector for contractors due to our reputation for accomplishing highly complex technology in a multi-layer secured environment. We are known for requiring skilled and professional workers that can get the job done well and on time. Our team is creative and hardworking. The DOR technology division implements technology using effective methodology and procedures, and we appreciate the insights and best practices that contractors bring with them.

Company Culture:

A strong and healthy organizational culture will drive our efforts and lead to success for all stakeholders. SCDOR strives to exemplify a culture that embodies:
  • Excellence demonstrated by focusing on proactive customer service.
  • Open Communication demonstrated through vibrant two-way communication with stakeholders.
  • Functional Security demonstrated through the protection of taxpayer information.
  • Leadership demonstrated by modeling integrity, ethical behavior, and the highest standards of conduct.
  • Visionary and Innovative planning and problem solving.
  • Ownership of problems by taking responsibility for actions and performance.
  • Accountability demonstrated through performance metrics and evaluations.
  • Collaboration among teams for everyday process improvement.
  • Empowering Employees to make a positive difference by enhancing their
skills and knowledge, as well as recognizing their contributions.
  • Professionalism demonstrated by competent, resourceful, accountable, and courteous employees.
Why is this position open?

This is a 3-year reposting for an existing contractor position. The incumbent contractor is likely to reapply.
Scope of the project:
DOR has implemented Adobe Experience Manager (AEM), and Power Business Intelligence (PBI) as its tool set for forms, workflow and Dashboard/Report development. DOR wishes to engage a systems software programmer experienced in AEM, PBI and Data Architecture. The following description details the skills and tasks that are required of the systems software programmer.

Under limited supervision, the contractor will serve as a systems software programmer reporting directly to a functional manager. Contractor will be a team member that ensures the stability and integrity of data, and server services through monitoring, maintenance, support, and optimization of all server infrastructure. This individual has 24/7 on-call responsibilities shared with the group.

KEY DUTIES AND RESPONSIBILITIES:


Works with consultants, application developers and end users to develop the logical data model and data architecture of assigned application. Designs relational databases within the architectural framework to meet application needs. Serves as lead database designer for assigned application systems. Develops and implements standards for database design.

Writes and maintains stored procedures as needed; develops standards for the use of stored procedures, object relational mappers, and other means of database access. Develops standards for application handling of databases, including error handling. Builds database utilities as needed for application use, such as SQL Server Integration Services (SSIS) packages and database scripts.

Analyzes anticipated data volumes and patterns of use; gains knowledge of agency data usage to improve efficiency of database access and manipulation.
Supports application developers. Assists application developers in resolving database related application problems, both in development and in production. Works with Database Administration to resolve database performance problems
Prepares and obtains approval of system and programming documentation.
Configure system settings and options; plans and executes unit, integration and acceptance testing and creates specifications for systems to meet business requirements
Assist in deploying applications to Dev, QA, Production environments and migrations. Follow best practices for secure web programming and deployment. Adhere to internal best practices with respect to coding standards, unit test coverage, automation, and continuous integration.
Work closely with Team or vendor to ensure sound practices regarding site architecture, performance and reliability, and content delivery are in place.
Perform duties and responsibilities in a manner consistent with our mission, values, and client service standards.
Pre-employment Checks
At a minimum, Suppliers will run:
  • Nationwide criminal history check, which must include Federal, State, and County records for the states (or countries if applicable) where the
Supplier's employee has resided in the past seven years
  • Credit history check
  • E-Verify
All hired contractors will have their South Carolina tax history checked. Contractors must be current on filings and payments.
Daily Duties / Responsibilities:
Non-Technical
  • Effectively interact and communicate with peer to Director-level IT professionals.
  • Provide feedback to team regarding product issues, enhancements and new features.
  • Must have initiative, drive and be a self-starter.
  • Ability to ask pertinent questions of others.
  • Proactively seek to identify, communicate and implement process related improvements.
  • Effectively manage multiple tasks and activities concurrently and able to provide periodic status updates to key stakeholders
  • Collaborate extensively with peers and management to resolve client issues while actively contributing to a growing knowledge network that improves the effectiveness of our team and the information available to our clients.
  • Prioritize numerous issues of varying severity, and effectively manage the resolution of all issues within accepted service levels. This includes
ownership of the data entered into the Helpdesk system and appropriately

updating both client and appropriate employees of status of all issues on a timely basis.
  • Good customer skills, be attentive to detail, and responsive to customer tickets.
Technical
  • Troubleshoot and recommend technical solutions for customer issues related to backup configuration and recovery.
  • Develop workaround solutions as appropriate.
  • Perform equipment and software upgrades
  • Maintain familiarity with current computer and network products
  • Adhere to corporate information security guidelines and promote information security among coworkers
  • Performs other duties and special projects as assigned.
Required Skills (rank in order of Importance):
  • 10+ Years of database modeling, architecture, and development experience
  • 9+ Years of State Government Experience
  • 10+ Years of Advanced SQL Experience
  • 5+ years Adobe AEM 6.5 version
  • 4+ years of Java development, design and coding experience.
  • 5+ Years of Experience with Agile methodology
Preferred Skills (rank in order of Importance):
  • Experience with cloud-based solutions
Additional Skills:
  • Ability to establish and maintain good working relationships with business users, management, vendors, and peers.
  • Strong organizational, multi-tasking, and time-management skills.
  • Hands on business knowledge of business processes
  • Ability to communicate clearly and concisely, both orally and in writing.
Required Education/Certifications:
  • Bachelor's or Master's in Information Technology or related field
Preferred Education/Certifications:
PMP or other PMI Issued Certification



By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at Privacy Policy - Abacus.

Numbers & Facts

LocationColumbia, SC

Skills

  • Acceptance Testingunmatched
  • Adobe Product Familyunmatched
  • Agile Programming Methodologiesunmatched
  • Best Practicesunmatched
  • Business Intelligenceunmatched
  • Business Processesunmatched
  • Cloud Computingunmatched
  • Coding Standardsunmatched
  • Communication Skillsunmatched
  • Computer Networksunmatched
  • Computer Securityunmatched
  • Consultingunmatched
  • Content Delivery/Distributionunmatched
  • Continuous Integrationunmatched
  • Customer Relationsunmatched
  • Customer Support/Serviceunmatched
  • Data Analysisunmatched
  • Data Modelingunmatched
  • Data Qualityunmatched
  • Data Recoveryunmatched
  • Database Administrationunmatched
  • Database Architectureunmatched
  • Database Designunmatched
  • Documentationunmatched
  • Error Handlingunmatched
  • Establish Prioritiesunmatched
  • Help Deskunmatched
  • Information Architectureunmatched
  • Information Technology & Information Systemsunmatched
  • Information/Data Security (InfoSec)unmatched
  • Integration Testingunmatched
  • Javaunmatched
  • Leadershipunmatched
  • Multitaskingunmatched
  • Object Relational Mapping (ORM)unmatched
  • On Callunmatched
  • Organizational Cultureunmatched
  • Organizational Skillsunmatched
  • Performance Analysisunmatched
  • Performance Metricsunmatched
  • Problem Solving Skillsunmatched
  • Process Improvementunmatched
  • Production Systemsunmatched
  • Project Estimatesunmatched
  • Quality Assuranceunmatched
  • Reporting Dashboardsunmatched
  • Requirements Managementunmatched
  • Resolve Customer Issuesunmatched
  • SQL (Structured Query Language)unmatched
  • SQL Server Integration Services (SSIS)unmatched
  • Scripting (Scripting Languages)unmatched
  • Secure Codingunmatched
  • Software Administrationunmatched
  • Software Designunmatched
  • Software Developmentunmatched
  • Software Engineeringunmatched
  • Software Upgradesunmatched
  • Standards Developmentunmatched
  • State Governmentunmatched
  • Stored Proceduresunmatched
  • Systems Maintenanceunmatched
  • Systems/Internals Programmingunmatched
  • Test Automationunmatched
  • Test Plan/Scheduleunmatched
  • Testingunmatched
  • Time Managementunmatched
  • Unit Testunmatched
  • Web Programmingunmatched
  • Willing to Travelunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder