Business Analyst -Quality Management (Full-Time Remote, North Carolina Based)

The Business Analyst-Quality Management provides design, development, implementation, and support of mission-critical reports that allow for successful evaluation of the quality components of Alliance Health.  The Analyst also conducts quality assurance testing related to IT reporting, data integrity, and analyses and functions as a liaison between Quality Management, Business Owners, and IT to coordinate data collection and report development efforts.

This position will allow the successful candidate to work primarily remote. There is no expectation of being in the office routinely, but they will be required to report to the corporate home office located in Morrisville, NC as needed and be a resident of North Carolina.

Responsibilities & Duties

Analyze business requirements and translate into specifications

• Analyze healthcare 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

• Perform data acquisition, analysis, evaluation, and analystics via advanced SQL queries and stored procedures, MicroStrategy, Excel, and other data management tools
• Design solutions using BI concepts including dynamic and parameter driven reporting, dashboards, data visualization, 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 create and provide data visualization solutions to stake holders
• 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 QM Department with any data assurance/integrity efforts required as part of larger quality activities, and with the completion and validation of state-required reports
• Perform geocoding activities through GIS software to analyze spatial statistics

Develop and document processes

• Audit, develop, and document processes to accurately monitor data associated with contract performance measures, HEDIS measures, and program requirements
• 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
• Serve as the department liaison on Alliance Claims System development; participate in the Alliance Claims System user group meetings
• 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

 Knowledge, Skills, & Abilities

• Advanced experience with SQL
• Advanced experience with Excel (MS Excel test will be administered during the interview process)
• Experience with tools such as MicroStrategy, Power BI, or Tableau
• Knowledge of data integration (validation and cleaning) 
• Knowledge of complex data and structures
• Knowledge of geographic information science and systems and ability to perform spatial analysis
• 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
• Knowledge of Programming / scripting and software development life cycle is preferred
• Excellent interpersonal (verbal and written) communication skills are required to support working in project environments that includes internal, external and customer teams
• Strong analytical, conceptual, and problem-solving skills
• Ability to manage projects and deliver within specified timeframes
• Ability to manage multiple priorities and adjust quickly to changing priorities
• Ab