Description

Business Data Analyst 2

US-OR-Portland

Requisition ID: 2025-37232
Position Category: Administrative/Office Support
Job Type: AFSCME union represented
Position Type: Regular Full-Time
Posting Department: Deans Administration
Posting Salary Range: $34.43 - $47.27 per hour with offer based on experience, education and internal equity
Posting FTE: 1.00
Posting Schedule: Monday-Friday (Hybrid)
Posting Hours: 8am-4:30pm
HR Mission: School of Medicine
Drug Testable: No

Department Overview
The Graduate Medical Education Business Data Analyst for Strategic Alignment & Integration is responsible for data collection, analysis, and reporting for use in business planning and decision-making. OHSU GME Administration oversees over 100 GME training programs, each with unique medical education requirements. This position will provide a continuation of existing information reporting and will be responsible for developing new data analysis and reporting methodologies. This position is expected to remain current with information analysis trends and best practices. There may be some opportunities for data collection design and analysis for medical education research projects. Business Analysis and Development
Gathers and combines raw data from a variety of sources for business use. Cleans, transforms, and creates new variables from raw data. Analyzes information and prepares data for reporting.
Works collaboratively with other OHSU, local, and state offices. Develop instruments and methodology for describing the transition from hometown to medical school to GME training and into the workforce. Analyzes workforce data regarding rural and underserved communities, faculty retention/attrition at OHSU, and alumni retention metrics for OHSU and the state of Oregon. Report GenerationGenerates professional reports on OHSU GME recruitment, graduation metrics, physician workforce, accreditation, and annual snapshots. Presents information in infographic, detailed report, and dashboard formats. Uses appropriate data visualization to enhance understanding of the information. GME Data Management
Provide recommendations on data quality and management. Maintains a data repository and project documentation. The data analyst is responsible for staying current with OHSU Health and OHSU Information Technology Group policies, including but not limited to the Data Governance Office, Artificial Intelligence, HIPPA, FERPA, and Private/Sensitive Information (PSI).Function/Duties of Position

• Design and execute data projects to assess the performance of GME programs. Develop and follow existing methodology, create and validate data collection tools, select or design data-storage tools, gather data, select and execute appropriate analytical techniques. 
• Analyze data, draw conclusions from analysis, explain significance of trends, describe policy/performance implications, recommend actions/interventions and future studies. Share findings with internal and external stakeholders. Ensure stakeholders understand data meanings and limitations.
• Manage analysis projects to improve data quality and access. Work with and lead cross-functional teams, develop project plans, schedule team meetings, assign tasks, report project progress, revise plan to meet project objectives. Provide technical expertise and specialized information for groups using program data or researching similar topics.
• Gather and prepare program data for external data requests. Use knowledge of systems and problem-solving skills to find and extract data and meaningfully join them with data from other systems. Produce quality reports using principles of data visualization. 
• Ensure data quality. Develop and document standards and protocols for gathering, analyzing, reporting, and sharing data. Write help documentation. Maintain documentation of what data GME can report on and when. As needed, train users on standards and protocols. Recommend policy changes. Document and report unit and user technology requirements and work with others to find solutions for unmet requirements. 
• Engage in continued education regarding new data tools, techniques, best practices, OHSU policies, and national standards. 
• Other duties as necessary and assigned. 

Required Qualifications

• Bachelors degree in a business field and one year of experience that included analytical, database, spreadsheet and/or financial experience, technical writing, quantitative analysis or use of statistical principles; OR
• Associates degree in a business field plus three years of experience that included analytical, database, spreadsheet and/or financial experience, technical writing, quantitative analysis or use of statistical principles; OR
• Five years of experience that included analytical, database, spreadsheet and/or financial experience, technical writing, quantitative or qualitative analysis or use of statistical principles; OR
• An equivalent combination of education, training and/or experience.
• Three years of experience administering or coordinating all or parts of a project or program.
• Three years of experience with data collection, analysis, and management.
• One year of experience in research or program evaluation.
• One year of experience in data visualization, report design, and dashboard creation.
• One year of experience with survey development, administration, and analysis.
• Ability to work independently.
• Excellent higher-order critical thinking, written communication and problem solving skills, ability to manage multiple projects and priorities and meet deadlines with minimal supervision.
• Demonstrated record of reliable attendance, punctuality and proven successful performance at past and present employers.
• Proficient using Microsoft Excel.
• Experience in R, Python, or similar programming language.
• Experience using Tableau, PowerBI, or similar software, especially for data visualization and dashboarding.
• Ability to perform the job duties with or without accommodation.

Preferred Qualifications

• Bachelor's or Master's degree in data science, computer science, public health, health sciences, business administration, higher education administration, science economics or other related field.
• Knowledge of medical education, including funding, Medicare/Medicaid, ACGME-accredited training programs, ERAS and NRMP recruitment systems.
• Knowledge of electronic health records (EHRs). Experience with Epic, SAP Business Objects, and Cognos.
• Experience with natural language processing, sentiment analysis, and text classification/ topic modeling.
• Experience with human subject research, including familiarity with the institutional review board (IRB).
• Experience with survey development, collection, and analysis in Qualtrics or Microsoft Forms. 
• Familiar with geocoding and use of API keys.
• Experience using Smartsheet.
• Experience creating and maintaining databases in Microsoft Access or other relational database systems. 

Additional Details
Office setting both on campus and teleworking (Hybrid); flexible working hours between 7:30am 5:00pm Monday through Friday. May be required to work outside of the standard working hours with advance notice. Must be able to multitask in a fast-paced work environment.
All are welcome
Oregon Health & Science University values a diverse and culturally competent workforce. We are proud of our commitment to being an equal opportunity, affirmative action organization that does not discriminate against applicants on the basis of any protected class status, including disability status and protected veteran status. Individuals with diverse backgrounds and those who promote diversity and a culture of inclusion are encouraged to apply. To request reasonable accommodation contact the Affirmative Action and Equal Opportunity Department at 503-494-5148 or aaeo@ohsu.edu.

PI280654592