Data Applications Systems Analyst II

State of North Carolina - Justice; North Carolina; On-site; USD 82,000 - 122,000; Full time

Benefits offered by this job

Health insurance

12 paid holidays

Retirement benefits

Job summary

The North Carolina Department of Justice’s Medicaid Investigations Division seeks an Applications Systems Analyst II to design, build, and support data mining and database query applications. The role involves SQL querying, data visualization, and AI agent-enabled analytics across large Medicaid-related datasets.

You will deploy browser-based analytics tools, collaborate with investigators, and provide data access and training to attorneys, ensuring actionable investigative leads and robust

Qualifications

• Experience designing, implementing, and supporting data mining and/or database query applications.
• Ability to craft original SQL queries and analyze results from data mining efforts.
• Experience with data visualization tools and AI technologies in investigative contexts.

Responsibilities

• Develop, configure, script, and support data mining and database query apps for the MID.
• Design analytical tool systems interfacing with multiple databases and large data sets.
• Deploy data mining scripts and AI agents in ongoing campaigns.
• Provide data analytics support and training to MID investigators and attorneys.

Skills

Data mining

SQL queries

Data analysis

AI deployment

Team collaboration

Education

Bachelor's degree in computer science or IT field

Two years of experience in business application consulting or development

Tools

R

Python

SAS

Stata

Job description

AgencyDept of JusticeDivisionDOJ Legal ServicesJob Classification TitleApplications Systems Analyst II (NS)Position Number65044772GradeDT09About UsThe 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 WorkRecruitment Range: $81,504 - $122,256IMPORTANT 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 PreferencesExperience 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 ExperienceSome 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.The North Carolina 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 .The State of North Carolina offers employer paid health insurance plus twelve paid holidays, generous vacation and sick leave accrual, dental, vision, and other insurance options, and retirement benefits. You can view our benefits information at Employee Benefits .Supplemental Information:Resumes and cover letters: To receive credit for your work history and credentials, you must list the information on the online application form. This information is used to determine if you meet the requirements of the position, and if you are selected, it is used to determine a salary offer.Using the terms \"See Resume\" or \"See Attachment\" will not be accepted, and your application will be rejected as incomplete. Cover letters are highly encouraged but not required.Credit for foreign degrees will only be given if verification of degree certification is attached to your application. Transcripts for foreign degrees have to be evaluated by an organization like World Education Services to determine US equivalency.CONTACT INFORMATION:NC Department of JusticeHuman [e-mail] StatementT 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:Wendy K MinichRecruiter Email:[e-mail]