Columbia University Director of Business Planning and Analysis in New York, New York

Job TitleDirector of Business Planning and Analysis

Job Code Title

Job Requisition Number 096167

Department 7538- PAT Pathology

Location Medical Center

Job Type Officer Full-Time Regular

Bargaining Unit

If temporary, indicate duration

Hours Per Week 35

Job Family General Administration

Salary Grade Officer 106

Salary Range

Advertised Summary Job Description Reporting to the Departmental Administrator/CFO, working closely with the Director of Budget and Finance and in coordination with all laboratory divisions, the Director of Financial Planning and Analysis will provide analytical, financial and strategic support to the Department of Pathology and Cell Biology.

Business Strategy and Planning: Assist DA/CFO and senior leadership and serve as a critical analyst on new business ventures and performance improvement initiatives. Help leadership scan the environment, identify and/or agree on opportunities or threats, and perform rigorous assessments, including cost-benefit analysis of alternative scenarios, for exploiting opportunities and mitigating business and financial risks, as well as develop detailed and feasible business plans in collaboration with divisions. Research key related business issues and incorporate findings into complex financial models that provide a three to five- year projection for how financial performance would change at various levels (business unit, division, and department) based on the introduction of strategies and plans. Prepare materials to communicate the details of financial projections to senior leadership.

Presentation and Analysis: Prepare briefing books, presentations, and other materials used to advise department senior leadership on the financial risks and opportunities of business ventures and business performance improvement initiatives under evaluation. Utilize appropriate methodologies as needed including strategic planning and analysis techniques, business process reengineering, financial modeling (pro forma operating results and P&L projections), productivity analysis (e.g., Work Value Units), change management, and project management. For business performance improvement initiatives, gathering information on best practices from external sources as needed.

Implementation Support and Administration: For new ventures and initiatives which are approved, help DA/CFO and operating units support business launch and assist in the monitoring of financial activity. Assist with establishing governance for authorized projects, preparing meeting materials if needed, running meetings, developing plans in collaboration with partners, and identifying and tracking issues impacting progress on plans. Maintain overall scorecard on the status of portfolio of projects underway.

Collaborate and Lead: Provide support for selected projects, interacting as needed with various University and affiliated hospital administrative offices. Facilitate data sharing and communication, help resolve outstanding issues, and prepare recommendations as needed. Engage with finance and other staff in schools and departments as needed and lead teams or work groups as directed by DA/CFO.

Compliance Oversight: Responsible for compliance with University, state and federal regulatory requirements. Have working knowledge of regulatory compliance and make sure department is following all rules as required (federal payors, OSHA, STARK, HIPAA, OIG, Red Flag Rules, etc.). Will oversee internal and external audit reviews.

Minimum Qualifications for Grade

Applicant MUST meet these minimum qualifications to be considered an applicant Requires a bachelor's degree preferably in finance or other quantitative field or equivalent in education and experience, as well as five years of progressively comprehensive analytical, planning, and/or decision support responsibility in a large, complex organization.

Excellent oral/written communication, professional, interpersonal, organizational, and analytical skills. Highly proficient computer skills, with emphasis on Excel, required to create and maintain complex financial models that employ a large number of variables; analytically summarize results of various computer models; understanding of fund accounting. Demonstrated ability to work with business users to gather necessary data as well as proven success manipulating, transferring and interpreting big data through the use of spreadsheets or complex systems. Strong working knowledge of financial systems. Ability to manage projects independently and under deadline pressure. Extreme attention to detail, plus the ability to work closely with a diverse group of senior administrators is essential.

Additional Position-Specific Minimum Qualifications

Applicant MUST meet these minimum qualifications to be considered an applicant

Special Instructions

Preferred Qualifications Master's Degree in Business Administration, Finance or related field.

Knowledge of medical billing.

Essential Functions 1. Create financial reports that enable the department to analyze clinical revenue, evaluate lab test profitability, and identify financial results and trends by clinical service.

  1. Utilize appropriate methodologies as needed including strategic planning and analysis techniques, business process reengineering, financial modeling (pro forma operating results and P&L projections), productivity analysis (e.g. work value units), change management, and project management.

  2. Conduct analysis of financial transactions between Columbia University and affiliates (e.g. NYP, University partners, etc.)

  3. Partners with the DA/CFO and divisions in the development and evaluation of business plans for new laboratory programs intended to expand or enhance laboratory services.

  4. Support the analytic needs of Pathology Administration especially in the areas of volume growth, expense reduction, and increased operational efficiency.

  5. Analyze financial results of different business units and the overall financial position of the department. Apply business requirements experience to ensure quality reporting are delivered and will cover departmental needs.

  6. Utilize RVU and other volume measurements to develop trends analyses. Identify areas of needed improvements and make recommendations.

  7. Determines most efficient and cost-effective means for gathering and analyzing data needed to support departmental goals and achieve growth through the accomplishment of long-range goals and objectives.

  8. Assist with the development of business plans to support justification of new business opportunities, potential expansion of clinical services, and inter-departmental joint programs and initiatives.

  9. Track all funding arrangements made with NYP and other departments for recruitments and jointly funded programs.

  10. Assist Director of Budget and Finance in developing various departmental financial reports for budgetary and reporting purposes.

  11. Assist in the preparation of ad-hoc clinical reports as required to evaluate departmental business needs.

  12. Participates in Epic software implementation and training to ensure the departmental skill and expertise in financial reporting, data extraction, and analysis.

  13. Performs comprehensive quality assurance, ensuring that database and reports meet end-user specifications and data are accurate and reliable.

  14. Perform data cleansing and data entry tasks as necessary to support data analysis and reporting.

  15. Develop, monitor, maintain and publish dashboards as needed for trended identification and patterns for management decision making.

  16. Work on special projects routinely.

  17. Perform other duties as assigned.

Additional Essential Functions (Limit to 3950 characters.)

Special Indications

This position works with:

HIPAA Compliance training required Yes

Participation in Medical Surveillance required No

What type of posting? Is this a waiver request? Standard Posting

Requisition Open Date 12-28-2018

Requisition Close Date Open Until Filled

Quick Link jobs.columbia.edu/applicants/Central?quickFind=173850

EEO Statement Columbia University is an Equal Opportunity/Affirmative Action employer --Race/Gender/Disability/Veteran.

Local Hiring Columbia University is committed to the hiring of qualified local residents.

This organization is a federal contractor subject to the Vietnam Era Veterans' Readjustment Assistance Act of 1974, as amended by the Jobs for Veterans Act of 2002, 38 U.S.C. 4212 (VEVRAA). The final rules now require contractors and subcontractors to invite applicants to self-identify as protected veterans or individuals with disabilities.

You can update your demographic information by logging in and clicking on "EDIT APPLICATION".

The information is being requested on a voluntary basis, and will be kept confidential. Refusal to provide this information will not subject the applicant to any adverse treatment, and will not be used in a manner inconsistent with the act.