State of North Carolina
Business Systems Analyst II
State of North Carolina, Wilmington, North Carolina, United States, 28412
Salary:
$62,739.00 - $109,794.00 Annually
Location :
Wake County, NC
Job Type:
Permanent Full-Time
Remote Employment:
Flexible/Hybrid
Job Number:
24-06037 DHB 60042826
Department:
Dept of Health and Human Services
Division:
HEALTH BENEFITS
Opening Date:
09/18/2024
Closing Date:
10/1/2024 5:00 PM Eastern
Job Class Title:
Business Systems Analyst II
Position Number:
60042826
Section:
Health Benefits
Work Location:
Raleigh, Wake County
Salary Grade:
NC19
Recruitment Range:
$62,739 to $90,000
Description of Work
**This position is exempt from the State Human Resources Act**
This position was reposted. Previous applicants must reapply to be considered.
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 4 working days per month or more as needed for business operations. Telework options are subject to change at the discretion of management. More information on this arrangement may be obtained at the time of interview.
This position's duty station is assigned to Dix Campus in Raleigh, North Carolina.
Position Summary
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 reports to the Associate Director of Quality Reporting Solutions. The Business Systems Analyst II provides reporting and analysis of Medicaid financial and claims data in support of the DHHS Division of Medicaid objectives and operations. This position evaluates the functionality of the most complex business and program application systems to identify gaps and measuring the solution impact on agency operations. This position forecasts business needs and divisional strategic plans and design solutions that align business processes and the applications that support them with those goals.
Job Specific ResponsibilitiesPerform data research and analysis to support mother/birth parent to baby matching using data resourced from NC Birth Certificate data in support of complex maternal measures, analysis of data resourced from the NC Immunization Registry and Health Information Exchange.Develop complex extracts, reports and analysis using data and information from data warehouses, Medicaid claims processing system (MMIS), NC accounting systems and other division data sources.Use various Business Intelligence tools and programming languages such as SQL and SAS to build reports and extract data from division systems.Design, build extracts, and query large data sets from data warehouses.Provide consultative support to staff around business processes and practices that drive division data.Provide consultative support and coaching to non-analyst staff on appropriate use of data and reporting tools.Knowledge, Skills and Abilities / Competencies
To receive credit for all of your work history and credentials, you must list the information on the application form. Any information listed under the text resume section or on an attachment will not be considered for qualifying credit. Qualified applicants must document on the application that they possess all of the following:
Experience communicating effectively with internal and external stakeholders.Strong analytical skills including data analysis, data modeling, and/or data mining.Thorough knowledge of applicable Business Information (BI) systems, testing methodologies, training, and business system analysis.Experience working with standard database query tools, such as SQL, SAS, or other commensurate tools, such as Business Objects.Experience presenting data visually using tools like Tableau, QlikView, Cognos, Microsoft Power BI, Google Charts, and/or other similar tools.Strong proficiency in Microsoft Excel.Experience with managing client data and report requests or issues; ability to fully understand and address them.Management Preferences:
Previous and proven work experience at Division of Health Benefits/NC Medicaid or other large health insurance company.Familiarity with relevant and current NC Medicaid operations or other large health insurance company.Thorough knowledge and experience with SAS/SQL and Cognos and/or Tableau.Experience with Medicaid and/or other healthcare systems and data.
Minimum Education and Experience Requirements
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
oshr.nc.gov/experience-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.
Degrees must be from appropriately accredited colleges or universities.
Supplemental and Contact Information
The North Carolina Department of Health and Human Services is an Equal Opportunity Employer.
Pre-employment criminal background checks are required for all positions with the Division of Health Benefits (DHB).
About NC Medicaid (Division of Health Benefits)
The North Carolina Department of Health and Human Services (NCDHHS) works closely with beneficiaries, health care professionals, community leaders and advocacy groups; local, state and federal entities; and other community partners vested to improve the health and safety of all North Carolinians by providing essential human services. NCDHHS is one of the largest, most complex agencies in the state, with about 17,000 employees.
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, NC Medicaid Managed Care 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 $21 billion in state and federal funds per fiscal year, DHB ensures that more than 96,000 enrolled providers are reimbursed for delivering covered services to 2.9 million beneficiaries.
Realizing the strength of DHB lies in its employees, DHB remains dedicated in its efforts to create and maintain a diverse, equitable and inclusive workplace environment.
Application Process
Applicants are encouraged to apply for positions of interest, regardless of their current grade level and job classification. A pay increase may or may not result. Salary decisions are based on relevant education and experience, budget, and internal equity.
To be under consideration for this vacancy, all applicants must complete an online application using this link: https://www.governmentjobs.com/careers/northcarolina. If multiple applications are submitted to an individual posting, only the most recent application received prior to the posting close date will be evaluated for consideration.
Due to the volume of applications received, we are unable to provide information regarding the status of your application. To check the status of your application, please log in to your GovernmentJobs.com account. You will either receive a call or email to schedule an interview or an email notifying you when the job has been filled. For technical issues with your application, please call the NeoGov Help Line at 855-524-5627. If there are any questions about this posting other than your application status, please contact us at Medicaid.Recruitment@dhhs.nc.gov.
NOTE: For temporary, contract or other supplemental staffing appointments:There are no paid leave, retirement or other benefits associated with these appointment types.
For permanent and time-limited appointments:Eligible employees have benefits that include employee health insurance options, standard and supplemental retirement plans, NC Flex (a variety of high-quality, low-cost benefits on a pre-tax basis), and paid vacation, sick, and community service leave, to name a few. Paid parental leave is available for eligible employees. Some benefits require 30 + hours work/week for participation.
01
I UNDERSTAND that DHHS requires a complete descriptive work history with all employment experience detailed to be considered for employment. Answers to supplemental questions are not a substitute for providing all relevant information within the body of your application. In order to receive credit for the supplemental questions in which you answered yes, you must provide supporting information within the body of the application, to support your answer. Your application should also reflect all education and all professional work experience acquired including high school and all degrees. It is critical to our screening and salary determination process that applications contain comprehensive candidate information. (NOTE: AN ATTACHED RESUME NOR "SEE RESUME" DOES NOT SATISFY THE REQUIREMENT OF COMPLETING THE APPLICATION. If you haven't completed the application requirements, please return to your application to finish it before submitting your application.)
Yes, I understand and have fully completed all requirements.
02
Which of the following best describes your current employment status?
DHB Permanent or DHB Time-Limited employeeDHB Temporary or DHB Contractor staffOther
03
I understand that the budgeted salary for this position is limited to $90,000. The posted recruitment range for this position is $62,739 to $90,000. If selected for this position, the salary offered will be within that range and based on your related education and experience on your application as well as internal equity. Would a salary within the posted recruitment range be acceptable to you?
Yes, if offered, I would accept a salary offer within the posted recruitment range.No, if offered, I would not accept a salary offer within the posted recruitment range.
04
I understand that this position is based in North Carolina. Division of Health Benefits employees with an approved hybrid telework schedule are currently expected to work onsite at their assigned duty station at least 4 working days per month or more as needed for business operations. Telework options are subject to change at the discretion of management.
I understand and can comply with this working arrangement.I am unable or unwilling to comply with this working arrangement.
05
In which of the following tools do you have experience? This experience must also be sufficiently documented on your application to receive credit. Please check all that apply.
Business ObjectsCognosGoogle ChartsMicrosoft ExcelMicrosoft Power BISASSQLSQL Server/Developer/My SQLOracle RDBMSQlikViewTableauNone of the above
06
Briefly describe your experience working with the analytical tools mentioned in question 5. Writing "see cover letter," "see application" "see resume," or a similar statement will result in a disqualified application. If you answered question 5 with "none of the above" please write N/A as your response to this question.
07
Have you ever been convicted of an offense against the law other than a minor traffic violation? (A conviction does not mean you cannot be hired. The offense and how recently you were convicted will be evaluated in relation to the position for which you are applying.)
YesNo
08
If you answer "yes" that you have been convicted of an offense against the law other than a minor traffic violation, please explain the nature of the conviction and the offense. If you answered "no" to the conviction question, please enter N/A as your response.
09
Where did you learn about DHHS or this opportunity?
Company or OSHR WebsiteEmployee ReferralConference / Career FairEmail campaignProfessional Association or Industry-specific job boardIndeedLinkedInNC Nursing Board emailGoogleOther General Job BoardsOther Search EnginesOther Social MediaInternet AdvertisementTV / Radio
10
Please give additional detail where you learned of DHHS or this opportunity. (e.g., APA Annual Meeting in NYC in May 2021, Facebook, LinkedIn, Doximity, NC Substance Abuse Professional Practice Board, etc.))
Required Question
$62,739.00 - $109,794.00 Annually
Location :
Wake County, NC
Job Type:
Permanent Full-Time
Remote Employment:
Flexible/Hybrid
Job Number:
24-06037 DHB 60042826
Department:
Dept of Health and Human Services
Division:
HEALTH BENEFITS
Opening Date:
09/18/2024
Closing Date:
10/1/2024 5:00 PM Eastern
Job Class Title:
Business Systems Analyst II
Position Number:
60042826
Section:
Health Benefits
Work Location:
Raleigh, Wake County
Salary Grade:
NC19
Recruitment Range:
$62,739 to $90,000
Description of Work
**This position is exempt from the State Human Resources Act**
This position was reposted. Previous applicants must reapply to be considered.
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 4 working days per month or more as needed for business operations. Telework options are subject to change at the discretion of management. More information on this arrangement may be obtained at the time of interview.
This position's duty station is assigned to Dix Campus in Raleigh, North Carolina.
Position Summary
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 reports to the Associate Director of Quality Reporting Solutions. The Business Systems Analyst II provides reporting and analysis of Medicaid financial and claims data in support of the DHHS Division of Medicaid objectives and operations. This position evaluates the functionality of the most complex business and program application systems to identify gaps and measuring the solution impact on agency operations. This position forecasts business needs and divisional strategic plans and design solutions that align business processes and the applications that support them with those goals.
Job Specific ResponsibilitiesPerform data research and analysis to support mother/birth parent to baby matching using data resourced from NC Birth Certificate data in support of complex maternal measures, analysis of data resourced from the NC Immunization Registry and Health Information Exchange.Develop complex extracts, reports and analysis using data and information from data warehouses, Medicaid claims processing system (MMIS), NC accounting systems and other division data sources.Use various Business Intelligence tools and programming languages such as SQL and SAS to build reports and extract data from division systems.Design, build extracts, and query large data sets from data warehouses.Provide consultative support to staff around business processes and practices that drive division data.Provide consultative support and coaching to non-analyst staff on appropriate use of data and reporting tools.Knowledge, Skills and Abilities / Competencies
To receive credit for all of your work history and credentials, you must list the information on the application form. Any information listed under the text resume section or on an attachment will not be considered for qualifying credit. Qualified applicants must document on the application that they possess all of the following:
Experience communicating effectively with internal and external stakeholders.Strong analytical skills including data analysis, data modeling, and/or data mining.Thorough knowledge of applicable Business Information (BI) systems, testing methodologies, training, and business system analysis.Experience working with standard database query tools, such as SQL, SAS, or other commensurate tools, such as Business Objects.Experience presenting data visually using tools like Tableau, QlikView, Cognos, Microsoft Power BI, Google Charts, and/or other similar tools.Strong proficiency in Microsoft Excel.Experience with managing client data and report requests or issues; ability to fully understand and address them.Management Preferences:
Previous and proven work experience at Division of Health Benefits/NC Medicaid or other large health insurance company.Familiarity with relevant and current NC Medicaid operations or other large health insurance company.Thorough knowledge and experience with SAS/SQL and Cognos and/or Tableau.Experience with Medicaid and/or other healthcare systems and data.
Minimum Education and Experience Requirements
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
oshr.nc.gov/experience-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.
Degrees must be from appropriately accredited colleges or universities.
Supplemental and Contact Information
The North Carolina Department of Health and Human Services is an Equal Opportunity Employer.
Pre-employment criminal background checks are required for all positions with the Division of Health Benefits (DHB).
About NC Medicaid (Division of Health Benefits)
The North Carolina Department of Health and Human Services (NCDHHS) works closely with beneficiaries, health care professionals, community leaders and advocacy groups; local, state and federal entities; and other community partners vested to improve the health and safety of all North Carolinians by providing essential human services. NCDHHS is one of the largest, most complex agencies in the state, with about 17,000 employees.
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, NC Medicaid Managed Care 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 $21 billion in state and federal funds per fiscal year, DHB ensures that more than 96,000 enrolled providers are reimbursed for delivering covered services to 2.9 million beneficiaries.
Realizing the strength of DHB lies in its employees, DHB remains dedicated in its efforts to create and maintain a diverse, equitable and inclusive workplace environment.
Application Process
Applicants are encouraged to apply for positions of interest, regardless of their current grade level and job classification. A pay increase may or may not result. Salary decisions are based on relevant education and experience, budget, and internal equity.
To be under consideration for this vacancy, all applicants must complete an online application using this link: https://www.governmentjobs.com/careers/northcarolina. If multiple applications are submitted to an individual posting, only the most recent application received prior to the posting close date will be evaluated for consideration.
Due to the volume of applications received, we are unable to provide information regarding the status of your application. To check the status of your application, please log in to your GovernmentJobs.com account. You will either receive a call or email to schedule an interview or an email notifying you when the job has been filled. For technical issues with your application, please call the NeoGov Help Line at 855-524-5627. If there are any questions about this posting other than your application status, please contact us at Medicaid.Recruitment@dhhs.nc.gov.
NOTE: For temporary, contract or other supplemental staffing appointments:There are no paid leave, retirement or other benefits associated with these appointment types.
For permanent and time-limited appointments:Eligible employees have benefits that include employee health insurance options, standard and supplemental retirement plans, NC Flex (a variety of high-quality, low-cost benefits on a pre-tax basis), and paid vacation, sick, and community service leave, to name a few. Paid parental leave is available for eligible employees. Some benefits require 30 + hours work/week for participation.
01
I UNDERSTAND that DHHS requires a complete descriptive work history with all employment experience detailed to be considered for employment. Answers to supplemental questions are not a substitute for providing all relevant information within the body of your application. In order to receive credit for the supplemental questions in which you answered yes, you must provide supporting information within the body of the application, to support your answer. Your application should also reflect all education and all professional work experience acquired including high school and all degrees. It is critical to our screening and salary determination process that applications contain comprehensive candidate information. (NOTE: AN ATTACHED RESUME NOR "SEE RESUME" DOES NOT SATISFY THE REQUIREMENT OF COMPLETING THE APPLICATION. If you haven't completed the application requirements, please return to your application to finish it before submitting your application.)
Yes, I understand and have fully completed all requirements.
02
Which of the following best describes your current employment status?
DHB Permanent or DHB Time-Limited employeeDHB Temporary or DHB Contractor staffOther
03
I understand that the budgeted salary for this position is limited to $90,000. The posted recruitment range for this position is $62,739 to $90,000. If selected for this position, the salary offered will be within that range and based on your related education and experience on your application as well as internal equity. Would a salary within the posted recruitment range be acceptable to you?
Yes, if offered, I would accept a salary offer within the posted recruitment range.No, if offered, I would not accept a salary offer within the posted recruitment range.
04
I understand that this position is based in North Carolina. Division of Health Benefits employees with an approved hybrid telework schedule are currently expected to work onsite at their assigned duty station at least 4 working days per month or more as needed for business operations. Telework options are subject to change at the discretion of management.
I understand and can comply with this working arrangement.I am unable or unwilling to comply with this working arrangement.
05
In which of the following tools do you have experience? This experience must also be sufficiently documented on your application to receive credit. Please check all that apply.
Business ObjectsCognosGoogle ChartsMicrosoft ExcelMicrosoft Power BISASSQLSQL Server/Developer/My SQLOracle RDBMSQlikViewTableauNone of the above
06
Briefly describe your experience working with the analytical tools mentioned in question 5. Writing "see cover letter," "see application" "see resume," or a similar statement will result in a disqualified application. If you answered question 5 with "none of the above" please write N/A as your response to this question.
07
Have you ever been convicted of an offense against the law other than a minor traffic violation? (A conviction does not mean you cannot be hired. The offense and how recently you were convicted will be evaluated in relation to the position for which you are applying.)
YesNo
08
If you answer "yes" that you have been convicted of an offense against the law other than a minor traffic violation, please explain the nature of the conviction and the offense. If you answered "no" to the conviction question, please enter N/A as your response.
09
Where did you learn about DHHS or this opportunity?
Company or OSHR WebsiteEmployee ReferralConference / Career FairEmail campaignProfessional Association or Industry-specific job boardIndeedLinkedInNC Nursing Board emailGoogleOther General Job BoardsOther Search EnginesOther Social MediaInternet AdvertisementTV / Radio
10
Please give additional detail where you learned of DHHS or this opportunity. (e.g., APA Annual Meeting in NYC in May 2021, Facebook, LinkedIn, Doximity, NC Substance Abuse Professional Practice Board, etc.))
Required Question