STATE OF CONNECTICUT EXECUTIVE BRANCH JOBS

Senior PeopleSoft Financial Developer

Information Technology Analyst 3 (40 Hour)

Recruitment #241028-7605FR-002

Introduction


The State of Connecticut, Office of the State Comptroller (OSC) is currently seeking two (2) dynamic, passionate individuals who are eager to contribute their expertise within the Core-CT division as a Senior PeopleSoft Financial Developer (Information Technology Analyst 3). Join our team and embark on a rewarding career that offers growth, superlative benefits, and a culture that encourages work/life balance.

WHAT WE CAN OFFER YOU
  • Work for a Forbes top company - ‘Forbes’: State of Connecticut Ranked One of the Best Employers of 2023.
  • Comprehensive health and dental insurance, providing you with peace of mind and access to quality healthcare.
  • Robust pension plan and supplemental retirement offerings to secure your financial future.
  • Generous paid time off, including vacation days, sick leave, personal days, and 13 holidays per calendar year.
  • We are an eligible Public Service Loan Forgiveness employer, which means you may be eligible to have qualifying student loans forgiven after 10 years of service.
  • A culture that recognizes the importance of work/life balance and offers alternate work schedules and telecommuting options.
  • Opportunities to invest in your professional growth and development with training programs, tuition reimbursement, and opportunities for advancement within the State of Connecticut.
  • Connecticut is a strong community with a lot to offer in entertainment, food and shopping, recreation in our beautiful state parks and forests, diverse culture, and rich history. Learn more about all Connecticut has to offer.
POSITION HIGHLIGHTS
  • Full-Time, 40 hours per week
  • Monday through Friday
  • Location: 165 Capitol Avenue, Hartford, CT 06106
  • Hybrid (office/telework) may be available
THIS JOB IS FOR YOU IF
  • You have a strong background in Oracle PeopleSoft, PeopleCode, and knowledge of ERP systems and integrations.
  • You are a problem solver with significant technical expertise and attention to detail that makes you adept at assessing functional and technical gaps in custom designs and troubleshoot technical issues.
  • You can work collaboratively with business analysts to understand client business requirements and recommend solutions to complex business issues.
  • You work successfully in an independent and team capacity.
  • You want to do work that matters and want to build a better Connecticut with the Office of the State Comptroller, promoting economic growth, advocating for fiscal control, and championing policies that lower costs.
DISCOVER THE OPPORTUNITY TO
  • Provide application development support for Core-CT PeopleSoft Financial applications and modules; 
  • Serve as Senior PeopleSoft Financial Developer to support Core-CT with existing system maintenance and upcoming application upgrades while ensuring continued operations of underlying PeopleSoft customizations;
  • Support one or more of the following PeopleSoft Financials 9.2 modules: General Ledger (GL), Commitment Control (KK), Accounts Payable (AP), eProcurement (ePro), Purchasing (PO), Billing (BI), Accounts Receivable (AR), Project Costing (PC), Asset Management (AM), Inventory (IN), Grants Management, Vendor Self-Serve,  PS Security and other related core PeopleSoft Financials modules;
  • 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; 
  • Develop applications using PeopleSoft PeopleTools such as PeopleCode, Application Engine, Component Interfaces, SQR, and Integration Broker;
  • Maintain and enhance existing applications and reports; 
  • Coordinate with team and module leads for fast resolution of time-sensitive issues; 
  • Work with DBA’s to monitor and improve application performance; 
  • Assist in the design and development of PeopleSoft customizations based on business requirements and bolt-on solutions;
  • Understand requirements, designing, developing, testing, and implementing new and custom modules;
  • Assist with creation of standard operating procedures for issue resolution; 
  • Assist with bug fixes and patching activities; 
  • Work with Oracle database tables and structures, views, functions and indexes;
  • Perform code updates and retrofits and resolve issues with testing; 
  • Assist with Oracle PeopleSoft PUM and the application patching process;
  • Maintain documentation of development processes and configurations.
  • Work with business partners and agencies to establish new interfaces as required; 
  • Coordinate with business analyst to understand client business requirements and recommend solutions to complex business issues.
  • Develop and maintain outbound and inbound file interfaces;
  • Utilize STAT or Phire for comparing code, version control and change management;
  • Create and maintain proper technical documentation for various projects and issues.
