Business Systems Analyst II

Agency

Dept of Health and Human Services

Division

HEALTH BENEFITS

Job Classification Title

Business Systems Analyst II (NS)

Position Number

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 17000 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

Description of Work:
**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 4 working days per month. More information on this arrangement may be obtained at the time of interview.

This positions duty station is assigned to the NC DHHS Main Campus in Raleigh North Carolina.

Position Summary
The Business Information & Analytics (BIA) Office is a centralized business intelligence (BI) team that uses analytical techniques to solve questions by identifying and gathering strategic insights from Medicaid data. BIA is committed to advancing decision support through systematic analysis accurate reporting timely delivery and sustainable growth of organizational reporting capacity.

This Business Systems Analyst II position reports to the Associate Director of Business Intelligence Solutions. The position provides reporting and analysis solutions in support of divisional objectives and operations.

Job Specific Responsibilities:

Collaborate with business partners to define identify and document dashboard requirements and solutions while proposing valuable design and analytical solutions.
Administer NC Medicaids internal Microsoft Power BI and Tableau sites and provide consultation on Microsoft Power BI and Tableau to staff.
Prepare data from disparate data sources for use in Microsoft Power BI and Tableau dashboards or for BIA business partners direct use by developing queries using Microsoft Power BI SAS SQL and Tableau Prep code. This involves development of complex extracts from Medicaid Management Information Systems (MMIS)Medicaid and Commercial Health Care administrative claims provider enrollment data member eligibility/enrollment data and other internal data sources.
Create well-designed effective dashboards with advanced drill downs actions filters and parameters in MS Power BI and Tableau for data quality managed care performance member and provider enrollment operational and executive KPIs etc. which aid in data driven decision making.
Provide the data and tools to support qualitative and quantitative analyses using Microsoft Power BI Tableau SAS and SQL to support program design decisions.
Analyze impact of programmatic changes using Microsoft Power BI SAS SQL and Tableau dashboards.
Perform data quality and validation checks to ensure accuracy and integrity in reports and dashboards.
Provide consultative support and coaching to non-analyst staff on appropriate use of data and analysis tools.

Knowledge Skills and Abilities/Management Preferences

Salary Grade Range $64621 - $113088

Recruitment Range $64621 - $97968

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:

• Proven ability to work with standard database query tools such as SQL SAS or other commensurate tools.

• Strong report dashboard and data flow development skills with one or more business intelligence/data visualization products including Microsoft Power BI or Tableau.

• Strong analytical skills including data analysis data modeling and/or data mining.

• Proven ability in establishing and maintaining effective working relationships.

• Thorough knowledge of applicable Business Information (BI) systems testing methodologies and business system analysis.

Management Preferences:

• Experience converting existing Tableau dashboards and data flows to MS Power BI.

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

• Familiarity with relevant and current NC Medicaid operations.

• Experience with Medicaid and/or other healthcare systems and data.

This position will close at 11:59 p.m. the night before the end date.

This position is funded in part through Federal Funds

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.

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 108000 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 addition paid parental leave is available to eligible employees.
Visit website forState Benefits

Supplemental and Contact Information

The North Carolina Department of Health and Human Services (DHHS) is an Equal Opportunity Employerthat embraces an Employment First philosophy which consists of complying with all federallaws 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: 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 Governors 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 must be submitted by 11:59 PM on the closing date.

• Applicantsmaybe subject to a criminal background check. All candidates selected for positions considered Positions of Trustwill besubject 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 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 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 Veterans Preference must attach aDD-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. 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.

  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.

  • Bachelors 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: