Business Analyst-Provider Network Crisis System (Full-time Remote, North Carolina Based) (Information Technology)

The Business Analyst-PN Crisis System role will develop and analyze business performance reports utilizing EDI claims and encounter data, and provider utilization data, to identify trends, anomalies, and issues that may require the attention and/or intervention of Alliance leadership.  This position will report and present crisis system utilization and performance data to internal and external stakeholders on a regular basis.  This position will maintain data dashboards and interrogate data to ensure accuracy, consistency, reliability, and completeness, and act as Subject Matter Expert (SME) regarding crisis data assets. This position will also support additional report generation processes for deliverables containing data needed from multiple resources or workstreams, including the ability to pull ad hoc reports from the Data Warehouse.  

This position is full-time remote. Selected candidate must reside in North Carolina.

 Responsibilities & Duties

Analyze Business Requirements and Translate into Specifications

• Analyze business activities to identify report and data requirements
• Translate business requirements into business report documentation specifications
• Conduct research through business specifications, contracts, journals, web resources, and in-person interviews to determine data requirements for projects
• Lead efforts to clarify any specifications that are unclear

Develop Reports and Data Visualization Solutions

• Develop or apply mathematical or statistical theory and methods to collect, organize, interpret, and summarize numerical data to provide usable information
• Perform data acquisition, analysis, and evaluation via advanced SQL queries and stored procedures, MicroStrategy, and other data management tools to manipulate large data sets
• Design solutions using BI concepts including dynamic and parameter driven reporting, dashboards, and alerts
• Using thorough knowledge of available data, design products that merge data from various sources including EDI files, HIE, State data, transactional system, and data warehouse
• Provide support as required to ensure the accuracy of developed reports and metrics for both external and internal users
• Ensure that reporting activities are conducted in ways that correspond with externally mandated specifications
• Assist the Provider Network Department with any data assurance/integrity efforts required as part of larger quality activities, and with the completion and validation of state-required reports

Develop and Document Processes

• Engineer efficient processes for gathering statistical data, identifying complex trends, and translating insights into actionable recommendations

Collaborate with Other Departments to Enhance Operations

• Work closely with IT Department to enhance operations and automation of reports and processes and perform quality assurance testing of systems and products
• Actively participate in Data Governance committee and Business Analyst teams
• Attend IT/Reporting trainings or meetings that are relevant to the above responsibilities

Manage Testing and End User Support

• Manage the User Acceptance Testing process and feedback
• Provide End User support on solutions and data interpretation
• Conduct peer reviews and test solutions for functionality and data accuracy

Minimum Requirements

Education & Experience

Bachelor's degree in data science, information science, human services/healthcare, or related field and two (2) years of experience with quantitative and qualitative data collection and analysis methods, research design, program evaluation, and testing of applications or reports and dashboards.  

Technical experience and skills required:

• Advanced experience with Microsoft Excel (pivot tables, formulas (vlookup, xlookup, match, etc.) 
• Intermediate-advanced SQL experience (manipulating data and queries) and relational databases
• Proficiency in PowerBI and other data visualization tools

Experience in healthcare data analytics utilizing Medicaid claims and encounter data preferred.

Knowledge, Skills, & Abilities

• Knowledge of data integration (validation and cleaning)
• Knowledge of complex data and structures
• Knowledge of the healthcare industry
• Advanced knowledge of relational database systems, statistical analysis, data mining, predictive analytics, performance measurement, and other data science concepts
• Knowledge of data visualization principles and strategies
• Skilled in various software applications and informatics systems (Excel, Access, SAS, SPSS, Tableau, Power BI, Qualtrix, EPIC EMR system and SQL language/processes)
• Excellent oral and written communication skillsare required to support working in project environments that includes internal and external stakeholders and customer teams
• Strong analytical, conceptual, and problem-solving skills
• Ability to work with large-volume clinical and financial data and transactions
• Ability to work independently and to carry out assignments to completion within parameters of instructions given, prescribed routines, and standard accepted practices
• Ability to manage multiple priorities and adjust quickly to changing priorities

Employment for this position is contingent upon a satisfactory background check and credit check, which will be performed after acceptance of an offer of employment and prior to the employee's start date. 

Salary Range

$66,240 -$86,112/Annually

Exact compensation will be determined based on the candidate's education, experience, external market data and consideration of internal equity. 

An excellent fringe benefit package accompanies the salary, which includes:  

• Medical, Dental, Vision, Life, Long Term Disability
• Generous retirement savings plan
• Flexible work schedules including hybrid/remote options
• Paid time off including vacation, sick leave, holiday, management leave
• Dress flexibility

Education

Preferred

• Bachelors or better in Information Technology
• Bachelors or better in Business Administration
• Bachelors or better in Human Services

Skills

Required

• Communication
• Creative Thinking
• Data Analytics
• Microsoft Office
• Problem Solving

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.

See job description