Business System Analyst II/ Data Analyst

State of North Carolina

2d • Hybrid

About The Position

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.

Requirements

• 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.

Nice To Haves

• 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.

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.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees