Administrative Operations Analyst: Data-Driven HR & Finance

Columbia University; Northern, New York (KY, NY); Hybrid; USD 66,000 - 75,000; Full time

Job summary

Columbia University in Kentucky is seeking an Administrative Operations Analyst to support operational, financial, and personnel management functions in the Hematology and Oncology division. The role emphasizes data analysis, reporting, and process improvement in a fast-paced academic healthcare environment.

The ideal candidate will manage faculty and staff life-cycle processes, ensure compliance, and generate dashboards and reports for divisional leadership.

Qualifications

• Bachelor's degree or equivalent combination of education and experience.
• Proficiency in Microsoft Excel, including pivot tables, VLOOKUPs/XLOOKUPs, filtering, sorting, and basic data analysis.
• Strong analytical, organizational, and problem-solving skills.
• Excellent written and verbal communication skills.
• Demonstrated attention to detail and ability to maintain confidentiality.
• Ability to manage multiple projects and priorities simultaneously.

Responsibilities

• Serve as liaison with Medicine Pod HR/FA team to facilitate recruitment, onboarding, appointments, and related personnel activities.
• Initiate and track requests for new hires, replacements and promotions in the Columbia HRCULES platform.
• Maintain oversight of clinical faculty appointments, credentialing, certifications, professional licenses, delineation of privileges, and malpractice roster reviews.
• Coordinate visa and immigration-related document tracking and renewal processes for eligible staff.
• Monitor compliance-related requirements and proactively address credentialing or documentation gaps.
• Generate and maintain reports related to staffing, vacancies, appointments, and personnel actions.
• Ensure compliance with institutional policies and applicable regulatory requirements.
• Conduct ad hoc analyses related to divisional operations, finances, research administration, and workforce planning.
• Collect, validate, and analyze data from multiple sources to support operational decision-making.
• Develop recurring and one-time reports, dashboards, and summaries for divisional leadership.
• Assist with budget monitoring, productivity tracking, and operational performance analyses.
• Identify trends, discrepancies, and opportunities for process improvement.
• Support special projects and strategic initiatives as assigned.
• Prepare presentations, reports, and supporting documentation for leadership meetings.

Skills

Microsoft Excel

Analytical thinking

Communication

Confidentiality

Project management

Education

Bachelor's degree or equivalent

Tools

HRCULES platform

Pivot tables

VLOOKUPs/XLOOKUPs

Job description

Columbia University in Kentucky is seeking an Administrative Operations Analyst to support operational, financial, and personnel management functions in the Hematology and Oncology division. The role emphasizes data analysis, reporting, and process improvement in a fast-paced academic healthcare environment.

The ideal candidate will manage faculty and staff life-cycle processes, ensure compliance, and generate dashboards and reports for divisional leadership.