Business System Analyst II/ Data Analyst

Agency Dept of Health and Human Services Division HEALTH BENEFITS Job Classification Title Business Systems Analyst II (NS) Position Number 65024415 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 17,000 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 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. Job Specific 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. 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 8 working days per month. More information on this arrangement may be obtained at the time of interview. Knowledge Skills and Abilities/Management Preferences Salary Grade Range $67,122 - $117,465 Recruitment Range $67,122 - $95,639 Position is eligible for a hybrid-teleworking schedule to include weekly onsite work hours 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: 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. 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. Posting closes at 1