N.C. Department of Information Technology · 8 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 the health and well-being of all North Carolinians. They are seeking a Business Systems Analyst II to provide reporting and analysis solutions in support of divisional objectives and operations, collaborating with business partners to define and document dashboard requirements and solutions.
Information Technology & Services
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
Company
N.C. Department of Information Technology
The N.C.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Torre Jessup
Chief Operating Officer
Alysa Kelly
Executive Assistant to Chief Deputy/CIO/Chief Privacy Officer/Director of Enterprise Operations
Recent News
Government Technology US
2025-11-08
Government Technology US
2025-08-13
Government Technology US
2025-07-09
Company data provided by crunchbase