University of Colorado Anschutz Medical Campus

Department: Emergency Medicine

Job Title: Business Intelligence Developer – Financial Analyst

Position #: 00843043 – Requisition #: 39354

Job Summary:

The University of Colorado Anschutz Medical Campus is seeking applications for a Financial Analyst and Business Intelligence (BI) Developer (Finance and Accounting Principal Professional). This full-time, University Staff (non-classified) position will be responsible for providing financial activities and system analytics for the Department of Emergency Medicine. This includes providing advanced accounting, finance, and analytical support to the Department through complex financial analysis and modeling, trend analysis, and financial reporting.

The ideal candidate will have excellent skills in Microsoft SQL Server, SSMS, SSRS, SSAS, SSIS, Power BI, PowerPivot, and Excel.

The Financial Analyst will play a critical role in developing accurate, insightful financial reports by integrating data from multiple sources. This position requires strong analytical skills, proficiency in data visualization tools, and a deep understanding of financial principles. The analyst will support both detailed financial accountability and high-level strategic planning, ensuring leadership has the information needed to make informed decisions.

As a member of our Team, you will directly partner with, and contribute to, an extraordinary group of healthcare providers and leaders throughout Colorado who share a mission to improve lives and deliver the best possible care for our patients; in big ways, through learning, healing, and discovery; and in small, personal ways through human connection. In all ways, and together, we improve lives.

Key Responsibilities:

Data Integration & Reporting – 40%

• Leverages institutional databases and departmental systems to compile and analyze financial data for accurate calculation.

• Collect, consolidate, and validate financial data from diverse systems and sources.

• Develop and maintain comprehensive financial reports that support operational and strategic objectives.

Visualization & Analysis – 40%

• Build interactive dashboards and visualizations using Power BI and Smartsheet to present complex financial data in a clear, actionable format.

• Identify trends, variances, and key performance indicators to inform decision-making.

•  

Process Improvement – 10%

• Recommend and implement enhancements to reporting processes for greater efficiency and accuracy.

Collaboration – 10%

• Work closely with finance, operations, and leadership teams to ensure alignment and clarity in financial reporting.

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:

The Department of Emergency Medicine at the University of Colorado School of Medicine is dedicated to delivering superlative patient care, providing an environment where training and education thrive and innovation and discovery are fostered.

The Department of Emergency Medicine is based at the Anschutz Medical Campus in Aurora Colorado. The campus is a state of the art medical campus home to the University of Colorado Schools of Medicine, Nursing, Dentistry, Pharmacy, the Colorado School of Public Health; as well as the University of Colorado Hospital and Children's Hospital Colorado both of which serve as major training sites for the Denver Health Residency in Emergency Medicine

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 Computer Science, Computer Information Systems, Finance, Accounting, Economics or a related field from an accredited institution

• 3-5 years of experience in financial analysis, reporting, or related roles.

• A combination of education and related technical/military/paraprofessional experience may be substituted for a bachelor’s degree on a year for year basis.

Applicants must meet minimum qualifications at the time of hire.

Preferred Qualifications:

• A master’s degree in accounting, business, business analytics, finance, economics, statistics, or a directly related field from an accredited institution.

• Higher education accounting and finance experience.

• Experience working with Epic or any other Electronic Health Record.

• Experience working with Python, R or other statistical modeling tools.

• Experience working w/ Artificial Intelligence (AI) specifically Microsoft Co-pilot.

• Experience working in Visual Studio Code with version control i.e. GitHub and TFS.

Conditions of Employment:

• Please be advised that this position is not eligible now or in the future for visa sponsorship.

Knowledge, Skills and Abilities:

• Advanced proficiency in Power BI, Smartsheet and Microsoft Excel.

• Advanced proficiency knowledge of SQL, testing

• Strong understanding of financial statements, budgeting, and forecasting.

• Ability to synthesize complex data into clear, actionable insights.

• Excellent communication skills for presenting findings to both technical and non-technical audiences.

• Advanced knowledge of Microsoft Excel, sufficient to create, maintain, and update financial spreadsheets, databases, and budgets using complex formulas and functions.

• Advanced analytical abilities and skills to address significant issues and demonstrate judgment to resolve complex problems

• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.

• Ability to communicate effectively, both in writing and orally.

• Ability to establish and maintain effective working relationships with employees at all levels throughout the institution.

• Familiarity with data warehouse design and data mining, and an in-depth understanding of database management systems and online analytical processing.

• Outstanding customer service skills.

• Proven ability to take initiative and work independently.

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: Emergency Medicine Human Resources,EMED.humanresources@ucdenver.edu

Screening of Applications Begins:

Immediately and continues until position is filled.

Anticipated Pay Range:

The starting salary range (or hiring range) for this position has been established as $81,522 - $100,247

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

Equal Employment Opportunity Statement:

CU is an Equal Opportunity Employer and complies with all applicable federal, state, and local laws governing nondiscrimination in employment. We are committed to creating a workplace where all individuals are treated with respect and dignity, and we encourage individuals from all backgrounds to apply, including protected veterans and individuals with disabilities.

ADA Statement:

The University will provide reasonable accommodations to applicants with disabilities throughout the employment application process. To request an accommodation pursuant to the Americans with Disabilities Act, please contact the Human Resources ADA Coordinator at hr.adacoordinator@cuanschutz.edu​.

Background Check Statement:

The University of Colorado Anschutz Medical Campus is dedicated to ensuring a safe and secure environment for our faculty, staff, students and visitors. To assist in achieving that goal, we conduct background investigations for all prospective employees.

Vaccination Statement:

CU Anschutz strongly encourages vaccination against the COVID-19 virus and other vaccine preventable diseases. If you work, visit, or volunteer in healthcare facilities or clinics operated by our affiliated hospital or clinical partners or by CU Anschutz, you will be required to comply with the vaccination and medical surveillance policies of the facilities or clinics where you work, visit, or volunteer, respectively. In addition, if you work in certain research areas or perform certain safety sensitive job duties, you must enroll in the occupational health medical surveillance program.