Data analyst

Agency

Dept of Health and Human Services

Division

Social Services

Job Classification Title

Administrative Officer I (NS)

Position Number

60042099

Grade

NC11

About Us

The North Carolina Department of Health and Human Services (DHHS) is one of the largest, most complex agencies in the state, and has approximately 17,000 employees. It is responsible for ensuring the health, safety, and well-being of all North Carolinians, providing human service needs for special populations including individuals who are deaf, blind, developmentally disabled, and mentally ill, and helping poor North Carolinians achieve economic independence.

Description of Work

The Data Analyst position is located in the Child Support Reporting Unit and is assigned duties for the Child Support Program. The position is responsible for all incentives and ensuring accurate distribution. This position prepares the federally mandated incentives reports and monitors incentives performance. The incentives performance measures have five categories in which the Child Support Program must meet standards. This position is responsible for all the Child Support Federal reporting. This position will manage the report for compliance with federal regulations in eight areas.


This position works with the data warehouse team to design and develop data warehouse queries and reports. The data warehouse is a complex application that is used by local offices to run reports. Data that is transferred to the Client Services Data Warehouse (CSDW) from the child support case management system must be tested to ensure all programs run correctly including all mandatory federal reports as well as program activities. This position will manage these reports that are used by state and federal auditors and local offices. If there are problems with these reports, this position works to resolve issues with the CSDW team and the ACTS (Automated Collection and Tracking System) technical team.


This position develops and runs queries for management as requested. Information from the queries is used to make decisions about the program and to satisfy requests for information from judges (due to lawsuits or other court actions), attorneys, federal agencies and other State agencies.


Position must analyze and interpret statistical data in order to identify significant differences and/or predictive outcomes. This position will evaluate the statistical methods and procedures used to obtain data in order to ensure validity, applicability, efficiency, and accuracy.


Responsibilities of the position include:

• Manage child support incentives.
• Ensure incentive funds are accurately distributed and disbursed to county Child Support Services offices.
• Preparation of all federally mandated reports.
• Monitor incentive performance.
• Analyze and interpret statistical data to identify significant trends and predictive outcomes.
• Work with the data warehouse team to design, develop and test data warehouse queries and reports by creating, modifying and updating business requirements.
• Work with federal, state and local auditors to ensure program security and accuracy.

The major functions of this position include:
FEDERAL REPORTING | INCENTIVE FUNDS | PROGRAM REPORTING

• Preparation of federal, state and internal reports regarding program performance
• Retrieve and analyze data from various data sources, generate reports, provide analysis and recommendations to Manager, Child Support Services Section Chiefs and Director to assist with decisions concerning the program.
• Calculation of Incentive Payments.
• Evaluate federal, state and county program performance in relation to incentive grant award and provide recommendation to stakeholders.
• Work with federal, state and local auditors to ensure program security and accuracy.

CLIENT SERVICES DATA WAREHOUSE (CSDW)

