State Comptroller Jobs in Connecticut (NOW HIRING)

Introduction

\r\n\r\n\r\n\r\nThe State of Connecticut, Office of the State Comptroller (OSC) is seeking a dynamic professional with expertise in both business and technology for the position of Core-CT EPMInformation Technology Analyst 2. The Core-CT division oversees the State of Connecticut's PeopleSoft-based Enterprise Resource Planning (ERP) system. This position requires a strong foundation in state financial and HR policy and business practices, along with experience in Oracle PeopleSoft and a solid understanding of ERP systems and integrations.\r\n\r\n\r\nWHAT WE CAN OFFER YOU:\r\n\r\n\r\n Visit our new State Employee Benefits Overview page\r\n Professional growth and development opportunities\r\n A healthy work/life balance to all employees!\r\n\r\n\r\nPOSITION HIGHLIGHTS:\r\n\r\n\r\n Full-Time, 40 hours per week\r\n Monday through Friday\r\n Location: 165 Capitol Avenue, Hartford, CT 06106\r\n\r\n\r\nWHAT YOU CAN EXPECT IN THIS ROLE:\r\nThe selected candidate will leverage strong business acumen to support critical frameworks in Financial, Supply Chain, and Human Capital Management within Core-CT, Connecticut's PeopleSoft ERP solution. This position:\r\n\r\n\r\n Encompasses services and support for a range of modules, including eProcurement, Purchasing, Supplier Contracts, Strategic Sourcing, Inventory, Accounts Payable, Asset Management, Accounts Receivable, eSupplier, Billing, Banking, Project Costing, Customer Contracts, Grants Management, General Ledger, Commitment Control, Human Resources, Position Management, Time and Labor, Payroll, Benefits and Pension.\r\n Involves providing both functional and technical assistance to EPM users, particularly with their reporting requirements.\r\n Is responsible for working with Oracle Data Integrator to support daily batch operations and managing inbound and outbound interfaces.\r\n Collaborates with the STARS team to offer alternative reporting solutions and deliver user training.\r\n\r\nIn addition to duties listed in the 'examples of duties' below, this position will be responsible for:\r\n\r\n\r\n Developing and maintaining Oracle Data Integrator (ODI) processes to extract data from CoreCT Financial (FIN) and Human Resources (HR) systems into the CoreCT EPM data warehouse.\r\n Creating inbound and outbound interfaces using ODI to enable seamless data exchange between systems.\r\n Assisting end-users with EPM PeopleSoft Queries to help them access necessary information.\r\n Maintaining CoreCT public queries and conduct annual maintenance for both public and private queries.\r\n Utilizing Oracle SQL skills and work with database administrators to optimize system performance through query tuning.\r\n Conducting end-user training in EPM Queries to enhance user proficiency with reporting tools.\r\n Working on STARS reporting to provide alternate reporting solutions as required.\r\n\r\n\r\nABOUT US\r\nThe 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.\r\nWe 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.\r\n\r\n\r\n

Selection Plan

For assistance in applying, please visit our 'Applicant Tips on How to Apply' page\r\n\r\n\r\nTO APPLY\r\n\r\n\r\n 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.\r\n 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.\r\n 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.\r\n\r\n\r\nWHAT TO EXPECT AFTER YOU APPLY\r\n\r\n\r\n 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."\r\n 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.\r\n 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.\r\n 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.\r\n The immediate vacancy is listed above, however, applications to this recruitment may be used for future vacancies in this job class.\r\n Interviews will be limited to candidates whose experience and training most closely meet the requirements of the position.\r\n 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.\r\n\r\n\r\nCONNECT WITH US\r\n\r\n\r\n 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.\r\n If you have any questions on this recruitment, please contact Brigitta Rainey at osc.hr@ct.gov or 860-702-3323.\r\n Follow the State of Connecticut on LinkedIn.\r\n\r\n\r\n

PURPOSE OF JOB CLASS (NATURE OF WORK)

In a state agency Information Technology (IT) environment this class is accountable for independently performing a full range of information technology tasks and project coordination work involving infrastructure systems support, security and application development in an IT environment.\r\n

EXAMPLES OF DUTIES

