Connecticut StateDepartment of Administrative Services

Information Technology Analyst 3 (40 Hour)

Recruitment #230120-7605FR-001

Introduction

Are you a dynamic business and technology leader?  Do you have a strong background in Oracle PeopleSoft or considerable knowledge of ERP systems and integrations?  

The State of ConnecticutOffice of the State Comptroller (OSC), is an agency whose mission is to provide accounting and financial services, to administer employee and retiree benefits, to develop accounting policy and exercise accounting oversight, and to prepare financial reports for the state, federal and municipal governments and the public. 

We are seeking an Information Technology Analyst 3 within the Core-CT Division. 

POSITION HIGHLIGHTS:

  • Full-Time, 40 hours per week
  • State of the art building
  • Free garage parking
  • On-Site Cafeteria
  • Ergonomic workspaces
  • Located in Hartford, CT, close to major highways
  • Telework opportunities

WHAT WE OFFER:

An excellent salary and a competitive benefits plan that includes healthcare coverage, a retirement plan, telework opportunities, as well as paid time off. 

THE ROLE

 This position is responsible for the following: 

  • Provide application development support for Core-CT PeopleSoft Financial applications and modules; work with the functional support team and agency users and partners; 
  • Monitor batch processing and system issues that occur during normal duty hours and off duty hours, perform issue analysis and coordinate issue resolution with Core-CT team;  
  • Develop and review SQL to perform data maintenance and updates; 
  • Maintain and enhance existing applications and reports; 
  • Efficiently develop and debug SQR/People Code programs; 
  • Coordinate with team and module leads for fast resolution of time-sensitive issues; 
  • Work with DBA’s to monitor and improve application performance; 
  • Assist with creation of SOP for issue resolution; assist with bugfixes and patching activities; 
  • Perform code updates and retrofits and resolve issues with testing; 
  • Work with business partners and agencies to establish new interfaces as required; 
  • Create and maintain proper technical documentation for various projects and issues. 

Selection Plan

In order to comply with Public Act 21-69, the State of Connecticut is no longer asking for resumes during the initial application process.  Please ensure that your application is complete prior to submitting.  NOTE:  At any point during the recruitment process, applicants may be required to submit additional documentation which support their qualification(s) for this position. These documents may include: a cover letter, resume, performance reviews, supervisory references, attendance records, etc., at the discretion of the hiring agency. Questions about these required documents should be directed to the hiring agency's human resources office:  bonnie.schlechtweg@ct.gov.

Candidates must meet the minimum qualifications as indicated to apply for this position.  State employees currently holding the above title or those who have previously attained permanent status in the class may apply for a lateral transfer.  Candidates who have been selected for employment with the Office of the State Comptroller are subject to a detailed background investigation, including a fingerprint supported state and federal criminal history record check along with reference checks. Selection for employment is contingent upon satisfactory completion of the background investigation.

This posting may require completion of additional referral questions (RQ’s) which will be sent to you via email after the closing date. Please regularly check your email for notifications, including your SPAM/JUNK folders. You must reply by the deadline indicated on the notification or you will be automatically disqualified from consideration.

Interviews will be limited to candidates whose experience and training most closely meet the requirements and preferred qualifications of the position.  All application materials must be received by the recruiting agency by the time specified on the job opening for the position for which you are applying. Late applications may not be submitted and will not be considered. Exceptions are rare and limited to documented events that incapacitate a candidate during the entire duration of the job posting time period.  It is the candidate’s obligation and responsibility to request an exception and provide a legally recognized justification to accommodate such exception.  Requests should be made to DAS.SHRM@CT.GOV.

PURPOSE OF JOB CLASS (NATURE OF WORK)

In a state agency Information Technology (IT) environment, this class is accountable for performing the most complex and technical support work and/or acting as a working supervisor of Information Technology Analysts engaged in information systems development or technical support.

EXAMPLES OF DUTIES

All Functional Areas: Diagnoses host system problems and develops and coordinates resolutions; manages planning, analysis, design, selection, installation and implementation of new technologies; evaluates new technologies; tests and evaluates new hardware and/or software; makes recommendations for hardware and/or software purchases; determines interface and utility requirements and creates design specifications; acts as liaison to hardware and/or software vendors, system developers, programmers and management; develops and implements network and system security guidelines; makes recommendations for migration and upgrade directions; trains operators, systems developers and users on new procedures; conducts system performance analysis, tuning or storage management; conducts technical training programs for IT staff; acts as project coordinator overseeing other technical staff and support personnel; plans, coordinates and directs multiple projects of assigned staff; reviews work of assigned personnel; calculates project time and cost estimates; prepares necessary procedural specifications to meet design requirements; arranges necessary hardware and software availability; oversees hardware and software vendors; manages project budgets and schedules; reviews work of assigned Information Technology Analysts and serves as consultant and/or troubleshooter; reviews documentation work of assigned staff; communicates with business owners and management; facilitates meetings; assists in development of information technology policies, procedures and standards; participates in Request for Proposal (RFP) process; implements disaster recovery plans, assists in determining critical applications and personnel, or ensures offsite backups; defines data flow; performs related duties as required.

Working Supervisor Use: Plans unit workflow and determines priorities; schedules, assigns, oversees, and reviews work; establishes and maintains unit procedures; provides staff training and assistance; conducts or assists in conducting performance evaluations; acts as liaison with operating units, agencies, and outside officials regarding unit policies and procedures; make recommendations on policies or standards; prepare reports and correspondence; performs related duties as required.

