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

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...