Remote Systems Architect

Systems Architect assists with the design and development of current WisDOT internal business

systems, working with the CHEMS Lead. Possesses experience in software design and development

with a focus on the integration of internal business systems across multiple functional areas, notably

finance/accounting, financial transaction processing, supply chain transaction processing, etc. This

position will work with general supervision and priorities will be coordinated & approved by the

CHEMS Lead. Will be required to transition Counties from their current software packages to the

CHEMS system. Possesses experience in design and integration of business applications and

enterprise IT infrastructure. Designs IT infrastructure components and architecture. Experience with

design and development of custom modules/solutions and the integration of these components with

packaged solutions. Proven methodology experience for complex systems integration projects and

demonstrated ability to achieve deliverables on time and on budget. Systems Architects capabilities

with 5 or more years of experience, relies on experience and judgment to plan and accomplish

goals, independently performs a variety of complicated tasks, a wide degree of creativity and

latitude is expected.

Systems Analyst Specifics:

The contract developer will implement, support, maintain and enhance the County Highway

Expenditure Microcomputer System (CHEMS) and CHEMSPRO (GUI version) that is in the process

of being implemented. The individual needs to be familiar with WisDOT, DTSD, Bureau of Highway

Operations (BHO) project and activity accounting and business practices. The individual will also

have an extensive background in software analysis, design, development, testing and

implementation. The candidate will have a broad range of networking infrastructure knowledge and

experience. Great communication skills, problem solver attitude, and the ability to work

independently are required.

The contract developer is expected to provide, or be able to perform, the following to support the

existing CHEMS system:

Description

• Work on team to upgrade CHEMS from Delphi 2007 to 2011

• Participation in virtual State-wide meetings to support and enhance CHEMS

• Software and system enhancements to the existing Oracle version 19c database

• Import/export integration programs to transfer data in and out of CHEMS

• Release management for periodic CHEMS software releases

To support our Oracle and Delphi-based financial package, the ideal candidate would have sound

knowledge in the following areas:

• Delphi programming experience using RAD Studio 2007+ and/or 2011

• SQL/PL SQL experience

• GitHub

• Object-orient programming languages using Virtual Component Library (VCL)

• MS Windows 11 Enterprise

• Windows Server 2015+

• The contractor must also have extensive knowledge of a Windows-based application target platform and software

development tools

• Oracle RDBMS

• Oracle DB Admin Tools, Enterprise Manager

• Experience with Design & Code walkthroughs

Candidates who may be lacking experience in an area above will have the opportunity to be mentored/ groomed by

our lead IT Consultant.

Additionally, the following are not required but nice to have:





Experience with Financials applications (will be supporting WisDOT custom written solution)

Third-party data access software packages such as ASTA or RemObjects’ Data Abstract

 Oracle development experience building triggers and/or packages



 SQL Developer or similar Oracle Tool

This resource will confirm priorities from the lead IT Consultant; however, the individual can expect to

operate independently from a remote work location. This includes self-sufficiency in all necessary

county interfacing, hardware, software, training, and suppor

Requirements

Top Required Skills & Years of Experience:

At least 5 years’ experience in the following:

• Delphi programming experience using RAD Studio 2007+ and/or 2011

• SQL/PL SQL experience

• SQL Developer

• GitHub

Nice to Have Skills:

• Experience with Financials applications/suppose

• Third-party data access software packages such as ASTA or RemObjects’ Data Abstract

• Oracle development experience building triggers and/or packages

• Implementation of security software package (e.g. OKTA or other) that integrated with Delphi application

Project details: The selected Systems Architect will assist with the design and development of current WisDOT internal business systems, working with the CHEMS Lead.