Information Technology Subject Matter Expert (35 Hour)

      

The State of Connecticut, Office of the State Comptroller (OSC), is an agency whose mission is to provide accounting and financial services, to administer employee and retiree benefits, to develop accounting policy and exercise accounting oversight, and to prepare financial reports for the state, federal and municipal governments and the public. 

We are recruiting for a full-time Information Technology Subject Matter Expert to be responsible for:

• Providing SME support for Core-CT PeopleSoft Time & Labor module. 
• Developing technical solutions, review and enhance existing modules, and recommend improvements relating to the PeopleSoft Time Labor module. 
• Application development using PeopleTools, PeopleCode, SQR with good coding practices. 
• Performing issue analysis and coordinate issue resolution across Core-CT team.  Develop SOP where needed and work on RCA for issue resolutions.  Monitoring batch processing and system issues that occur during normal duty hours and off duty hours as required. 
• Collaborating with team members, DBAs, System Administrators as appropriate to coordinate, plan and solve problems. 
• Creating and maintaining proper technical documentation for various projects and issues.

This position is a first-shift, 35 hour per week position located at the newly renovated State Office Building at 165 Capitol Avenue in Hartford, CT. This state-of-the-art building offers an on-site cafeteria, free garage parking, and ergonomic workspaces. The OSC offers an excellent salary and benefits package.

Note:  At any point during the recruitment process, applicants may be required to submit additional documentation which support their qualification(s) for this position.  These documents may include:  a cover letter, resume, performance reviews, attendance records, supervisory references, licensure, etc., at the discretion of the hiring agency.  Applicants must meet the minimum qualifications as indicated to apply for this position. Candidates must meet the minimum qualifications as indicated to apply for this position.  State employees currently holding the above title or those who have previously attained permanent status in the class may apply for a lateral transfer. 

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. Selection for employment is contingent upon satisfactory completion of the background investigation.

This posting may require completion of additional referral questions (RQ’s) which will be sent to you via email after the closing date.Please regularly check your email for notifications. You must reply by the deadline indicated on the notification or you will be automatically disqualified from consideration.

Questions about these required documents should be directed to the hiring agency's human resources office: Bonnie.Schlechtweg@ct.gov.

Interviews will be limited to candidates whose experience and training most closely meet the requirements and preferred qualifications of the position.  Please note that applications to this recruitment process may be used for future vacancies.

All State employees shall follow the guidelines as listed in Executive Orders 13F (3a) and 13G (3a).

In a state agency supporting a highly complex Information Technology (IT) environment this class is accountable for functioning as a Subject Matter Expert in one of the following functional IT areas: networking, security, systems development, systems programming or database administration. This class also provides technical leadership and consultation in the areas of architecture, application design, systems programming, system integration, and/or database management OR the analysis, development and operational support of highly complex technologies affecting multiple infrastructure areas.

Acts as a full project manager; participates in the development of architectural designs; recommends policies, procedures, and associated technical implementation standards; researches, designs, analyzes, develops and enhances new and highly complex infrastructure projects in support of agency information systems; participates in the design and configures infrastructure systems that optimize information access capabilities and ensure the security and integrity of these systems; provides consulting in a technology area, such as IT Security, Network Architecture (including LAN/WAN design), Platform Architecture (including mainframe and desktop hardware and software selection), Middleware Architecture (including messaging and Physical Data Architecture); acts as a consultant to management and individual employees regarding area of expertise including technical leadership and consultation in the areas of architecture and application design, systems programming, system integration, and/or database management or the analysis and development of highly complex technologies affecting multiple infrastructure areas; serves as Subject Matter Expert on various IT project teams; researches and analyzes technology trends and assists in the development of infrastructure technology strategy and standards; troubleshoots existing infrastructure systems to identify errors or deficiencies; recommends and implements software, hardware and configuration changes to improve system performance; participates in defining architecture and technology standards to optimize system performance and integrity; participates in long-term infrastructure technology strategy development and planning; recommends new tools, technologies, and platforms to be implemented; assists in the development of a comprehensive disaster recovery plan; provides technical leadership; provides assistance with escalated Tier III support issues; works on multiple projects including complex integration efforts and transitioning applications to new technologies; defines and develops the project scope of multiple complex projects; makes recommendations towards buy versus build decisions surrounding applications; designs component architectures, making use of multiple tiers to provide insulation to changes from application interfaces and databases; participates in the evaluation and selection process for application packages to meet solutions; recommends testing tools, middleware, and database management systems; document changes to architecture and conversion plans; develops and maintains system and application architecture diagrams; assists in organization wide data modeling and database design; participates in the definition of data architecture standards, policies and procedures for the organization structure, attributes and nomenclature of data elements; assists in the design and construction of data architectures, operational data stores, and data marts; performs related duties as required.

Considerable knowledge of current methods of information systems analysis, design and development; considerable knowledge of principles, practices and techniques of information technology; considerable knowledge of applications systems development principles, techniques and development; considerable knowledge of principles and techniques of computer programming and languages; considerable knowledge of principles and theories of business planning functions; considerable knowledge of project management principles and techniques; considerable knowledge of principles and techniques of systems analysis and design; considerable knowledge of computer operating systems and databases; considerable knowledge of business re-engineering process; considerable knowledge of principles of data modeling and related tools; considerable knowledge of distributed systems architecture, network, middleware and object oriented analysis; considerable interpersonal skills; considerable oral and written communication skills; considerable analytical and problem solving skills; considerable ability to develop and implement system security and disaster recovery plans; considerable ability to identify, analyze and resolve highly complex business and technical problems; considerable ability to conduct highly complex detailed analysis and design of major computer systems and networks; considerable ability to develop reports, manuals and documentation.

Nine (9) years of experience in infrastructure systems support, programming, database administration, systems/software development, networking or technical support.

1. 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 equaling six (6) months of experience to a maximum of four (4) years for a Bachelor's degree.
2. 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.

• Expertise with the PeopleSoft 9.2 Time and Labor module.
• Solid technical experience with Time Labor rules development.
• Strong expertise with Time Admin and Time Load processes.
• Experience with Time Labor, HR and Payroll modules integration.
• In-depth knowledge of PeopleSoft HCM tables their relation to the various modules. 
• Experience with People Tools, People Code, Application Engine, Component Interfaces, SQR.
• Expertise in complex SQL coding and working in either the PL/SQL or Oracle SQL Developer environments.
• Working experience with Quest Stat for version control.
• Strong conceptual, analytical and problem-solving skills. Must be a team player and be able to adjust to a dynamic working environment.
• Proven leadership with strong written and verbal communication skills

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 are requesting special accommodations under the provisions of the Americans with Disabilities Act (ADA) please contact Bonnie Schlechtweg at 860.702.3323 or Bonnie.Schlechtweg@ct.gov.