Information Technology Analyst 3 (40 Hour)
State of Connecticut - Office of the State Comptroller
Turn this role into an interview — a resume and cover letter built around what this employer wants.
Benefits offered by this job
Job summary
State of Connecticut - Office of the State Comptroller seeks an experienced Information Technology Analyst 3 to support Core-CT’s PeopleSoft environment. You will lead a team, develop complex SQL scripts, and drive system modernization to reduce costs while upholding fiscal oversight.
The role requires deep PeopleSoft knowledge, strong SQL skills, and experience with SDLC project leadership. Location is Hartford, CT; standard full-time schedule Monday–Friday.
Qualifications
- Seven (7) years of IT experience in operations, programming, or development.
- One year at the full professional level in a related IT role.
Responsibilities
- Lead a team of IT analysts supporting PeopleSoft apps and integrations.
- Develop SQL scripts, Application Engine, and SQR for data exchange.
- Monitor batch processing and performance metrics, tune databases.
- Oversee SDLC for medium-to-large system integration projects.
- Train staff and liaise with stakeholders and vendors.
Skills
Tools
Job description
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.
- Visit our new State Employee Benefits Overview page
- Professional growth and development opportunities
- A healthy work/life balance to all employees!
- Full-Time, 40 hours per week
- Monday through Friday
- Location: 165 Capitol Avenue, Hartford, CT 06106
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.
The Office of the State Comptroller (OSC) is an agency whose mission is to provide accounting and financial services, administer employee and retiree benefits, develop accounting policy and exercise accounting oversight, and prepare financial reports for the state, federal and municipal governments, as well as the public.
In order to be considered for this job opening you must be a current State of CT employee of the agency listed above for at least six (6) months of full-time service or full-time equivalent service, absent any applicable collective bargaining language, and meet the Minimum Qualifications as listed on the job opening. You must specify your qualifications on your application. Please ensure that your application is complete before submitting it. To comply with Public Act 21-69, the State of Connecticut is no longer asking for resumes during the initial application process. You cannot make revisions once your application is submitted into the JobAps system. 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 period. It is the candidate’s obligation and accountability to request an exception and provide a legally recognized justification to accommodate such an exception. Requests should be made to osc.hr@ct.gov.
NEW: Some email providers may experience delays or issues delivering messages. To avoid missing important updates—such as referral questionnaires or interview scheduling links—please check your Personal Status Board regularly. For added convenience, you can also enable text (SMS) notifications. To do this, log in to your Personal Status Board and select "Update My Contact Information." Although applicants will receive correspondence via email, as a backup they are also encouraged to sign on to their Personal Status Board daily to monitor their status, view all emailed notices, and complete tasks required in the recruitment process. This posting may require the completion of additional referral questions (RQs). You can access these RQs via an email that will be sent to you after the posting's closing date or by visiting your JobAps Personal Status Board. Please regularly check your email and JobAps Personal Status Board for notifications. Please check your SPAM and/or Junk folders daily in the event an email provider places auto-notification emails in a user's spam. At any point during the recruitment process, applicants may be required to submit additional documentation that supports their qualification(s) for this position. These documents may include: a cover letter, resume, transcripts, diplomas, performance reviews, attendance records, supervisory references, licensure, etc., at the discretion of the hiring agency. The immediate vacancy is listed above, however, applications to this recruitment may be used for future vacancies in this job class. Interviews will be limited to candidates whose experience and training most closely meet the requirements of the position. Candidates who are offered and accept a position with the State of Connecticut are bound by the State Code of Ethics for Public Officials and State Employees which is available at www.ct.gov/ethics.
Due to the large number of applications received, the State of Connecticut cannot confirm receipt or status during recruitment. Updates will be available through your JobAps portal account. If you have any questions on this recruitment, please contact Brigitta Rainey at osc.hr@ct.gov or 860-702-3323. Follow the State of Connecticut on LinkedIn.
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.
- 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 the 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.
- 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;
- Makes recommendations on policies or standards;
- Prepares reports and correspondence;
- Performs related duties as required.
- 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 related duties as required.
- 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.
- 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.
- Designs and implements complex communications networks;
- Diagnoses and resolves problems using network management systems and utilities;
- Performs related duties as required.
- Develops, tests and maintains agency disaster recovery plans designed to restore IT system operability;
- Develops processes 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;
- Conducts 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.
- 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.
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.
NOTE: For state employees this experience is interpreted at the level of an Information Technology Analyst 2.
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 equalling one-half (1/2) year of experience to a maximum of four (4) years for a Bachelor's degree.
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.
NOTE: For state employees this experience is interpreted at the level of an Information Technology Analyst 2.
- perience 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.
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, and persons with disabilities.
As defined by Sec. 5-196 of the Connecticut General Statutes, a job class is a position or group of positions that share general characteristics and are categorized under a single title for administrative purposes. As such, a job class is not meant to be all-inclusive of every task and/or responsibility.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
