Data Applications Systems Analyst II

Adult Correction; North Carolina; On-site; USD 82,000 - 122,000; Full time

Job summary

North Carolina Department of Justice is seeking an Applications Systems Analyst II to design, implement, and support data mining and database query applications. You will work with large datasets, craft SQL queries, and employ AI tools in support of Medicaid Investigations Division investigations.

The role involves deploying applications on MID servers, providing data analytics support to investigators, and collaborating with attorneys and auditors to translate findings into actionable leads.

Qualifications

• Experience designing and implementing data mining and/or database query applications.
• Ability to craft original SQL queries and analyze results.

Responsibilities

• Develop and support data mining and database query applications for MID.
• Deploy analytics and AI-enabled tools on MID servers and databases.
• Provide data analytics support and training to investigators, auditors and attorneys.

Skills

SQL queries

Data mining

AI technologies

Team collaboration

Statistics

Tools

R

Python

SAS

Stata

SQL

Job description

Agency Dept of Justice Division DOJ Legal Services

Job Classification Title: Applications 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 'equiv