Logo for North Carolina Department of Public Safety

Business System Analyst II/ Data Analyst

Roles & Responsibilities

  • Bachelor’s degree in Business Administration, Economics, Finance, Mathematics, Management Information Systems (MIS), Healthcare Administration, Computer Science, Engineering, or other quantitative discipline.
  • Three years of programmatic experience related to the area of assignment, or an equivalent combination of education and experience.
  • Thorough knowledge and experience with SAS/SQL and Cognos and/or Tableau and Power BI.
  • Ability to present data visually using tools like Tableau, QlikView, Cognos, Microsoft Power BI, Google Charts, and/or other similar tools.

Requirements:

  • Conduct data analyses relating to Medicaid quality assessment, utilization trends, cost management, program impact, and performance patterns.
  • Develop extracts, reports, and analytics using data from large decision support warehouse, Medicaid claims processing system (MMIS), NC accounting systems, and other data sources using various applications and programming languages such as Cognos, SQL, SAS or visualization tools like Tableau.
  • Forecast business needs and design solutions that align business processes and the applications that support them with agency strategic goals.
  • Provide consultative support to staff on division data sources, use of data to answer questions, and available analytic capabilities and methods.

Job description

Agency

Dept of Health and Human Services

Division

HEALTH BENEFITS

Job Classification Title

Business Systems Analyst II (NS)

Position Number

65024415

Grade

NC19

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 Business Information & Analytics Office (BIAO) is a centralized business intelligence (BI) team that provides reporting and analysis of Medicaid claim, beneficiary, and provider data in support of Division of Health Benefits goals, objectives, and operations. BIA leverages technology and data to advance organizational oversight and decision making to the betterment of Medicaid beneficiaries and providers.

This position is integral in NC Medicaid’s continued evolution as a data-driven organization. The Data Analyst, classified as a Business Systems Analyst II, provides reporting and analysis of Medicaid financial, claims/encounter, member, provider, data etc. in support of the division’s objectives and operations. Work involves collaboration with division management and program managers across multiple business units within Medicaid.


Job Specific Responsibilities

Conduct data analyses relating to Medicaid quality assessment, utilization trends, cost management, program impact, and performance patterns.
Analyze program data using concepts and tools of quantitative methods, financial analysis and advanced analytics.
Forecast business needs and agency strategic plans and design solutions that align business processes and the applications that support them with those goals.
Develop extracts, reports, and analytics using data from large decision support warehouse, Medicaid claims processing system (MMIS), NC accounting systems, and other data sources using various applications and programming languages such as Cognos, SQL, SAS or visualization tools like Tableau.
Manipulate data and use applicable analytic and quantitative methods to identify potential relationships in the data and the underlying factors driving results.
Perform data quality checks to ensure data accuracy in reports and extracts.
Prepare and present written and verbal status reports to staff.
Provide consultative support to staff on division data sources, use of data to answer questions, and available analytic capabilities and methods.
Provide consultative support and coaching to non-analyst staff on appropriate use of data and analysis tools.
Work with division staff to understand data requests and needs to establish requirements for reports, presentations and analysis.

**This position is exempt from the State Human Resources Act**

TELEWORK AVAILABILITY: We trust our employees to be self-motivated and successful in hybrid/remote roles; NC Department of Health and Human Services offers work from home options and variable work schedule flexibility for this position.

Division of Health Benefits employees with an approved hybrid telework schedule are currently expected to work onsite at their assigned duty station at least 8 working days per month. More information on this arrangement may be obtained at the time of interview.

Knowledge Skills and Abilities/Management Preferences

Salary Grade Range $67,122 - $117,465

Recruitment Range $67,122 - $95,639

**Position is eligible for a hybrid-teleworking schedule to include weekly onsite work hours**

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 (KSAs)/ Management Preferences are not required. Applicants who possess the following skills are preferred:

  • Previous and proven work experience at Division of Health Benefits/NC Medicaid.

  • Familiarity with relevant and current NC Medicaid operations.

  • Bachelor’s degree in Business Administration, Economics, Finance, Mathematics, Management Information Systems (MIS), Healthcare Administration, Computer Science, or Engineering, or other quantitative discipline.

  • Thorough knowledge and experience with SAS/SQL and Cognos and/or Tableau and Power BI.

  • Ability to present data visually using tools like Tableau, QlikView, Cognos, Microsoft Power BI, Google Charts, and/or other similar tools.

Physical Requirements:

Sedentary work: Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.

Posting closes at 11:59 p.m. the night before the closing date

Position is funded in part through federal funds

About the NC Division of Health Benefits:
The Division of Health Benefits (DHB) within NCDHHS is committed to advancing innovative solutions that improve health, promote well-being and foster independence for all North Carolinians. DHB manages and oversees North Carolina Medicaid and other programs that provide access to services and supports for parents, children, seniors, people with intellectual / developmental disabilities, and behavioral health, substance use and traumatic brain injury disorders. With a budget over $27 billion in state and federal funds per fiscal year, DHB ensures that more than 108,000 enrolled providers are reimbursed for delivering covered services to 3.1 million beneficiaries.

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: https://www.ncdhhs.gov/.

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.

  • Answers to Supplemental Questions are not a substitute for providing all relevant information within the body of your application. To receive credit for the supplemental questions, you must provide supporting information within the "Work Experience" section of the application to support your answers.

  • If multiple applications are submitted to an individual posting, only the most recent application received prior to the closing date will be accepted. Applications must be submitted by 11:59 PM the night BEFORE the closing date.

  • 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 https://www.naces.org/members. 

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 Substance Abuse Professional Practice Board, etc.) indicated below.

CONTACT INFORMATION: 

If there are any questions about this posting, please contact Talent Acquisition at talentacquisition@dhhs.nc.gov. 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 appropriately accredited institution in a discipline related to the area of assignment with three years of programmatic experience related to the area of assignment; or an equivalent combination of training and experience.

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.

Recruiter:

Tandrea Lanae Jones

Email:

talentacquisition@dhhs.nc.gov

Business Analyst Related jobs

Other jobs at North Carolina Department of Public Safety

We help you get seen. Not ignored.

We help you get seen faster — by the right people.

🚀

Auto-Apply

We apply for you — automatically and instantly.

Save time, skip forms, and stay on top of every opportunity. Because you can't get seen if you're not in the race.

AI Match Feedback

Know your real match before you apply.

Get a detailed AI assessment of your profile against each job posting. Because getting seen starts with passing the filters.

Upgrade to Premium. Apply smarter and get noticed.

Upgrade to Premium

Join thousands of professionals who got noticed and hired faster.