Data/Information Architect
Novalink Solutions
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Job summary
South Carolina Department of Revenue (SCDOR) seeks a Data/Information Architect - Consultant for a 1-year contract in West Columbia, SC. The role focuses on data modeling, database design, and data architecture within a secured, multi-layer environment.
Candidates should have extensive experience with AEM, PBI, and enterprise data workflows. The contractor will work under limited supervision, coordinating with a functional manager and a team to ensure data integrity, server reliability, and
Qualifications
- Requires 10+ years in database modeling, architecture and development.
- Demonstrates strong data architecture and SQL development skills.
- Experience with Adobe AEM 6.5 and Java development is preferred.
Responsibilities
- Develop logical data models and data architectures for assigned applications.
- Design relational databases within architectural framework to meet needs.
- Lead database design and set standards for database access and error handling.
- Create and maintain SSIS packages and database scripts.
- Collaborate with developers and end users to ensure data stability and performance.
Skills
Education
Tools
Job description
West Columbia, United States | Posted on 10/13/2026
- Actual Job Title Data/Information Architect - Consultant
- Job Type FT Contract
- Contract duration 1 year
- Date Opened 10/13/2026
- Target Date 10/19/2026
- City West Columbia
- State/Province South Carolina
- Country United States
- Assigned Recruiter(s) Pranali Chaudhari
- Number of Positions 1
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.
A strong and healthy organizational culture will drive our efforts and lead to
success for all stakeholders. SCDOR strives to exemplify a culture that
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
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
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
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
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
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
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
Skill Type
Skill Name
Experience with cloud-based solutions
PMI Issued PMP or other PMI Issued Certification
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