• Participate in the design, development, update and testing for the Automated Collection and Tracking System (ACTS functionality in data warehouse.
• Assist statewide child support users with queries needed to achieve case management and performance measure goals and outcomes.
• Develop training material and train users on the use of data warehouse.

ADDITIONAL DUTIES
Assist with computer software and/or hardware and provide training as needed. (Word, Excel, Publisher, Xcelsius, etc.)

Knowledge Skills and Abilities/Management Preferences

Salary Range: $45,431 - $79,504

Recruitment Range: $45,431 - $50,145

Candidates now meet the minimum qualifications of a position if they meet the minimum education and experience listed on the vacancy announcement.

The Knowledge Skills and Abilities/ Management Preferences are not required. Applicants who possess the following skills are preferred.

• Demonstrated knowledge of the North Carolina Child Support Services Program
• Experience using Client Services Data Warehouse (CSDW) and the Automated Collection and Tracking System (ACTS)
• Demonstrated ability to prepare statistics for spreadsheets, charts and data analytics with various software applications
• Ability to work independently and manage several projects simultaneously
• Strong organizational, analytical, and written/oral communication skills
• Demonstrated knowledge executing queries and importing data to various software applications

This position is funded in part through federal funds.

This position will close at 11:59 p.m. the night before the end date.

The Division of Social Services (DSS) provides direct services that address issues of poverty, family violence and exploitation. We aim to prevent abuse, neglect and exploitation of vulnerable citizens, and promote self-reliance and self-sufficiency for individuals and families.

Compensation & Benefits:
The State of North Carolina offers excellent comprehensive benefits. Employees can participate in health insurance options, standard and supplemental retirement plans, and the NCFlex program (numerous high-quality, low-cost benefits on a pre-tax basis). Employees also receive paid vacation, sick, and community service leave. In addition, paid parental leave is available to eligible employees.

Visit website for State Benefits

Supplemental and Contact Information

The North Carolina Department of Health and Human Services (DHHS) is an Equal Opportunity Employer that embraces an Employment First philosophy, which consists of complying with all federal laws, state laws, and Executive Orders. We are committed to reviewing requests for reasonable accommodation at any time during the hiring process or while on the job. For more information about DHHS: .

DHHS uses the Merit-Based Recruitment and Selection Plan to fill positions subject to the State Human Resources Act with the most qualified individuals. Hiring salary will be based on relevant qualifications, internal equity, and budgetary considerations pertinent to the advertised position.

In accordance with the Governor’s Executive Order 303 , our agency supports second-chance employment for individuals who were previously incarcerated or justice-involved. We invite all potential applicants to apply for positions for which they may be qualified.

Application Process

Be sure to complete the application in its entirety. Resumes will not be accepted in lieu of completing this application.

• Information should be provided in the appropriate areas, to include the following: Education, including high school and all degrees obtained, Work Experience, and Certificates & Licenses. It is critical to our screening and salary determination process that applications contain comprehensive candidate information.
• Applicants may be subject to a criminal background check. All candidates selected for positions considered "Positions of Trust" will be subject to a criminal background check.
• Due to the volume of applications received, we are unable to provide information regarding the status of your application over the phone. To check the status of your application, please log in to your account. Upon the closing date, applications are "Under Review" and will be screened by Human Resources for qualified applicants. The hiring process may take several weeks.
• Degrees must be received from appropriately accredited institutions. Transcripts and degree evaluations may be uploaded with your application. The State of North Carolina/Office of State Human Resources uses the National Association of Credential Evaluation Services (NACES) as a referral resource for applicants who need to have their credentials certified as equivalent.
• For a list of organizations that perform this specialized service, please visit the NACES membership website at .

Degree/College Credit Verification

Degrees must be received from appropriately accredited institutions. Transcripts, degree evaluations and cover letters may be uploaded with your application.

Veterans’ and National Guard Preference

• Applicants seeking Veteran's Preference must attach a DD-214 Member-4 Form (Certificate of Release or Discharge from Active Duty) to their applications.
• Applicants seeking National Guard Preference must attach an NGB 23A (RPAS), along with the state application, if they are a current member of the NC National Guard in good standing.
• Applicants who are former members of either the NC Army National Guard or the NC Air National Guard, with honorable discharge and six years of creditable service, must attach a copy of the DD 256 or NGB 22, along with the state application.

ADA Accommodations

Consistent with the Americans with Disabilities Act (ADA) and the Pregnant Workers Fairness Act (PWFA), DHHS is committed to the full inclusion of all qualified individuals. As part of this commitment, DHHS will ensure that people with disabilities, or known limitations covered by the PWFA, are provided with reasonable accommodation. If reasonable accommodation is needed to participate in the job application or interview process, please contact the person indicated below.

CONTACT INFORMATION:

If there are any questions about this posting, please contact Talent Acquisition at [email protected] . Resumes will not be accepted in lieu of completing this application.

Minimum Education and Experience

Some state job postings say you can qualify by an “equivalent combination of education and experience.” If that language appears below, then you may qualify through EITHER years of education OR years of directly related experience, OR a combination of both. See the Education and Experience Equivalency Guide for details.

Bachelor’s degree from an appropriately accredited institution and one year of experience in HR, budgeting, research or administrative management; or an equivalent combination of education and experience.

EEO Statement

T he State of North Carolina is an Equal Employment Opportunity Employer and dedicated to providing employees with a work environment free from all forms of unlawful employment discrimination, harassment, or retaliation. The state provides reasonable accommodation to employees and applicants with disabilities; known limitations related to pregnancy, childbirth, or related medical conditions; and for religious beliefs, observances, and practices.

Recruiter:

Edward Christopher Raube

Email:

[email protected]