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