STATE OF CONNECTICUT EXECUTIVE BRANCH JOBS

Dashboard Developer

Information Technology Analyst 3

Recruitment #260413-7605FR-001

Go Back Apply View Benefits

Introduction



Blue logo with a solid blue circle containing a white geometric shape made of an open circular form and a vertical bar. To the right, the word ‘CONNECTICUT’ appears in large, bold, blue uppercase letters. Below it, the words ‘Administrative Services’ appear in smaller, bold, blue title‑case letters.


The State of Connecticut, Department of Administrative Services (DAS), Bureau of Information Technology Solutions (BITS), is seeking applications for a Dashboard Developer (Information Technology Analyst 3) in Hartford, CT, to support the Department of Social Services (DSS).

WHAT WE CAN OFFER YOU
POSITION HIGHLIGHTS

  • Full time, 40 hours per week
  • First shift, 8:00 AM to 4:30 PM
  • Location: 55 Farmington, Avenue, Hartford, CT 
  • This hybrid position is eligible to apply for telework in accordance with the Telework Policy. The Policy can be found HERE.  

    Career progression pathway within the State of Connecticut, with four connected steps labeled ‘Information Technology Analyst 2,’ ‘Information Technology Analyst 3,’ ‘Information Technology Supervisor,’ and ‘Information Technology Subject Matter Expert.’ The ‘Information Technology Analyst 3’ step is visually highlighted as it is the current opening. A slogan on the left reads ‘Start, Stay, Grow with the State of Connecticut.'

    THE ROLE
    The Dashboard Developer (Information Technology Analyst 3) will support reports, analytics, and power platform development efforts. 
    Additionally, the Dashboard Developer (Information Technology Analyst 3) can expect to:
    • Work in close collaboration with a team responsible for reporting activities on enterprise applications and systems.
    • Collaborate with system integrators and partners for infrastructure and data center support.
    • Work in close partnership with enterprise and solution architect(s) to configure, migrate, and deploy reports on shared infrastructure. enterprise integrators and enterprise platforms.
    • Build reports, dashboards, heat, and geographic maps with drill-down and drill-through capabilities.
    • Analyze and document new data streams by evaluating database tables, queries, and data structures, and coordinate with business liaisons, project managers, and quality management teams to support new application development, reporting requirements, and system enhancements.
    • Design and optimize performance on reports. Perform Export Transform Load (ETL) functions.
    • Develop and maintain conceptual, physical, and logical data models.
    • Analyze, monitor, audit, and forecast business needs to determine the metrics driven approach for measuring KPIs.
    • Develop, review, and monitor policy standards and procedures that assist the selection, utilization, development, and implementation of metrics needs for the agency.
    • Document and maintain standards and processes for reports, dashboards.

    Watch the video below to see what it's like to be a State of CT employee!

    Selection Plan

    FOR ASSISTANCE IN APPLYING: 

    Check out our Applicant Tips on How to Apply! Need more resources? Visit our Applicant Toolkit 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 by the closing date listed on the job posting. 
    • Resume Policy: Per Public Act 21-69, 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 DAS.SHRM@ct.gov (Opens in a New Window). 
    • 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: 

    • 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.”
    • 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! 
    • 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, however, applications to this recruitment may be used 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.

    QUESTIONS? WE’RE HERE TO HELP: 

    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 additional questions about the recruitment process, reach out to Sharon McIntosh at Sharon.McIntosh@ct.gov (Opens in a New Window). 

    PURPOSE OF JOB CLASS (NATURE OF WORK)

    In a state agency Information Technology (IT) environment this class is accountable for performing the most complex and technical support work and/or acting as a working supervisor of Information Technology Analysts engaged in information systems development or technical support.

    EXAMPLES OF DUTIES

    All Functional Areas

    • Diagnoses host system problems and develops and coordinates resolutions; 
    • Manages planning, analysis, design, selection, installation and implementation of new technologies; 
    • Evaluates new technologies; 
    • Tests and evaluates new hardware and/or software; 
    • Makes recommendations for hardware and/or software purchases; 
    • Determines interface and utility requirements and creates design specifications; 
    • Acts as liaison to hardware and/or software vendors, system developers, programmers and management; 
    • Develops and implements network and system security guidelines; 
    • Makes recommendations for migration and upgrade directions; 
    • Trains operators, systems developers and users on new procedures; 
    • Conducts system performance analysis, tuning or storage management; 
    • Conducts technical training programs for IT staff; 
    • Acts as project coordinator overseeing other technical staff and support personnel; 
    • Plans, coordinates and directs multiple projects of assigned staff; 
    • Reviews work of assigned personnel; 
    • Calculates project time and cost estimates; 
    • Prepares necessary procedural specifications to meet design requirements; 
    • Arranges necessary hardware and software availability; 
    • Oversees hardware and software vendors; 
    • Manages project budgets and schedules; 
    • Reviews work of assigned Information Technology Analysts and serves as consultant and/or troubleshooter; 
    • Reviews documentation work of assigned staff; 
    • Communicates with business owners and management; 
    • Facilitates meetings; 
    • Assists in the development of information technology policies, procedures and standards; 
    • Participates in Request for Proposal (RFP) process; 
    • Implements disaster recovery plans, assists in determining critical applications and personnel, or ensures offsite backups; 
    • Defines data flow; 
    • Performs related duties as required.

    Working Supervisor Use

    • Plans unit workflow and determines priorities; 
    • Schedules, assigns, oversees, and reviews work; 
    • Establishes and maintains unit procedures; 
    • Provides staff training and assistance; 
    • Conducts or assists in conducting performance evaluations; 
    • Acts as liaison with operating units, agencies, and outside officials regarding unit policies and procedures; 
    • Makes recommendations on policies or standards; 
    • Prepares reports and correspondence; 
    • Performs related duties as required.

    Systems Programming

    • Performs the most complex duties related to application development; 
    • Develops and implements system programming standards; 
    • Configures and installs host-based application packages; 
    • Maintains host operating systems; 
    • Installs and upgrades host and/or Front End Processor (FEP) operating system software; 
    • Performs related duties as required.

    Software Development

    • Configures and installs host-based application packages; 
    • Analyzes upgrades for complex applications to determine functionality and necessary software customization; 
    • Writes program specifications and systems specifications; 
    • Designs forms, screens and reports; 
    • Performs related duties as required.

    Database Administration

    • Provides advanced level database support and troubleshooting; 
    • Designs, installs, tunes and maintains integrity of major host-based database; 
    • Leads integration efforts, transitioning applications to new technology; 
    • Performs related duties as required.

    Network Support

    • Designs and implements complex communications networks; 
    • Diagnoses and resolves problems using network management systems and utilities; 
    • Performs related duties as required.

    IT Security

    • Develops, tests and maintains agency disaster recovery plans designed to restore IT system operability; 
    • Develops processes and procedures in support of IT Business Continuity Planning; 
    • Conducts platform recoverability assessments and Business Impact Analysis (BIA) to determine and assess the impacts associated with disruptions to business functions; 
    • Conducts risk analysis of IT environments by assessing administrative, technical and physical safeguards; 
    • Performs IT investigations to include maintaining chain of custody procedures; 
    • Performs forensics and documents detailed reports of findings; 
    • Performs related duties as required.

    KNOWLEDGE, SKILL AND ABILITY

    • Considerable knowledge of
      • principles and techniques of systems analysis, design, development, and computer programming; 
      • principles of information systems; 
      • principles and theories of business and planning functions; 
      • programming languages; 
      • project management principles and techniques; 
      • principles, problems and techniques of data processing and data communication operations; 
      • data processing and data communications equipment and diagnostic tools; 
      • methods and procedures used to conduct detailed analysis and design of computer systems; 
      • principles of complex computer operating systems; 
    • Knowledge of
      • principles and techniques of business information systems re-engineering; 
      • network protocols and architecture; 
      • practices and issues of systems security and disaster recovery; 
      • applications systems development principles and techniques; 
      • principles and practices of database management; 
    • Considerable
      • interpersonal skills; 
      • oral and written communication skills; 
      • skill in problem solving; 
      • skill in technical problem solving; 
      • skill in analysis; 
    • Considerable ability to
      • prepare correspondence, manuals, reports and documentation; 
      • analyze and resolve operational and communications problems; 
      • analyze and debug complex software programs; 
      • identify, analyze and resolve complex business and technical problems; 
    • Supervisory ability.

    MINIMUM QUALIFICATIONS - GENERAL EXPERIENCE

    Seven (7) years of experience in information technology (IT) operations, programming, systems/software development or another IT-related field.

    MINIMUM QUALIFICATIONS - SPECIAL EXPERIENCE

    One (1) year of the General Experience must have been at the full professional working level with responsibility for performing a full range of complex technical support functions in such areas as: assisting in the design, implementation and management of a major communications network; providing technical and administrative support for a wide area network (WAN) or mini-computer system; assisting in the installation and maintenance of major sub-systems or installing and maintaining other host and/or network software; participating in the design and development of system applications; serving as a project coordinator responsible for coordinating the design, development, programming and implementation of moderately complex information systems projects; performing any closely related complex technical support function.

    NOTE: For state employees this experience is interpreted at the level of an Information Technology Analyst 2.

    MINIMUM QUALIFICATIONS - SUBSTITUTIONS ALLOWED

    • 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 one-half (1/2) year of experience to a maximum of four (4) years for a Bachelor's degree.
    • 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

    • Bachelor’s degree in Computer Science, Information Systems, or related Information Technology field
    • Experience optimizing Structured Query Language (SQL) queries for improved performance
    • Experience with commercial database management systems, including Microsoft SQL (Structured Query Language) Server, IBM DB2 (International Business Machines Database 2), and Snowflake
    • Experience creating dashboards and analytics from large enterprise transactional databases
    • Experience managing user expectations in report development and developing solutions using Microsoft Power Platform 

    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.

    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.


    E-mailPhone: (860) 713-52058am - 4:30pm M-FPowered by JobAps