For All Functional Areas\r\n\r\n\r\n\r\n Acts as liaison to hardware and/or software vendors, system developers, programmers and user community;\r\n Evaluates and recommends products;\r\n Participates in Request for Proposal (RFP) process;\r\n Assists in estimating cost for annual budget;\r\n Identifies and implements opportunities for cost savings;\r\n Conducts system performance analysis, tuning and storage management;\r\n Assists staff and customers in use of computer systems and software packages;\r\n Trains operators, IT staff and end users on new procedures;\r\n Participates in recovery activities;\r\n Participates in the evaluation of new, related technologies;\r\n Analyzes requirements and designs systems;\r\n Participates in or coordinates project planning sessions with customers, analysts and team members to analyze requirements and provide design recommendations for moderately complex systems;\r\n Provides technical consultation on moderately complex issues regarding the usage of the infrastructure, integration of applications systems into the infrastructure, etc.;\r\n Participates in system integration testing of operating system, system utilities, hardware upgrades as well as new software and hardware technologies;\r\n Works with project team to define and design scope for each project;\r\n Plans, coordinates and schedules assigned projects;\r\n Coordinates resources for projects;\r\n Ensures timely completion of all phases of projects;\r\n Evaluates and recommends vendors;\r\n Performs related duties as required.\r\n\r\n\r\nSystems Programming\r\n\r\n\r\n\r\n Provides second or third level support for network connectivity, or related network issues for the user community;\r\n Diagnoses and resolves moderate network problems utilizing traces, hardware diagnostic tools, software aids, network management systems and utilities;\r\n Coordinates the installation and maintenance of network components;\r\n Analyzes network activity;\r\n Analyzes capacity planning and facilities bandwidth requirements and system interdependencies;\r\n Manages, maintains and contributes to network system documentation;\r\n Develops back-up procedures for LAN servers;\r\n Analyzes the recovery and reliability capability of systems and network services and makes recommendations for improvement;\r\n Recommends hardware and software purchases in support of remote access;\r\n Configures and certifies wiring;\r\n Participates in projects which call for troubleshooting, installing, implementing, administering, and maintaining network systems;\r\n Assigns file access controls, encryption keys and other security attributes;\r\n Maintains host and/or front-end processor communications software;\r\n Provides support to customers experiencing problems with hardware, operating systems and related utilities in servers;\r\n Assists in installation and maintenance of performance monitors, schedulers, program management systems and utilities, report generators and compilers;\r\n Configures and installs application packages;\r\n Coordinates and/or performs installation and configures operating systems, new software releases, system upgrades and patches in support of hardware products;\r\n Coordinates backups and file management with operations staff;\r\n Proactively tunes operating systems and system components to avoid performance problems;\r\n Writes utilities for system management, reporting, file clean up and auditing;\r\n Provides and maintains documentation and manuals necessary at operational level;\r\n Responsible for standards and design of physical data storage, maintenance, access and security administration;\r\n Performs functions associated with vulnerability and security risk assessments;\r\n Performs functions in support of investigative and forensics activity;\r\n Performs related duties as required.\r\n\r\n\r\nSoftware Development\r\n\r\n\r\n\r\n Recommends and creates action plans for system development and/or integration;\r\n Responsible for standards and design of physical data storage, maintenance, access and security administration;\r\n Writes utilities for system management, reporting, file clean up and auditing;\r\n Configures and installs application packages;\r\n Develops and maintains documentation and manuals necessary at customer level;\r\n Prepares time and cost estimates and initiates purchase requests for multiple projects;\r\n Creates test files and performs system testing across multiple packages and systems;\r\n Writes and programs system specifications;\r\n Defines work and/or data flow;\r\n Designs screens, forms and reports;\r\n Defines data elements;\r\n Prepares source code;\r\n Designs and develops tables and relationships;\r\n Arranges necessary hardware and software availability for assigned projects;\r\n Analyzes assigned specifications, codes, tests and implements software solution, utilizing appropriate software engineering processes;\r\n Debugs and/or corrects errors; maintains integrity of software;\r\n Maintains and enhances existing programs;\r\n Writes utilities for system management, reporting, file clean up and auditing;\r\n Designs and develops routine to moderately complex applications;\r\n Responsible for all phases of systems development life cycle;\r\n Develops strategies for data acquisitions, archive recovery, security and implementation of routine to moderately complex applications;\r\n Defines and develops the project scope of multiple projects;\r\n Constructs operational Database Management System (DBMS) and data stores that enable informational, analytical management inquiry;\r\n Performs backup and recovery on database management systems;\r\n Configures database parameters, and prototype designs;\r\n Provides basic database support and troubleshooting;\r\n Responsible for standards and design of physical data storage, maintenance, access and security administration;\r\n May be responsible for design, development and implementation of new system interfaces for applications on multiple platforms from mid-range computers to client servers and internet-based environments;\r\n Performs related duties as required.\r\n\r\n\r\nDatabase Administration\r\n\r\n\r\n\r\n Recommends and creates action plans for system development and/or integration;\r\n Provides and maintains documentation and manuals necessary at operational level;\r\n Provides basic database support and troubleshooting;\r\n Responsible for standards and design of physical data storage, maintenance, access and security administration;\r\n Writes utilities for system management, reporting, file clean up and auditing;\r\n Analyzes requirements and designs systems;\r\n Recommends and creates action plans for system development and/or integration;\r\n Provides and maintains documentation and manuals necessary at operational level;\r\n Proactively tunes operating systems and system components to avoid performance problems;\r\n Coordinates backups and file management with operations staff;\r\n Responsible for standards and design of physical data storage, maintenance, a...