DAPR State Reporting Systems Analyst V

Role Description

This Systems Analyst will be part of the Department of Family and Protective Services (DFPS) Office of Data and Systems Improvement (ODSI). The position will act as a systems analyst in the Data and Performance Reporting Division, specifically for the Unit responsible for State Reporting Unit. DAPR works to build a preeminent system for reporting on the protection of children and vulnerable adults from abuse, neglect, and exploitation by partnering with DFPS leadership to provide data to inform decision-making at the highest levels of the agency as well as for our community partners, legislative oversight entities, and the general public.

The DAPR Division is responsible for provision of agency statistical data including:

• Legislative Budget Board performance measures
• Operating budget
• Legislative appropriation request
• Agency Online Data Book
• Various routine and ad hoc management reports
• Data requested by the legislature and other public officials
• Data reported to the federal government
• Data requested by the media and public via the Public Information Act
• Data related to both state and internal audits, grants, studies, and data sharing projects with other public interests

The division is responsible for conducting quality assurance review of any data to be released outside the agency to ensure validity and consistency of reported data. The division also is responsible for development of data warehouse online reports and the supporting specialized tables and/or elements.

This position may be filled as a Systems Analyst III, IV, or V with a career ladder option for future promotions.

Qualifications

• Understanding of and demonstrated skill in relational databases, data processing practices and theory.
• Ability to analyze, consolidate, and interpret complex data, procedures, and systems; and to write or revise program code as required.
• Comprehension of data solutions, reporting methodologies, math, and statistical report design.
• An ability to creatively solve complex data problems, apply new technology, and perform detailed work accurately under stressful conditions while managing multiple projects and tight deadlines.
• Technical Skills - in using SQL code, Excel, and the willingness to learn selected software as required by the division.
• Communication Skills – the ability to present information to a variety of audiences verbally and in writing and to communicate clearly, concisely, and effectively.
• Ability to work the hours needed to meet defined deadlines and support the agency’s mission critical reporting requirements.

Requirements

• Experience in writing SQL code.
• Experience in using Excel (power users are welcome).
• Experience in data extraction and report layout and design.
• DFPS experience preferred.

Benefits

• 100% paid health insurance for you, and 50% paid for eligible family members.
• Retirement plans with lifetime monthly payments after five years of state service.
• Paid vacation, holidays, and sick leave.
• Optional dental, vision, and life insurance.
• Flexible spending accounts for added tax savings on health and dependent care.
• Employee discounts on things like gym memberships, electronics, and entertainment.
• Potential qualification for Public Service Loan Forgiveness.