Information Technology Analyst 3 (40 Hour)

State of Connecticut•Hartford, CT

4d•Onsite

About The Position

The State of Connecticut, Office of the State Comptroller (OSC) is seeking a dynamic, highly experienced professional for the position of Information Technology Analyst 3 to work in Core-CT's Financial Development Team. The Core-CT Division is responsible for the State of Connecticut's PeopleSoft-based Enterprise Resource Planning system. The individual selected for this role will perform the most complex technical support, systems analysis, and development functions, driving system stability and technological modernization to lower operational costs and champion strict fiscal oversight statewide. In the Core-Ct division, the Information Technology Analyst will be responsible for a variety of advanced technical duties, including, but not limited to: Serving as a technical lead for a team of IT analysts supporting PeopleSoft applications, modules, and integrations. Providing application development support and system programming standards for complex PeopleSoft configurations, upgrades, and patches. Monitoring, troubleshooting, and tuning batch processing and performance metrics, including database settings like temporary table allocations and concurrency parameters. Designing, writing, and reviewing complex SQL scripts, SQR programs, Application Engine processes, and integration interfaces to support data exchange. Diagnosing system bottlenecks or host environment problems and coordinating resolutions across database administration, server infrastructure, and functional teams. Leading medium-to-large system integration projects through the entire System Development Lifecycle (SDLC). Training technical staff, operators, and agency end-users on new software procedures, customizations, and operational tools. Acting as a technical liaison with operating units, state agencies, and external hardware/software vendors.

Requirements

Seven (7) years of experience in information technology (IT) operations, programming, systems/software development or another IT-related field.
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.
Considerable knowledge of principles and techniques of systems analysis, design, development, and computer programming.
Principles of information systems.
Principles and theories of business and planning functions.
Programming languages.
Project management principles and techniques.
Principles, problems and techniques of data processing and data communication operations.
Data processing and data communications equipment and diagnostic tools.
Methods and procedures used to conduct detailed analysis and design of computer systems.
Principles of complex computer operating systems.
Knowledge of principles and techniques of business information systems re-engineering.
Network protocols and architecture.
Practices and issues of systems security and disaster recovery.
Applications systems development principles and techniques.
Principles and practices of database management.
Considerable interpersonal skills.
Oral and written communication skills.
Skill in problem solving.
Skill in technical problem solving.
Skill in analysis.
Considerable ability to prepare correspondence, manuals, reports and documentation.
Analyze and resolve operational and communications problems.
Analyze and debug complex software programs.
Identify, analyze and resolve complex business and technical problems.
Supervisory ability.

Nice To Haves

Experience with PeopleSoft Application Designer, PeopleCode logic (Including Component Processor flow, Application Classes, and Rowset manipulations.
Experience with Custom Inbound/Outbound Interfaces and reporting using Application Engine and SQR.
Experience with SQL Analysis, expert-level SQL writing, debugging and tuning complex Oracle SQL queriers and PL/SQL scripts.
Experience with PeopleSoft 9.2 modules like eProcurement, Purchasing, Supplier Contacts, Strategic Sourcing, Inventory, Accounts Payable, Asset Management, Accounts Receivable, eSupplier, Billing, Baking, Project Costing, Customer Contracts, Grants Management, General Ledger, and Commitment Control.
Experience communicating to a diverse population including both verbally and written.

Responsibilities

Serve as a technical lead for a team of IT analysts supporting PeopleSoft applications, modules, and integrations.
Provide application development support and system programming standards for complex PeopleSoft configurations, upgrades, and patches.
Monitor, troubleshoot, and tune batch processing and performance metrics, including database settings like temporary table allocations and concurrency parameters.
Design, write, and review complex SQL scripts, SQR programs, Application Engine processes, and integration interfaces to support data exchange.
Diagnose system bottlenecks or host environment problems and coordinate resolutions across database administration, server infrastructure, and functional teams.
Lead medium-to-large system integration projects through the entire System Development Lifecycle (SDLC).
Train technical staff, operators, and agency end-users on new software procedures, customizations, and operational tools.
Act as a technical liaison with operating units, state agencies, and external hardware/software vendors.
Diagnose host system problems and develop and coordinate resolutions.
Manage planning, analysis, design, selection, installation and implementation of new technologies.
Evaluate new technologies.
Test and evaluate new hardware and/or software.
Make recommendations for hardware and/or software purchases.
Determine interface and utility requirements and create design specifications.
Act as liaison to hardware and/or software vendors, system developers, programmers and management.
Develop and implement network and system security guidelines.
Make recommendations for migration and upgrade directions.
Train operators, systems developers and users on new procedures.
Conduct system performance analysis, tuning or storage management.
Conduct technical training programs for IT staff.
Act as project coordinator overseeing other technical staff and support personnel.
Plan, coordinate and direct multiple projects of assigned staff.
Review work of assigned personnel.
Calculate project time and cost estimates.
Prepare necessary procedural specifications to meet design requirements.
Arrange necessary hardware and software availability.
Oversee hardware and software vendors.
Manage project budgets and schedules.
Review work of assigned Information Technology Analysts and serve as consultant and/or troubleshooter.
Review documentation work of assigned staff.
Communicate with business owners and management.
Facilitate meetings.
Assist in the development of information technology policies, procedures and standards.
Participate in Request for Proposal (RFP) process.
Implement disaster recovery plans, assist in determining critical applications and personnel, or ensure offsite backups.
Define data flow.
Perform related duties as required.
Plan unit workflow and determine priorities.
Schedule, assign, oversee, and review work.
Establish and maintain unit procedures.
Provide staff training and assistance.
Conduct or assist in conducting performance evaluations.
Act as liaison with operating units, agencies, and outside officials regarding unit policies and procedures.
Make recommendations on policies or standards.
Prepare reports and correspondence.
Perform the most complex duties related to application development.
Develop and implement system programming standards.
Configure and install host-based application packages.
Maintain host operating systems.
Install and upgrade host and/or Front End Processor (FEP) operating system software.
Configure and install host-based application packages.
Analyze upgrades for complex applications to determine functionality and necessary software customization.
Write program specifications and systems specifications.
Design forms, screens and reports.
Provide advanced level database support and troubleshooting.
Design, install, tune and maintain integrity of major host-based database.
Lead integration efforts, transitioning applications to new technology.
Design and implement complex communications networks.
Diagnose and resolve problems using network management systems and utilities.
Develop, test and maintain agency disaster recovery plans designed to restore IT system operability.
Develop processes and procedures in support of IT Business Continuity Planning.
Conduct 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.
Perform IT investigations to include maintaining chain of custody procedures.
Perform forensics and document detailed reports of findings.