Systems Architect

Job DescriptionJob Descriptionystems 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: WisDOT is recruiting for two IT consultants to build out our 3-person team for CHEMS. One position/ candidate will have a primary focus on supporting our Delphi v. 2007 production platform which would include support of our end-user clients (highway department office staff). The other position would have a primary focus on development of our upgraded CHEMS application using Delphi 2011. However, each individual within this 3-person team will be expected to provide ancillary support and coverage for one another across the different functional areas. As part of the interview process, WisDOT will decide which individual may be better suited for each role, and would notify selected candidates of the intended role as part of the offering. The contract developer(s) will implement, support, maintain and enhance the County Highway Expenditure Microcomputer System (CHEMS) and CHEMSPRO (GUI version) that is both in production as well 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. Individuals 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. Travel to Wisconsin for the annual CHEMS conference is an expectation for both positions. Historically, the CHEMS conference has been a 3 day conference held at various locations across WI in October. A $1000 travel stipend will be provided to each position for travel costs associated with this conference not including conference fees. Conference fees will be paid separately and directly by WisDOT. The contract developer is expected to provide, or be able to perform, the following to support the existing CHEMS system: • 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 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 • Implementation of security software package (e.g. OKTA or other) that integrated with Delphi application • 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 support.

RequirementsTop 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