Data Analyst

JOB SUMMARY

The Division of Geriatrics seeks to recruit a full-time Data Analyst to support the Cognitive Health Assessment Metrics Post Positive Screen (CHAMPPS) project to focus on data collection, organization, management, and reporting. Reporting to the Principal Investigator, the Data Analyst will collaborate with a multi-site team to conduct key research activities, including Epic chart data abstraction. This role involves extracting, validating, and analyzing clinical data from patient records to support study objectives, ensure data quality, and contribute to research deliverables. The Data Analyst will also prepare reports, charts, tables, and other visualizations to effectively communicate findings. Additional responsibilities include building and maintaining quantitative (and potentially, qualitative) databases, supporting project planning, tracking timelines and milestones, and developing strong professional relationships with internal/external stakeholders. The role may also include other operational/administrative tasks to ensure overall project success. The ideal candidate would have significant experience with chart abstraction, quantitative research, and mixed methods research. We are seeking an individual who is highly collaborative, mission-driven, and has a strong interest in, and ideally background in research related to diverse populations, equity, older adults, and/or dementia care. A successful candidate is highly organized and able to prioritize multiple deadlines and competing tasks. Working with sensitive participant data requires utmost discretion and confidentiality. Effective communication skills (both verbal and written) are essential to this position.

REPORTING RELATIONSHIPS

Not applicable.

Required Qualifications

• Bachelor''s degree in related area and one or more years of related work experience and / or equivalent experience / training.

• Knowledge of common organization- or research-specific and other computer application programs, such as Microsoft Word, PowerPoint, and Windows/Mac.

• Strong communication and interpersonal skills to communicate effectively, both verbally and in writing.

• Strong technical skills including Excel, REDCap, web-based applications, database experience.

• Ability to use discretion and maintain all confidentiality.

• Strong analytical / problem-solving skills.

• Highly organized and able to multi-task with demanding timeframes and juggle multiple competing priorities.

• Demonstrated experience working with people from diverse cultural backgrounds and vulnerable populations.

• Experience using SmartSheets or other project management software.

• Demonstrates ability to use sound judgment in responding to issues and concerns.

• Experience working in Epic (or similar EHR system).

Preferred Qualifications

• Master's degree in a health care or social scientific field (e.g., MPH, MS, MA, MPA)

• Knowledge of UCSF and departmental policies for dealing with reimbursement, guidelines for research, confidentiality and HIPPA regulations.

• Experience working with CA state funded grants.

DUTIES & ESSENTIAL JOB FUNCTIONS

Identify the functions or tasks that employees in the job perform. The essential functions should state the purpose of the work and the results to be accomplished, rather than how the function is performed. Of the tasks listed, what percentage of time is devoted to each? The more time employees spend on a function, the more likely it is that the function is essential. Generally, include those functions that account for 10% or more of the work, i.e., key items that contribute significantly to the achievement of the job. The functions should add up to 100%.

%

of time

Essential Function (Yes/No)

Key Responsibilities

(To be completed by Supervisor)

70%

Yes

Data Collection and Management Functions

• Under the direction of the PIs, builds and maintains project databases and data infrastructure (e.g. in REDCap, Qualtrics, and/or Atlas.ti)
• Conducts structured chart reviews in Epic to extract study-specific data elements
• Accurately abstract and enter data into research databases (e.g., REDCap)
• Runs data reports using Epic EHR tools. E.g. workbench, SlicerDicer
• Perform data validation and quality assurance checks to ensure accuracy and completeness
• Maintains detailed documentation of data definitions, workflows, and abstraction procedures
• Identify any discrepancies and resolve data issues in collaboration with the team
• Helps standardize data collection across collaborating sites (e.g. through standard work documents) to accurately track data collection and management methods
• Performs literature searches/other research activities to gather data
• May transcribe qualitative data

15%

Yes

Project Implementation and Coordination Functions

• Collaborates on the design, documentation, testing and implementation of the research project including conducting literature reviews, preparing protocols for IRB applications, and assistance with grant preparation and submission
• Ensures compliance with all applicable policies, escalating matters to the leadership team where needed
• Support other project-related tasks as needed (such as calendar management and expense reimbursements)
• Coordinates implementation with cross-organizational departments or external entities as needed
• May coordinate the recruitment of study participants, including scheduling participants for interviews

15%

Yes

Reporting and Data Analyses

• Generate basic summaries and reports to support analysis and study progress
• Assists with creation, revision, and/or submission of research reports, white papers, posters, presentations, and publications

0

0

0

0

0

0

0

0

100%

(To update total %, enter the amount of time in whole numbers (without the % symbol - e.g., 15, 20) then highlight the total sum (e.g., 1%) at the bottom of the column and press F9. The total sum should add up to 100%.)

DUTIES & ESSENTIAL JOB FUNCTIONS

Identify the functions or tasks that employees in the job perform. The essential functions should state the purpose of the work and the results to be accomplished, rather than how the function is performed. Of the tasks listed, what percentage of time is devoted to each? The more time employees spend on a function, the more likely it is that the function is essential. Generally, include those functions that account for 10% or more of the work, i.e., key items that contribute significantly to the achievement of the job. The functions should add up to 100%.

%

of time

Essential Function (Yes/No)

Key Responsibilities

(To be completed by Supervisor)

70%

Yes

Data Collection and Management Functions

• Under the direction of the PIs, builds and maintains project databases and data infrastructure (e.g. in REDCap, Qualtrics, and/or Atlas.ti)
• Conducts structured chart reviews in Epic to extract study-specific data elements
• Accurately abstract and enter data into research databases (e.g., REDCap)
• Runs data reports using Epic EHR tools. E.g. workbench, SlicerDicer
• Perform data validation and quality assurance checks to ensure accuracy and completeness
• Maintains detailed documentation of data definitions, workflows, and abstraction procedures
• Identify any discrepancies and resolve data issues in collaboration with the team
• Helps standardize data collection across collaborating sites (e.g. through standard work documents) to accurately track data collection and management methods
• Performs literature searches/other research activities to gather data
• May transcribe qualitative data

15%

Yes

Project Implementation and Coordination Functions

• Collaborates on the design, documentation, testing and implementation of the research project including conducting literature reviews, preparing protocols for IRB applications, and assistance with grant preparation and submission
• Ensures compliance with all applicable policies, escalating matters to the leadership team where needed
• Support other project-related tasks as needed (such as calendar management and expense reimbursements)
• Coordinates implementation with cross-organizational departments or external entities as needed
• May coordinate the recruitment of study participants, including scheduling participants for interviews

15%

Yes

Reporting and Data Analyses

• Generate basic summaries and reports to support analysis and study progress
• Assists with creation, revision, and/or submission of research reports, white papers, posters, presentations, and publications

0

0

0

0

0

0

0

0

100%

(To update total %, enter the amount of time in whole numbers (without the % symbol - e.g., 15, 20) then highlight the total sum (e.g., 1%) at the bottom of the column and press F9. The total sum should add up to 100%.)