NC Department of Health and Human Services · 4 hours ago
Business Systems Analyst II
Wake County, NC
Full-time
Hybrid
Mid Level
$65K/yr - $113K/yr
3+ years expThe North Carolina Department of Health and Human Services (DHHS) is one of the largest agencies in the state, responsible for ensuring health and well-being for all North Carolinians. The Business Systems Analyst II position focuses on providing reporting and analysis solutions to support divisional objectives, collaborating with partners to define dashboard requirements, and utilizing data visualization tools like Microsoft Power BI and Tableau.
Health Care
Responsibilities
Collaborate with business partners to define, identify, and document dashboard requirements and solutions while proposing valuable design and analytical solutions
Administer NC Medicaid’s 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
Qualification
Required
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
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
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
Benefits
Employees can participate in health insurance options
Standard and supplemental retirement plans
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
Company
NC Department of Health and Human Services
The Department of Health and Human Services manages the delivery of health- and human-related services for all North Carolinians.
10001+ employees
Funding
Current Stage
Late StageLeadership Team
Erin Matteson
Chief Financial Officer, Opportunity and Well-being
Jean M. Sandaire
Business Manager/CFO - O'Berry Neuro Medical Treatment Center
Recent News
Seattle TechFlash
2025-04-16
Seattle TechFlash
2025-03-27
Triangle Business Journal
2025-03-21
Company data provided by crunchbase