STATE OF CONNECTICUT EXECUTIVE BRANCH JOBS

WIC IT System Administrator and Reporting Analyst

Information Technology Analyst 2 (35 Hour)

Recruitment #211103-7604EU-001

Introduction

The State of Connecticut, Department of Public Health (DPH) is hiring! We are seeking a motivated and experienced individual for the position of WIC IT System Administrator and Reporting Analyst (Information Technology Analyst 2).

This WIC IT System Administrator and Reporting Analyst (Information Technology Analyst 2) position supports the reporting and configuration needs for DPH applications focusing on the WIC program, Environmental Public Health Tracking (EPHT) and general data .NET applications. This position will share the duties of System and Database Administrator for the MS-SQL databases and ensuring that system security and current best practice security standards are maintained. They will also be responsible for maintaining the configuration of the applicable system, performing custom database queries and maintenance as required, and coordinating testing and patching from the vendor. DPH is moving towards more of a matrixed support model, so many tasks will be shared and there may be opportunities to work on other DPH systems. The intended role would support multiple systems in cooperation with other IT analysts to ensure knowledge sharing and redundancy within the department.

This WIC IT System Administrator and Reporting Analyst (Information Technology Analyst 2) will be generally responsible for maintaining current systems which support the Women Infants and Children (CT-WIC) throughout the state of CT. In addition to maintaining the current system, this position is responsible for identifying areas where technology changes can improve workflows through the user experience and over the broad spectrum of DPH applications. As such it requires a good understanding of development cycles and dependencies in three tier, public access software installations. It also requires the ability to understand and learn the changing business requirements and effectively communicate business needs and resulting technical requirements with all stakeholders. This position will work under the supervision of an IT Supervisor and very closely with the WIC program staff.

The Mission of the Department of Public Health (DPH) is to protect and improve the health and safety of the people of Connecticut by assuring the conditions in which people can be healthy, preventing disease, injury, and disability, and promoting the equal enjoyment of the highest attainable standard of health, which is a human right and a priority of the state. 

DPH accomplishes this through the implementation of its Strategic Plan which outlines the actions that DPH is taking to accomplish its Mission.

Are you interested in joining our team as a WIC IT System Administrator and Reporting Analyst (Information Technology Analyst 2)? We encourage you to apply today! This position is conveniently located in Hartford, CT at 410 Capitol Avenue. The work schedule for this position is typically Monday - Friday, 35 hours per week, first shift.

Selection Plan

In order to be considered for this job opening, you must be a current State of CT employee, who has permanent state status* and meet the Minimum Qualifications as listed on the job opening.  You must specify your qualifications on your application.

*For employees in the classified service, permanent status is obtained after successful completion of a working test period.  For employees in the unclassified service, permanent status is obtained after serving in a position for at least six months (full-time or full-time equivalent).

The minimum experience and training requirements must be met by the close date on the job opening, unless otherwise specified.

This position will be filled in accordance with contractual language, reemployment, SEBAC, transfer, promotion and merit employment rules. In order to be considered for this job opening, you must meet the Minimum Qualifications as listed on the job opening. You must specify your qualifications on your application.  

Due to the volume of applications anticipated, we are unable to provide confirmation of receipt or status during the recruitment process. Updates will be provided through your JobAps portal account. 

Interviews will be limited to candidates whose experience most closely meet the preferred requirements of the position.  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. 

Please Note: You will be unable to make revisions once you submit your application for this posting to the JobAps system.

This posting may require 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 (Certification Questionnaires section). Your responses to these RQs must be submitted by the question's expiration date. Please regularly check your email and JobAps Personal Status Board for notifications. Please check your SPAM and/or Junk folders on a daily basis in the event an email provider places auto-notification emails in a user's spam. 

Although applicants will receive correspondence via email, as a backup they are also encouraged to sign on to their Personal Status Board on a daily basis to monitor their status, view all emailed notices and complete tasks required in the recruitment process. 

The immediate vacancy is listed above, however, applications to this recruitment may be used for future vacancies in this job class.

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

Should you have questions pertaining to this recruitment, please contact Chelsea Moore at Chelsea.Moore@ct.gov

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.

EXAMPLES OF DUTIES

This position will be responsible for:

  • Creating data queries and SSRS (SQL Server Reporting Services) reports and configuring the architecture and links to support the security and user needs
  • Maintaining the infrastructure (.NET Applications, MS-SQL Databases and Windows Servers) for DPH applications as identified by the IT Supervisor
  • Assisting in the upgrade and maintenance of existing applications as well as ongoing administration of the data and user security
  • Coordinating with DPH Application vendors and in-house developers, in the testing and deployment of product upgrades and new releases
  • Proactively identifying areas of Business Process improvement and recommend solutions for improved efficiency of operations by the public, hospital and internal users
  • Performing related duties as required

Additional information can be found here.

KNOWLEDGE, SKILL AND ABILITY

Considerable knowledge of IT equipment and diagnostic tools; considerable knowledge of principles and techniques of systems analysis, design, development and programming; considerable knowledge of principles of information systems; considerable knowledge of principles and theories of business and planning functions; considerable knowledge of programming languages; considerable knowledge of capabilities of computer technology; knowledge of methods and procedures used to conduct detailed analysis and design of computer systems; knowledge of principles and techniques of software generation and programming; knowledge of practices and issues of systems’ security and disaster recovery; knowledge of computer operating systems; knowledge of project management principles and techniques; knowledge of principles and techniques of business information systems re-engineering; considerable technical problem solving skills; considerable logic and analytical skills; considerable oral and written communication skills; considerable problem solving skills; interpersonal skills; project coordination skills; considerable ability to analyze, troubleshoot and resolve data communications problems; considerable ability to write, test and debug computer programs; considerable ability to use programming development tools; considerable ability to prepare manuals, reports, documentation and other written materials; considerable ability to identify, analyze and resolve complex business and technical problems; ability to analyze and debug complex software programs.

MINIMUM QUALIFICATIONS - GENERAL EXPERIENCE

Six (6) years of experience in information technology (IT) operations, programming, systems/software development or another IT related support area.

MINIMUM QUALIFICATIONS - SPECIAL EXPERIENCE

One (1) year of the General Experience must have been performing professional information technology work in such areas as:  installation and support of microcomputer hardware, software and operating systems; analysis, design and development of information systems network hardware and software installation and support; network hardware and/or software problem diagnosis and resolution; performing any closely related professional IT function. NOTE: For state employees this is interpreted at the level of Information Technology Analyst 1.

MINIMUM QUALIFICATIONS - SUBSTITUTIONS ALLOWED

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

PREFERRED QUALIFICATIONS

  • Experience creating data queries and SSRS (SQL Server Reporting Services) reports and configuring the architecture and links to support the security and user needs
  • Experience maintaining the infrastructure (.NET Applications, MS-SQL Databases and Windows Servers) for DPH applications as identified by the IT Supervisor
  • Experience assisting in the upgrade and maintenance of existing applications as well as ongoing administration of the data and user security
  • Experience coordinating with DPH Application vendors and in-house developers, in the testing and deployment of product upgrades and new releases
  • Experience proactively identifying areas of Business Process improvement and recommend solutions for improved efficiency of operations by the public, hospital and internal users
  • Experience with the WIC interactive application and billing cycles

Conclusion

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, and persons with disabilities.