Data Analyst

Overall Summary

The Data Analyst will support Bay Area Community Health Center’s HIV, TransVision and Prevention ongoing clinic operations and population health initiatives by extracting, compiling, validating, analyzing, and presenting data to BACH leadership, senior management, and the agency’s collaborating partners. This position will help develop and drive clinical improvement and efficiency strategies through the influential delivery of actionable analytics.

Under general supervision of the Program director and supervisor and/or as part of various workgroups and teams, the Data Analyst will lead staff in coordinating, facilitating, and conducting report development, report writing, and comparative analysis, develop and report on different grants

The Data Analyst will:

• Advise BACH providers, leaders, and staff in the creation, interpretation, validation, and application of interactive dashboards to monitor and improve outcomes in patient care, service delivery, population health of patients and communities served, and other strategic initiatives.
• Work with IS staff to create, edit, validate, and maintain reports and dashboards, update/develop reporting tools as needed.
• Be the proactive data lead in multi-disciplinary teams/projects to support quality improvement projects.

Essential Responsibilities

Under the general direction of the program director and supervisor, the Data Analyst performs a variety of complex, professional, analytical, and confidential services. Duties include:

• Serve as liaison with departmental leaders, in HIV, TransVision and prevention to develop analytical approaches for accountable care.
• Lead efforts to ensure data integrity and validity and perform ongoing quality assurance of all data and reports.
• Extract and compile data from regulatory agency sources and BACH’s internal data sources and IT department and compare to benchmarks and standards for clinical and financial measures in order to give a clear picture of agency performance.
• Participate in developing clinical analyses, including visual displays, for BACH clinicians and operations.
• Prepare reports and analyses of the clinical and economic impacts on the care provided to groups of patients for various quality improvement.
• Explore variations in patient satisfaction and clinical outcomes.
• Identify and analyze patient characteristics that are associated with particular health outcomes or are predictive of future use of particular health care services.
• Improve the quality of data and information by working with users to identify reporting needs, define report specifications, and develop reports to meet business requirements, turning the reports/processes over to end users’ control whenever possible.
• Attend meetings as needed to provide actionable variance data, ensure appropriate interpretation of information, and elicit information needs.
• Optimize recurring reporting processes to inform existing and emerging care delivery processes.
• Identify need for changes to workflow procedures and/or system configuration modifications.
• Ensure integrity and validity of annual UDS data submission.
• Submit Meaningful Use attestations, including data collection, data validity, and submission of materials.
• Utilize all available analytic tools throughout BACH EHR system and available through external health partners.
• Ensure that analytics and reporting requests submitted to the CQ department are completed within the agreed upon timeline.

Data Analyses, Report, and Study Design

• Understand and validate data from multiple sources.
• Conduct complex data manipulation programming and statistical analyses.
• Provide statistical support in designing and evaluating programs in CHCN and member clinics
• Answer business questions using data
• Design or modify user friendly database for non-technical personnel to do data entry.
• Design and automate complex and meaningful reports for leadership to make business decision and for clinical staff to use in clinical practices.
• Prepare a variety of correspondences, periodic and special reports, informational publications, program documentation, policies, procedures, and other written materials for distribution to clinics and funders.

Secondary Responsibilities:

• Other duties as assigned.
• Assume general administration duties including fax, filing, copying, etc.
• Attend webinars, workshops, training and/or meetings as requested by the Director.
• Perform special project research and data collection activities as requested by the Director; analyze and interpret data, and prepare reports.
• Coordinate special staff events and prepares and distributes promotional flyers for such events.

Qualifications:

Required Education, Skills, and Experience

• Bachelor’s degree in science, public health, statistics, business, or related field with 2 years of clinical/health care experience
• Meaningful experience (2 years) with data modeling, trend analysis, and statistical reporting.
• Experience working on the backend of an Electronic Health Record system
• Proficiency in Microsoft suite.
• Demonstrated ability to exercise good judgment, prioritize multiple projects, and problem solve under tight deadlines and resource constraints.
• Matrix relational influencing skills, including demonstrated ability to facilitate consensus across functional, departmental, and organizational boundaries.
• Excellent written and interpersonal communication skills and presentation skills, including ability to present complex technical concepts in a clear, concise manner to audiences with varying levels of technical understanding

Preferred Education, Skills, and Experience

• Master’s degree or higher in public health, epidemiology, health sciences, statistics, business, finance, economics and/or health administration
• Proficiency in analyzing a wide array of data types, including medical and pharmacy claims, clinical process and outcome data, e.g., HEDIS and other performance metrics, and survey data.
• Proficiency with visualization tools (such as Tableau).
• Knowledge of and familiarity with NCQA
• Knowledge of PCMH requirements/application process.
• Experienced user of SSRS and SQL reports and Power BI
• Experience working with a Federally Quality Health Center
• Experience using different electronic reporting tools and grants reports.

Competencies

• Ability to conduct appropriate analysis independently with solid statistics knowledge and answer business questions.
• Ability to reliably and consistently deliver quality work product on target dates with minimum supervision.
• Willing to take the ownership and responsibility of projects.
• Experience of data analysis/visualization tools such as Excel and Tableau.
• Understanding of relational database, experience of data manipulation using ACCESS and Excel.
• Good written and verbal communication skills to allow for effective communication with a diverse audience.
• Highly motivated and capable of adopting new methods, knowledge and skills quickly.
• Ability to work in a team, to give and receive constructive feedback.
• Ability to work in a fast pace environment and competing deadlines.

Work Conditions:

Travel locally to visit other sites, may require a day or overnight trip to attend events; workload may be demanding at times; require professionalism and confidentiality.

Physical Demands:

This position requires:

• Sitting, walking, and standing associated with a normal medical/clinical office environment.
• Regular bending and stretching; and lifting.
• Manual dexterity used to include, but not limited to, standard office equipment, and computer keyboard.
• Traveling to work sites including some exposure to outside elements.
• Presenting information in front of a group.
• Reading and writing in order to review records for accuracy.

Supervises:

None