Business Analyst – PN Crisis System

Role Overview

• 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
• Report and present crisis system utilization and performance data to internal and external stakeholders on a regular basis
• Maintain data dashboards and interrogate data to ensure accuracy, consistency, reliability, and completeness
• Act as Subject Matter Expert (SME) regarding crisis data assets
• 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
• 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 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
• Engineer efficient processes for gathering statistical data, identifying complex trends, and translating insights into actionable recommendations
• Collaborate 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
• 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.

Requirements

• Bachelor’s degree in data science, information science, human services/healthcare, or related field
• 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
• 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 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 skills
• 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.

Tech Stack

• SQL
• Tableau

Benefits

• 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