This Business Analyst-CHWB position will support the design, development, implementation and support of priority data, reporting needs, and enhanced dashboard analytics for the Community Health & Well-Being (CHWB) Department. This position will primarily concentrate on community health data sets as related to social drivers of health, housing, criminal justice, and other priority population health focus areas. This position also conducts quality assurance testing related to IT reporting, data integrity, and analyses and serves as a liaison between CHWB, Business Owners, and IT to coordinate data collection and report development efforts.
This position is full-time remote. Selected candidate must reside in North Carolina and available to travel for onsite meetings to the Home office (Morrisville, NC), as required.
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
Perform data acquisition, analysis, and evaluation via advanced SQL queries and stored procedures, MicroStrategy, and other data management tools
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 CHWB Department with any data assurance/integrity efforts required as part of larger quality activities, and with the completion and validation of state-required reports
Provide support to our Social Drivers of Health (SDOH) CQI Committee as we enhance and further develop dashboard analytics, reporting capabilities and processes related to SDOH
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 as appropriate
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 computer science, information science, public health, human services/healthcare, or related field and (2) two years of experience with quantitative and qualitative data collection and analysis methods, research design, program evaluation, and testing of applications or reports and dashboards.
Prior experience working with community health and population health data sets is required.
Preferred:
Prior experience with epidemiological research methods preferred. Prior experience in working with Medicaid health plans preferred. Certified Health Education Specialist (CHES®) credential preferred. Any certification or course work related to epidemiological research methods 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 SQL (Writing queries and reporting)
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 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 work with large-volume clinical and financial data and transactions
Ability to manage projects and deliver within specified timeframes
Ability to manage multiple priorities and adjust quickly to changing priorities
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