Data Applications Systems Analyst II

Justice; Raleigh (NC); On-site; USD 82,000 - 122,000; Full time

Benefits offered by this job

Health insurance

Twelve paid holidays

Generous vacation and sick leave accr

Dental

Vision

Retirement benefits

Other insurance options

Job summary

The North Carolina Department of Justice, including the Medicaid Investigations Division, seeks a Systems Analyst II to design, implement and support advanced data mining and database query systems. You will work with large datasets, craft SQL queries, and leverage tools like R, Python, SAS or Stata to produce actionable investigative leads.

Experience with AI-enabled data mining campaigns and deploying browser-based analytics applications is highly valued.

Qualifications

• Bachelor's degree in computer science or an IT related field and two years of experience in business application development or consulting; or an Associate degree with three years of experience; or high school/GED with six years of experience.

Responsibilities

• Develop, design, configure, script, implement and support data mining and database query applications.
• Use data management and visualization software (R, Python, SAS, Stata, etc.).
• Deploy and manage autonomous data mining scripts and AI agents in data-mining campaigns.
• Provide data, access, and analytics support to investigators, auditors and attorneys.

Skills

Data mining

SQL queries

Python

R

SAS

Stata

AI technologies

Team collaboration

Education

Bachelor's degree in computer science/IT

Associate degree in computer science/IT

Tools

R

Python

SAS

Stata

Job description

Systems Analyst II (NS)

Position Number: 65044772

Grade: DT09

About Us

The North Carolina Department of Justice, led by the Attorney General of North Carolina, represents the state, state agencies and elected officials, and defends the rights of the people of North Carolina. The Department handles all state criminal appeals cases and assists district attorneys with complex criminal cases at their request. Additionally, the Department of Justice includes the North Carolina State Crime Lab, the North Carolina Justice Academy and the Sheriffs' and Criminal Justice Education and Training Standards Divisions.

Description of Work

Recruitment Range: $81,504 - $122,256. IMPORTANT NOTE: This posting closes at 11:59:59 PM the night BEFORE the End Date listed. NOTE: This is a time-limited position, subject to funding availability, which may last up to 12 months (1 year). Time limited employees are eligible for State Benefits. If you have questions concerning the time-limited status of this position, you may inquire if selected for an interview.

This position will develop, design, configure, script, implement and support data mining and database query applications for the Medicaid Investigations Division. This will involve both the design and use of a complex system of analytical tools interacting with numerous disparate databases and large sets of data. This will include the implementation and use of data management and visualization software (e.g., at least one of R, Python, SAS, Stata, etc.) and will also involve the development and use of agentic AI and the use of those agents in MID's data-mining efforts. This position will deploy the above applications and systems in connection with databases to engage in data mining campaigns, conducting analysis of the same, and implementing ongoing systems for the autonomous deployment of data mining scripts and the use and management of AI agents in these ongoing data-mining campaigns.

This position will use large databases (i.e., those that exceed the processing capacity of spreadsheet applications like Excel or other database software/programs) and crafting original queries in SQL or a similar relational database programming language, and actually designing, developing and implementing completely new data analytics databases and applications in addition to analyzing the results of the data mining that those systems will facilitate.

This position will provide data, data access and data analytics systems, support, training and information to MID investigators, auditors and attorneys in connection with the use of data mining and database query systems and applications. This will include Medicaid claims data, as well as other data sets in other databases containing provider and recipient data. This position will develop built-from-scratch browser-based data analysis and visualization applications. This position will assist in deploying applications on our NCDOJ & MID servers for use by other team members.

The Medicaid Investigations Division (MID) investigates and prosecutes health care fraud committed by Medicaid providers and the physical abuse of patients and embezzlement of patient funds in Medicaid-funded facilities. MID works closely with district attorneys' offices, US Attorneys' offices, federal, state and local agencies across the State. The damages in a Medicaid fraud case can range from a few thousand dollars to tens of millions of dollars. MID's enforcement actions protect and recover taxpayer funds and help ensure access to needed medical services for Medicaid enrollees.

Knowledge, Skills and Abilities / Management Preferences

Experience developing, designing, configuring, scripting, implementing and/or supporting data mining and/or database query applications, to include crafting original queries in SQL or a similar relational database programming language. This will include experience analyzing the results of the data mining that those systems will facilitate. Experience in designing and using a complex system of analytical tools interacting with numerous disparate databases and large sets of data, to include data management and visualization software (e.g., at least one of R, Python, SAS, Stata, etc.). Experience with or the ability to learn how to implement ongoing systems for the autonomous deployment of data mining scripts and/or the use and/or management of emerging AI technologies and agents in ongoing data-mining campaigns. The ability to work in a team environment with investigators, analysts, and/or attorneys and translate technical data mining campaign results into actionable investigative leads for subsequent investigation. Working knowledge of statistics, including knowledge of appropriate methods for sampling and identifying extreme or anomalous values in a dataset.

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 in computer science or an IT related field or related technical degree from an appropriately accredited institution and two years of experience in business application consulting or development; or Associate degree in computer science or an IT related field from an appropriately accredited institution and three years of experience in application consulting or development; or High School or General Educational Development (GED) diploma and six years of experience in business application consulting or development; or an equivalent combination of education and experience.

Benefits

• employer paid health insurance
• twelve paid holidays
• generous vacation and sick leave accrual
• dental
• vision
• other insurance options
• retirement benefits

EEO Statement

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

Additional Information

Permanent, temporary and time-limited state government jobs can be found from the mountains to the coast.