ABOUT US
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, and the public. 

We are located in the State Office Building at 165 Capitol Avenue, Hartford, CT. This state-of-the-art building offers free garage parking, an on-site cafeteria, and ergonomic workspaces.

The Information Technology division is an inter-agency team that supports and helps maintain Core-CT, used by over 10,000 state employees for financial, human resources, and payroll functions. The division maintains and upgrades Core-CT, provides analysis, maintains the comptroller’s technical infrastructure, and is responsible for web development for the comptroller’s communication sites.

Selection Plan

For assistance in applying, please visit our 'Applicant Tips on How to Apply' page

APPLYING FOR THE POSITION
  • For current state employees, salary calculations are not necessarily comparable from one of the three branches of state government (i.e. Executive, Judicial or Legislative) to the other.
  • In order to be considered for this job opening, you must meet the Minimum Qualifications listed in the job opening. The minimum experience and training requirements must be met by the close date of the job opening, unless otherwise specified. You must specify your qualifications on your application. 
  • Ensure that your application is complete before submitting it. To comply with Public Act 21-69, the State of Connecticut no longer requests resumes during the initial application process. Once your application is submitted into the JobAps system, you cannot make revisions.
  • In order to receive educational credits toward qualification for this job posting, the institution must be accredited. For institutions located outside of the U.S., you must provide documentation from a recognized USA accrediting service specializing in determining foreign education equivalencies to the recruiter listed on this job posting.
  • All application materials must be received by the recruiting agency by the specified deadline. Late applications will not be considered. Candidates may request a rare and documented exception for events that incapacitate them during the entire duration of the job posting period by providing a legally recognized justification to accommodate such an exception. Requests may be made to osc.hr@ct.gov
WHAT TO EXPECT AFTER APPLYING
  • Applicants will receive correspondence via email and are also encouraged to monitor their Personal Status Board daily for status updates, notices, and tasks required in the recruitment process.
  • Some postings may require additional referral questions (RQs). You will receive an email with these questions after the posting’s closing date. Check your email and Personal Status Board for notifications, including your spam or junk folders. 
  • You may be required to submit additional documentation supporting your qualifications at any point during the recruitment process. The documentation may include a cover letter, resume, transcripts, diplomas, performance reviews, attendance records, supervisory references, or licensure, at the discretion of the hiring agency.
  • 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, subject to the provisions of Section 31-51i and conducted in accordance with Section 29-17a of the Connecticut General Statutes. Selection for employment is contingent upon satisfactory completion of the background investigation.
  • The immediate vacancy is listed above, but your application may be considered 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 offered a position with the State of Connecticut are bound by the State Code of Ethics for Public Officials and State Employees, available at www.ct.gov/ethics.
CONNECT WITH US
  • Due to the high volume of applications, we cannot confirm receipt or status during the recruitment process. Updates will be available through your JobAps portal account. 
  • If you have any questions about this recruitment, please contact Sara Garrett at osc.hr@ct.gov or 860-702-3572.
  • Follow the State of Connecticut on LinkedIn to stay updated on our career opportunities and news.

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 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.

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; 
  • Makes recommendations on policies or standards; 
  • Prepares 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 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 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.

KNOWLEDGE, SKILL AND ABILITY

  • 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 data base 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.

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 experience is interpreted at the level of an Information Technology Analyst 2.

MINIMUM QUALIFICATIONS - SUBSTITUTIONS ALLOWED

  • 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.

PREFERRED QUALIFICATIONS

  • Experience explaining technical concepts, including verbal and written communication to a diverse population.
  • Experience with full project life cycle implementation and/or upgrade using PeopleSoft Financials application on version 9.2 or other recent version.
  • Experience using PeopleTools 8.56 or recent versions as PeopleSoft Developer, utilizing PeopleCode, Application Engine, Component Interfaces, SQR, Integration Broker and Fluid pages.
  • Experience with Oracle SQL skills (Oracle 12c or latest versions).

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 require accommodations under the provisions of the Americans with Disabilities Act (ADA), please contact Sara Garrett at osc.hr@ct.gov or 860-702-3572.

ACKNOWLEDGEMENT

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.