Systems Programming: Performs the most complex duties related to application development; develops and implements system programming standards; configures and installs host-based application packages; maintains host operating systems; installs and upgrades host and/or Front End Processor (FEP) operating system software; performs other related duties as required.

Software Development: Configures and installs host-based application packages; analyzes upgrades for complex applications to determine functionality and necessary software customization; writes program specifications and systems specifications; designs forms, screens and reports; performs related duties as required.

Database Administration: Provides advanced level database support and troubleshooting; designs, installs, tunes and maintains integrity of major host-based database; leads integration efforts, transitioning applications to new technology; performs related duties as required.

Network Support: Designs and implements complex communications networks; diagnoses and resolves problems using network management systems and utilities; performs related duties as required.

IT Security: Develops, tests and maintains agency disaster recovery plans designed to restore IT system operability; develops process and procedures in support of IT Business Continuity Planning; conducts platform recoverability assessments and Business Impact Analysis (BIA) to determine and assess the impacts associated with disruptions to business functions; conduct risk analysis of IT environments by assessing administrative, technical and physical safeguards; performs IT investigations to include maintaining chain of custody procedures; performs forensics and documents detailed reports of findings; performs related duties as required.

KNOWLEDGE, SKILL AND ABILITY

Considerable knowledge of principles and techniques of systems analysis, design, development, and computer programming; considerable knowledge of principles of information systems; considerable knowledge of principles and theories of business and planning functions; considerable knowledge of programming languages; considerable knowledge of project management principles and techniques; considerable knowledge of principles, problems and techniques of data processing and data communication operations; considerable knowledge of data processing and data communications equipment and diagnostic tools; considerable knowledge of methods and procedures used to conduct detailed analysis and design of computer systems; considerable knowledge of principles of complex computer operating systems; knowledge of principles and techniques of business information systems re-engineering; knowledge of network protocols and architecture; knowledge of practices and issues of systems security and disaster recovery; knowledge of applications systems development principles and techniques; knowledge of principles and practices of data base management; considerable interpersonal skills; considerable oral and written communication skills; considerable problem solving skills; considerable technical problem solving skills; considerable analytical skills; considerable ability to prepare correspondence, manuals, reports and documentation; considerable ability to analyze and resolve operational and communications problems; considerable ability to analyze and debug complex software programs; considerable ability to identify, analyze and resolve complex business and technical problems; some supervisory ability.

MINIMUM QUALIFICATIONS - GENERAL EXPERIENCE

Seven (7) years of experience in information technology (IT) operations, programming, systems/software development or another IT related field.

MINIMUM QUALIFICATIONS - SPECIAL EXPERIENCE

One (1) year of the General Experience must have been at the full professional working level with responsibility for performing a full range of complex technical support functions in such areas as: assisting in the design, implementation and management of a major communications network; providing technical and administrative support for a wide area network (WAN) or mini-computer system; assisting in the installation and maintenance of major sub-systems or installing and maintaining other host and/or network software; participating in the design and development of system applications; serving as a project coordinator responsible for coordinating the design, development, programming and implementation of moderately complex information systems projects; performing any closely related complex technical support function.
NOTE: For state employees this is interpreted at the level of Information Technology Analyst 2.

MINIMUM QUALIFICATIONS - SUBSTITUTIONS ALLOWED

1. College training in management information systems, computer science or information technology related area may be substituted for the General Experience on the basis of fifteen (15) semester hours equaling six (6) months of experience to a maximum of four (4) years for a Bachelor's degree.

2. A Master's degree in management information systems, computer science or electrical engineering may be substituted for one (1) additional year of the General Experience.

PREFERRED QUALIFICATIONS

  • Three (3) years’ experience with PeopleSoft FSCM 9.2 applications, PeopleTools, PUM and supporting technologies.
  • Experience with application support for an Enterprise Resource Planning (ERP) environment. PeopleSoft preferred.
  • Experience managing application development programs version control and associated staff.
  • Experience with the PeopleSoft HRMS, CRM or Finance 9.2 application environments and the PeopleTools development toolset.
  • Functional knowledge and proficiency with PeopleTools, Application Designer and DataMover;
  • Proficiency with the Microsoft Windows 10 and the Microsoft Office Suite or Office 365;
  • Experience managing PeopleSoft applications and associated application data in an Oracle 19c database environment.
  • Strong SQL development skills and knowledge of Oracle table structures.
  • Experience with Web browser configuration, plug-ins, and internet security practices.
  • Experience with HTML, XML and web application tools and languages. 
  • Experience with application change control best practices, code management and version control tools.
  • Ability to analyze and troubleshoot technical issues.
  • Excellent verbal and written communication skills.
  • Detail-oriented.

Conclusion

INCOMPLETE APPLICATION PACKAGES AND THOSE RECEIVED AFTER THE CLOSING DATE INDICATED ABOVE WILL NOT BE CONSIDERED.  An Affirmative Action / Equal Opportunity Employer.  The State of Connecticut is an equal opportunity / affirmative action employer and strongly encourages the applications of women, minorities, veterans, and persons with disabilities.  If you are requesting special accommodations under the provisions of the Americans with Disabilities Act (ADA) please contact Bonnie Schlechtweg at 860.702.3323 or Bonnie.Schlechtweg@ct.gov.


Click on a link below to apply for this position:

Fill out the Supplemental Questionnaire and Application NOW using the Internet.




The State of Connecticut is an Affirmative Action/Equal Opportunity Employer and strongly encourages the application of women, minorities and persons with disabilities.