IT - SCDOR - Data/Information Architect - Consultant

Elite WorkForce•Columbia, SC

1d•Onsite

About The Position

The State of South Carolina is seeking a Data/Information Architect consultant for the South Carolina Department of Revenue (SCDOR). The contractor will work under limited supervision, report directly to a functional manager, and serve as a systems software programmer and team member supporting data stability and server services through monitoring, maintenance, support, and optimization. The role supports applications using Adobe Experience Manager (AEM) and Power BI for forms, workflows, dashboards, and reports. The position is fully onsite, and candidates must currently reside in South Carolina; relocation is not allowed. The contract is for 12 months, with the possibility of extension. The contractor will share 24/7 on-call responsibilities with the group. The role designs and maintains logical data models, data architectures, and relational databases for assigned applications. It establishes database and application standards, develops stored procedures and database utilities, analyzes data volumes and usage patterns, and supports developers and database administrators in resolving application and performance issues. It also involves system configuration, testing, documentation, application deployment and migration across development, QA, and production environments, and adherence to secure programming, coding, testing, automation, and continuous integration practices. The contractor will collaborate with technical staff, management, vendors, business users, and customers; communicate status and resolve issues; provide product feedback; and identify process improvements. Duties also include troubleshooting backup and recovery issues, recommending solutions and workarounds, performing equipment and software upgrades, maintaining familiarity with computer and network products, and promoting information security. Applicants must complete criminal-history, credit, E-Verify, and South Carolina tax-history checks. The posting lists a maximum bill rate of $120.73 per hour and an onsite interview process.

Requirements

At least 10 years of database modeling, architecture, and development experience.
At least 9 years of state government experience.
At least 10 years of advanced SQL experience.
At least 5 years of experience with Adobe AEM 6.5.
At least 4 years of Java development, design, and coding experience.
At least 5 years of experience with Agile methodology.
Bachelor's or master's degree in Information Technology or a related field.
Must be a current South Carolina resident; relocation is not allowed.
Ability to establish and maintain good working relationships with business users, management, vendors, and peers.
Strong organizational, multitasking, and time-management skills.
Hands-on business knowledge of business processes.
Ability to communicate clearly and concisely, orally and in writing.
Must pass the stated criminal-history and background, credit, E-Verify, and South Carolina tax-history onboarding checks; contractors must be current on South Carolina tax filings and payments.

Nice To Haves

Experience with cloud-based solutions.
PMP or another PMI-issued certification.

Responsibilities

Develop logical data models and data architecture for assigned applications in collaboration with consultants, application developers, and end users.
Design relational databases within the established architectural framework and serve as lead database designer for assigned application systems.
Develop and implement database design standards, including standards for stored procedures, object-relational mappers, database access, and application database handling and error handling.
Write and maintain stored procedures and build database utilities, including SSIS packages and database scripts, as needed.
Analyze anticipated data volumes and usage patterns and apply knowledge of agency data usage to improve database access and manipulation efficiency.
Support application developers and help resolve database-related application problems in development and production.
Work with Database Administration to resolve database performance problems.
Prepare system and programming documentation and obtain the required approval.
Configure system settings and options; plan and execute unit, integration, and acceptance testing; and create specifications that meet business requirements.
Assist with application deployment to development, QA, and production environments and with migrations.
Follow secure web programming and deployment practices and internal coding, unit-test coverage, automation, and continuous integration standards.
Work with the team or vendors to ensure sound site architecture, performance, reliability, and content delivery practices.
Communicate and collaborate with IT professionals, peers, management, vendors, business users, and customers; provide feedback about product issues, enhancements, and features.
Proactively identify, communicate, and implement process improvements; manage multiple tasks and provide periodic status updates to stakeholders.
Prioritize and resolve issues within accepted service levels, maintain ownership of Helpdesk entries, and provide timely status updates to clients and appropriate employees.
Respond attentively to customer tickets and provide good customer service.
Troubleshoot customer issues related to backup configuration and recovery, recommend technical solutions, and develop workarounds where appropriate.
Perform equipment and software upgrades and maintain familiarity with current computer and network products.
Adhere to information security guidelines and promote information security among coworkers.
Perform other assigned duties and special projects.
Share 24/7 on-call responsibilities with the group.