Data Analytics Associate - Medicine (Hybrid)

Summary

The Data Analytics Associate supports the Department of Medicine’s data analytics and decision-support function through the ongoing maintenance, validation, and production of departmental datasets, databases, dashboards, and standard reports. The role uses coding, querying, and data visualization tools to extract, transform, validate, and present enterprise and departmental data. The position is responsible for maintaining reliable reporting processes and data assets while supporting routine and ad hoc analytical needs across the Department.

This position will offer the flexibility of a hybrid work arrangement after an initial training period.

Job Duties

• Department Analytics Reporting (80%)
  • Maintains departmental datasets, databases, dashboards, and reporting tools supporting operational, financial, clinical, research, education, and workforce reporting.
  • Extracts, transforms, integrates, and validates data from enterprise and departmental sources for reporting and analysis.
  • Produces and distributes standard recurring reports, dashboards, scorecards, and data extracts in accordance with established requirements and schedules.
  • Maintains documentation of data sources, definitions, queries, reporting logic, refresh processes, and standard procedures.
  • Supports ad hoc reporting and analysis requests using established data sources, definitions, and methodologies.

• Department Analytics Design and Development (20%)
  • Writes and maintains queries, scripts, and code used to prepare, refresh, and validate departmental data.
  • Performs data validation and reconciliation to ensure accuracy, completeness, and consistency of departmental reporting.
  • Analyzes data to identify trends, patterns, variances, and other insights supporting departmental operations and decision-making.
  • Performs other duties as assigned.

  
  

Minimum Qualifications

• Bachelor's degree.
• Two years of relevant experience.
  

Preferred Qualifications

• Master's degree in Finance or MBA preferred.
• Experience in financial analysis, budgeting, or long term planning.
• Experience with financial models.
• Experience in an academic medical center, medical school, hospital, or other academic/healthcare environment.
• Proficiency with financial/ERP systems and advanced Excel skills.
• High degree of flexibility, the ability to work independently, and professional communication skills.