Core-CT EPM Information Technology Analyst

Introduction

The 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 EPM Information Technology Analyst 2. The Core-CT division oversees the State of Connecticut's People Soft-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 People Soft and a solid understanding of ERP systems and integrations.

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

• 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.
• Involves providing both functional and technical assistance to EPM users, particularly with their reporting requirements.
• Is responsible for working with Oracle Data Integrator to support daily batch operations and managing inbound and outbound interfaces.
• Collaborates with the STARS team to offer alternative reporting solutions and deliver user training.

• 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.
• Creating inbound and outbound interfaces using ODI to enable seamless data exchange between systems.
• Assisting end-users with EPM People Soft Queries to help them access necessary information.
• Maintaining CoreCT public queries and conduct annual maintenance for both public and private queries.
• Utilizing Oracle SQL skills and work with database administrators to optimize system performance through query tuning.
• Conducting end-user training in EPM Queries to enhance user proficiency with reporting tools.
• Working on STARS reporting to provide alternate reporting solutions as required.

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

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.

• Acts as liaison to hardware and/or software vendors, system developers, programmers and user community;
• Evaluates and recommends products;
• Participates in Request for Proposal (RFP) process;
• Assists in estimating cost for annual budget;
• Identifies and implements opportunities for cost savings;
• Conducts system performance analysis, tuning and storage management;
• Assists staff and customers in use of computer systems and software packages;
• Trains operators, IT staff and end users on new procedures;
• Participates in recovery activities;
• Participates in the evaluation of new, related technologies;
• Analyzes requirements and designs systems;
• Participates in or coordinates project planning sessions with customers, analysts and team members to analyze requirements and provide design recommendations for moderately complex systems;
• Provides technical consultation on moderately complex issues regarding the usage of the infrastructure, integration of applications systems into the infrastructure, etc.;
• Participates in system integration testing of operating system, system utilities, hardware upgrades as well as new software and hardware technologies;
• Works with project team to define and design scope for each project;
• Plans, coordinates and schedules assigned projects;
• Coordinates resources for projects;
• Ensures timely completion of all phases of projects;
• Evaluates and recommends vendors;
• Performs related duties as required.
• Provides second or third level support for network connectivity, or related network issues for the user community;
• Diagnoses and resolves moderate network problems utilizing traces, hardware diagnostic tools, software aids, network management systems and utilities;
• Coordinates the installation and maintenance of…