Information Technology Analyst Trainee (40 Hour) Recruitment # 250225-7601FR-001 Location Hartford, CT Date Opened 3/6/2025 09:00:00 AM Salary $68,299* - $84,957/year (*new state employees start at minimum of the pay plan) Job Type Open to the Public Close Date 3/20/2025 11:59:00 PM Go Back Apply View Benefits (https://www.jobapscloud.com/CT/jobs/?b=Benefits) + + + + Introduction The State of Connecticut (https://portal.ct.gov/) , Office of the State Comptroller (OSC) (https://www.osc.ct.gov/) is currently seeking detail-oriented and adaptable individuals who are eager to contribute their skills within the Information Technology division, Core-CT Technology section as an Information Technology Analyst Trainee (https://www.jobapscloud.com/CT/specs/classspecdisplay.asp?ClassNumber=7601FR&R1=&R3=) . Join our team and embark on a rewarding career that offers growth, superlative benefits, and a culture that encourages work/life balance. The Information Technology Analyst Trainee Program is a developmental program designed to help people obtain the experience necessary to qualify for the designated target class of Information Technology Analyst 1. The Information Technology Analyst Trainee Program is for a minimum of one (1) year to a maximum of three (3) years based on a candidate’s past experience and training. Candidates must possess the general experience of the target class, Information Technology Analyst 1 (https://www.jobapscloud.com/CT/specs/classspecdisplay.asp?ClassNumber=7603FR&R1=&R3=) , at the conclusion of the developmental program. WHAT WE CAN OFFER YOU + Join a Forbes-recognized company! Connecticut is proud to be featured on America’s Best Employers by State and Best Employers for New Grads in 2024. + Comprehensive health and dental insurance (https://portal.ct.gov/DAS/smART/General-Employee-Benefits) , 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 (https://www.jobapscloud.com/ct/sup/EVPSlideDeckFall2021.pdf) 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. (https://www.ctvisit.com/) 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’re a problem solver who leverages research, creativity, and troubleshooting tools to resolve routine system issues. + You can explain technical concepts in a clear, user-friendly manner. + You’re interested learning new technologies and applying them in real-world IT environments. + You’re able to prioritize tasks and manage multiple responsibilities in a fast-paced IT environment. + You’re experienced with basic programming or scripting (e.g., SQL, Python, Java, PowerShell) and have exposure to database management (e.g., MySQL, Oracle, SQL Server) and data analysis tools. + 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 The trainee position will complete one (1) of two (2) training tracks based on interest and agency need. Financial Developer Track: + Provide technical and application development support for the Core-CT FIN system, including support for the functional support team, agency users, and partners; + Develop a solid understanding of existing PeopleSoft FIN modules and their associated batch processes; + Gain technical knowledge in critical batch applications, including their functions, dependencies, and sequencing within the system; + Build proficiency in Oracle PeopleSoft PeopleTools, including Application Designer, PeopleCode, Application Engine and DataMover; + Develop deep understanding of FIN databases tables, data structures, and table relationships to support data management and troubleshooting; + Write and optimize SQL queries for data analysis, extraction, and updates; + Modify application code and tables as needed to support system enhancements and issue resolution; PeopleSoft Admin Track: + Support the state’s Enterprise Resource Planning system by performing PeopleSoft administration functions; + Perform command-line scripting, system configuration, and troubleshooting for cloud-based Web and Application server infrastructure on both Linux- and Windows-based platforms; + Work with relational database technologies including Oracle Weblogic, Java, and Oracle database client connectivity; + Manage the setup and configuration of development, test, and production environments used to support Dev-Ops activities; + Oversee the Phire application source code management tool and assist application developers with code management, Oracle Database components, PeopleSoft application security and deployment tasks; The position will also: + Assist with adjusting production schedules for Core-CT PeopleSoft applications and ensure proper documentation of all changes; + Monitor batch applications, identify issues, analyze root causes, and coordinate resolutions with senior FIN developers; + Assist with PeopleSoft Update Manager (PUM) updates, including performing retrofits and troubleshooting testing-related issues; + Collaborate with Database Administrators (DBAs) to monitor and optimize application performance; + Develop issue resolution skills, assist with troubleshooting, and contribute to Standard Operating Procedures (SOPs) for system support; + Work with business partners and agencies to define requirements and establish new system interfaces as needed; + Monitor data exchanges and system interfaces, review log files, identify issues, and coordinate resolutions with senior development staff. 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 Check out our Applicant Tips on How to Apply! Need more resources? Visit our Applicant Reference Library (https://portal.ct.gov/das/home/services-for-state-employees/statewide-human-resources/applicant-reference-library?language=en\_US) for additional support throughout the recruitment process. BEFORE YOU APPLY + Meet Minimum Qualifications: Ensure you meet the Minimum Qualifications listed on the job opening by the job closing date. You must specify your qualifications on your application. The minimum experience and training requirements listed must be met by the close date on the job opening, unless otherwise specified. + Educational Credits: List your earned credits and degrees from accredited institutions accurately on your application. To receive educational credits towards qualification, the institution must be accredited. If the institution of higher learning is located outside of the U.S., you are responsible for providing documentation from a recognized USA accrediting service which specializes in determining foreign education equivalencies to the contact listed below. + Resume Policy: Per Public Act 21-69 (https://www.cga.ct.gov/2021/act/pa/pdf/2021PA-00069-R00SB-00056-PA.pdf) , resumes are not accepted during the initial application process. As the recruitment process progresses, candidates may be required to submit additional documentation to support their qualification(s) for this position. This documentation may include: a cover letter, resume, transcripts, diplomas, performance reviews, attendance records, supervisory references, licensure, etc., at the request and discretion of the hiring agency. + Preferred Shift/Location: Select all location(s) and shift(s) you are willing to work on your application. Failure to do so may result in not being considered for vacancies in that specific location or shift. + Timely Submission: All application materials must be received by the job posting deadline. You will be unable to make revisions once you officially submit your application to the State. Late submissions are rarely accepted, with exceptions only for documented events that incapacitate individuals during the entire duration of the job posting. Request exceptions by emailing osc.hr@ct.gov. + Salary Calculations: For current state employees, salary calculations are not necessarily comparable from one of the three branches of state government (i.e., Executive, Legislative, Judicial) to the other. + Note: The only way to apply to this posting is via the ‘Apply’ or ‘Apply Online’ buttons on the official State of Connecticut Online Employment Center job posting. AFTER YOU APPLY + Referral Questions: This posting may require completion of additional Referral Questions (RQs), which must be completed by the questionnaire’s expiration date. If requested, RQs can be accessed via an email sent to you after the job close date or by visiting your JobAps Personal Status Board (Certification Questionnaires section). + Prepare For An Interview: Interviews are limited to those whose experience and training are most aligned with the role. To prepare, review this helpful Interview Preparation Guide to make the best impression! + 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. + Stay connected! Log in daily to your JobAps Personal Status Board to track your status and check email (including spam/junk folders) for updates and tasks. + The immediate vacancy is listed above, but your application may be considered for future vacancies in this job class. + Note: This position will be filled in accordance with contractual language, reemployment, SEBAC, transfer, promotion and merit employment rules. 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, available at www.ct.gov/ethics. CONNECT WITH US + Due to high volume, we are unable to confirm receipt or provide status updates directly. For recruitment updates, please check your Personal Status Board and review our Frequently Asked Questions. + 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 systems environment this class is accountable for receiving on the job training in performing technical work involving help desk functions, user support and assisting in application development. EXAMPLES OF DUTIES + Receives on the job training to perform tasks as outlined in the specification for the class of Information Technology Analyst 1; + Performs related duties as required. KNOWLEDGE, SKILL AND ABILITY + Knowledge of + functioning and use of information systems; + major concepts and terms used in the information technology profession; + Skills + interpersonal skills; + logic and analytical skills; + Ability to + prepare and maintain accurate records; + prepare written materials and reports; + follow oral and written instructions. MINIMUM QUALIFICATIONS - GENERAL EXPERIENCE Candidates must be able to meet the experience and training requirements of the designated job class at the completion of the development program. PREFERRED QUALIFICATIONS + Experience communicating technical information to a diverse population and building consensus, including verbal and written communication. + Experience with application development tools and practices, such as PeopleSoft PeopleTools, Java, Python, or .NET. + Experience working with relational database technologies, such as Oracle, SQL Server, or MySQL, including writing and optimizing SQL queries. + Experience using and administering Microsoft Windows and Linux operating systems, including command-line scripting, system configuration, and troubleshooting. + Experience with Microsoft Office Suite, including Excel to apply macros and develop pivot tables, and Word and PowerPoint for technical documentation and reporting. + Experience developing or supporting web-based applications using HTML, JavaScript, CSS, or REST APIs. + Experience working with interface protocols, encryption tools, and file formats, such as XML, CSV, and PGP. + Experience analyzing and troubleshooting technical issues, including debugging system errors, testing fixes, and documenting resolutions. 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. Click on a link below to apply for this position: Fill out the Supplemental Questionnaire and Application NOW using the Internet. Apply Online