STATE OF CONNECTICUT EXECUTIVE BRANCH JOBS

Power BI Developer

Information Technology Analyst 2 (40 Hour) (Hybrid)

Recruitment #231024-7604FR-001

Go Back View Benefits

Introduction



Are you passionate about working in the IT field?  If so, we encourage you to check out this opportunity!

The State of Connecticut Department of Administrative Services (DAS) Bureau of Information Technology Solutions (BITS) is currently accepting applications for a Power BI Developer position (Information Technology Analyst 2) to join the Applications Development team, in service of the Department of Mental Health and Addiction Services (DMHAS). This Power BI Developer will help provide real-time data dashboards to help improve client care throughout DMHAS.

WHAT WE CAN OFFER YOU

  • Work for a Forbes top company - ‘Forbes’: State of Connecticut Ranked One of the Best Employers of 2023 - State of CT Receives National Recognition for Offering Job Growth, Competitive Benefits, and Flexible Schedule
  • A competitive starting salary
  • A Platinum Healthcare Plan, the nation’s best for state employees and dependents, according to a report by Georgetown’s Center on Health Insurance Reform an article by Ellen Andrews, Ph.D., along with comprehensive benefit offerings
  • Generous paid time off
  • Retirement plan options
  • Alternate work schedules
  • A culture that encourages work-life balance
  • State of Connecticut is an eligible Public Service Loan Forgiveness employer, meaning you may be eligible to have qualifying student loans forgiven after 10 years of service.  Click here for more information.
POSITION HIGHLIGHTS
  • Monday - Friday
  • Full-time (40 hours per week)
  • First shift (8:00 AM - 4:30 PM)
  • Location:  460 Silver Street in Middletown, CT
  • Hybrid work environment (combination on-site and remote work)
View the video below to learn what it's like to be part of this innovative BITS team!

Selection Plan

To Apply:

  • In order to be considered for this job opening, you must meet the Minimum Qualifications as listed on this job opening. You must specify your qualifications on your application.
  • The minimum experience and training requirements must be met by the close date on the job opening, unless otherwise specified.
  • Ensure that your application is complete and detailed before submitting it. In order to comply with Public Act 21-69, the State of Connecticut is no longer asking for resumes during the initial application process. You will not be able to make revisions once your application is submitted into the JobAps system.
  • Please 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.
  • In order to receive educational credits toward qualification for this job posting, 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 recruiter listed on this job posting.
  • 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 time period. It is the candidate’s obligation and responsibility to request an exception and provide a legally recognized justification to accommodate such exception. Requests should be made to DAS.SHRM@ct.gov.
FOR ASSISTANCE IN APPLYING:

Important Information After You Apply:

  • 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 questionnaire'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.
  • 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.
  • Interviews will be limited to candidates whose experience and training most closely meet the requirements of the position.
  • The immediate vacancy is listed above, however, applications to this recruitment may be used for future vacancies in this job class.
Connect With Us:

Due to the large volume of applications received, we are unable to provide confirmation of receipt or status during the recruitment process. Updates will be available through your JobAps portal account. Should you have any questions pertaining to this recruitment, please contact Frank DeCusati at frank.decusati@ct.gov or 860-713-5176.

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

The Power BI Developer will be responsible for:

  • Requirement Analysis: Studying, analyzing, and understanding business requirements in context to business intelligence.
  • Data Modeling: Building multi-dimensional data models by importing, transforming, and shaping data from various data sources (such as databases, various file formats, CRM Systems, Online Services and more) to make it suitable for analysis and reporting within Power BI.
  • Report/Dashboard Design and Development: Designing and developing interactive reports, dashboards, and data visualizations that provide meaningful insights to end-users. Power BI offers a range of visualization options to represent data effectively.
  • Data Integration: Connecting Power BI to various data sources, setting up data refresh schedules, and ensuring that the data is up-to-date for accurate reporting.
  • Data Security: Implementing role-level and data-level security (such as Row, Column, Object or Page level Security) to control access to data and ensure data privacy and compliance with regulatory requirements.
  • Data Visualization Best Practices: Applying data visualization best practices to create visually appealing and informative reports that effectively communicate insights to end-users.
  • Automation and Customization: Developing custom visuals, themes, and templates to tailor Power BI solutions to specific business needs. Also, automating report generation and distribution through Power Automate and Power BI apps.
  • Please refer to the job class specification for additional duties.

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 in data analysis including structuring data for analysis within Power BI
  • Experience with data modeling, including designing data models within Power BI
  • Experience using Power BI, including creating reports, dashboards, and data visualizations from scratch
  • Experience with Structured Query Language for data retrieval
  • Experience utilizing data security principles including implementing role-level and data-level security in Power BI to control data access
  • Experience communicating with stakeholders to explain insights derived from data using presentations and trainings

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.





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