"Finance & Business Intelligence Analyst"

Finance & Business Intelligence Analyst

Department: Colorado Center for Personalized Medicine

Position #: 00843811 - Requisition #: 38611

Job Summary:

The Financial & Business Intelligence Analyst supports the Colorado Center for Personalized Medicine by driving financial operations and strategic reporting. This role combines advanced financial analysis with business intelligence, developing Power BI dashboards to improve transparency and decision-making. Key responsibilities include managing budgets and funding distributions, overseeing revenue cycle activities, supporting new initiatives, and preparing financial reports for internal and external partners. The analyst will also manage tuition revenue for academic programs and collaborate across campus units and hospital partners to ensure accurate reporting and compliance.

Key Responsibilities:

• Prepare monthly budget reconciliations and reports using A2E, CU-Data, and other systems.
• Build and maintain custom financial reporting tools and dashboards for faculty and staff.
• Develop and implement Power BI dashboards to improve financial and business reporting.
• Run monthly budget meetings, present financial reports, identify trends, and make recommendations.
• Develop annual budgets for State, Auxiliary, gift accounts, and other fund types.
• Launch and manage revenue cycle activities for payer billing, ensuring accuracy and compliance.
• Develop and lead financial reporting for new projects, including the organoid initiative.
• Manage tuition revenue for graduate certificate and degree programs, including forecasting and reconciliation.
• Prepare and process Journal Entries (JEs), Payroll Expense Transfers (PETs), and funding updates.
• Maintain personnel funding forecasts and improve executive reporting transparency.
• Manage funding distributions for staff and faculty across multiple funding sources.
• Liaise with partners in schools, departments, and units across campus regarding shared staff and financial interests.
• Prepare and manage monthly financial reports for hospital partners, including explanations of cost-to-budget variations.
• Partner with directors on service center activities, including cost studies, invoicing, and compliance.
• Create and maintain a central database for tracking revenue and expense agreements.
• Provide guidance to staff on purchasing and procurement activities, ensuring appropriate use of funding sources and compliance with university policies and restrictions.
• Write and maintain standard operating procedures for financial and procurement activities; train staff and faculty.

Work Location:

Hybrid - this role is eligible for a hybrid schedule of 3 days per week on campus and as needed for in-person meetings.

Why Join Us:

Join our dynamic team at the Colorado Center for Personalized Medicine (CCPM) at the University of Colorado Anschutz Medical Campus, where we are at the forefront of integrating genetic information to enhance patient care. CCPM is committed to leveraging the unique combination of genetic information derived from its CAP/CLIA biobank lab, and comprehensive electronic health records to improve healthcare outcomes.

Why work for the University?

We have AMAZING benefits and offer exceptional amounts of holiday, vacation and sick leave! The University of Colorado offers an excellent benefits package including:

• Medical: Multiple plan options
• Dental: Multiple plan options
• Additional Insurance: Disability, Life, Vision
• Retirement 401(a) Plan: Employer contributes 10% of your gross pay
• Paid Time Off: Accruals over the year
• Vacation Days: 22/year (maximum accrual 352 hours)
• Sick Days: 15/year (unlimited maximum accrual)
• Holiday Days: 10/year
• Tuition Benefit: Employees have access to this benefit on all CU campuses
• ECO Pass: Reduced rate RTD Bus and light rail service

There are many additional perks & programs with the CU Advantage.

Qualifications:

Minimum Qualifications:

• Bachelor's degree in Finance, Accounting, Business Administration, or related field.
• 3-5 years of experience in financial analysis, budgeting, and reporting in a complex organization.
• Experience with business intelligence tools and data visualization.

Applicants must meet minimum qualifications at the time of hire.

Preferred Qualifications:

• Prior experience at an academic medical center.
• Experience managing tuition revenue or similar educational program finances.

Knowledge, Skills and Abilities:

• Familiarity with revenue cycle management and payer billing processes.
• Proficiency in Power BI, Excel (advanced), and financial systems such as A2E and CU-Data.
• Strong understanding of accounting principles and university financial policies.
• Ability to develop automated dashboards and integrate data from multiple sources.
• Excellent analytical, problem-solving, and organizational skills.
• Strong communication and presentation abilities for diverse audiences.
• Ability to work independently and collaboratively in a fast-paced environment.

How to Apply:

For full consideration, please submit the following document(s):

1. A letter of interest describing relevant job experiences as they relate to listed job qualifications and interest in the position
2. Curriculum vitae / Resume
3. Three to five professional references, including name, address, phone number (mobile number if appropriate), and email address

Questions should be directed to: Emily Casteel, emily.casteel@cuanschutz.edu

Screening of Applications Begins: Immediately and continues until position is filled. For best consideration, please apply by March 5, 2025.

Anticipated Pay Range:

The starting salary range (or hiring range) for this position has been established as HIRING RANGE $60,005 - $76,326

The above salary range (or hiring range) represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting. This position may be eligible for overtime compensation, depending on the level.

Your total compensation goes beyond the number on your paycheck. The University of Colorado provides generous leave, health plans and retirement contributions that add to your bottom line.

Total Compensation Calculator