*University of Colorado Denver l Anschutz Medical Campus
Office of Information Technology*
Billing and Budget Analyst
Position #00003296 – Requisition 16930
Applications are accepted electronically ONLY at www.cu.edu/cu-careers
The Office of Information Technology has an opening for a full-time University Staff (unclassified) Billing and Budget Analyst position.
The University of Colorado Denver | Anschutz Medical Campus is a public research university serving more than 18,000 students. We award nearly 4,000 degrees each year, including more graduate and professional degrees than any other Colorado institution. With our solid academic reputation, award-winning faculty and renowned researchers, we offer more than 140 highly rated degree programs through 13 schools and colleges. The university receives over $400 million in research awards each year. In addition to the wide array of health-related programs and facilities offered at CU Anschutz in Aurora, Colo. a significant number of undergraduate and graduate degree programs are taught at CU Denver, our comprehensive campus in the heart of downtown Denver—one of America’s most vibrant urban centers. CU Denver is located steps from the Denver Center for Performing Arts and the LoDo District affording our students, faculty and staff access to a broad array of academic, professional, community, recreational and cultural outlets.
The Office of Information Technology works to advance the University mission by providing innovative technology solutions and services to the CU Denver | Anschutz Medical Campuses, their constituents and partners.
Through our six core values, Service, Professionalism, Leadership, Innovation, Community, and Excellence (SPLICE), we make a difference.
Click here to find out more about the Office of Information Technology
The University of Colorado Denver and Anschutz Medical Campus Office of Information Technology (OIT), OIT Finance and Administration division is seeking a full-time Billing and Budget Analyst position responsible for general business operations within the department, including performing functions associated with the monthly billing process for all billed services that OIT offers as well as assisting in the preparation of the annual budget for the department. This position will be responsible for the monthly upload of all billed revenue in OIT using an automated billing system. In addition, this position participates in the strategy, planning, deployment and operational management of information systems, policies, and procedures that support the departmental billing system. The position is involved in gather data, projecting forecasts of rates, revenue and expenses in support of the annual OIT budget. This position will serve as a resource to the OIT Director of Finance and Administration and work fully independently.
*_Examples of Work Performed:
The Billing and Budget Analyst’s role will be to participate in the monthly billing process and support process improvement for OIT users in the billing system and other systems in order to achieve an accurate and comprehensive monthly upload to the university’s general ledger. This position supports the annual budgeting process in OIT by gathering data, researching financial records and combining these into usable documents to identify budget needs for each fiscal year.
/Billing System Analysis/
Develop queries for OIT billing system as well as other non-integrated systems
Execute and perform queries of information in departmental billing system, PeopleSoft Finance, and departmental ticketing system.
Assist in providing billing system process expertise and assistance to other billing system users throughout OIT including backup responsibilities for the senior billing analyst.
Create and maintain documentation of existing billing process; make recommendations for improvements and/or alternatives.
/Monthly Billing Process for OIT/
Act as the back-up for monthly billing process for all billable services in OIT, including voice connections, long distance, central file servers, pagers, and other billed services. These billed amounts range between $400K and $1M monthly.
Perform reconciliations as part of the monthly billing process, ensuring that billed amounts match with general ledger upload amounts.
Ensure accuracy of accounting codes in billing system.
Review work orders which create, modify or delete services billing by the Pinnacle billing system.
Import files into OIT billing system as part of the pre-billing process
Manage the process for maintenance of billing records in Pinnacle for OIT customers. Ensure that all customer records have documented notations which allow for auditability of records
Provide training and process audits for all staff performing billing changes in Pinnacle.
Manage all accounts receivables for the Office of Information Technology for services provided to outside entities
Create journal entries associated with recording departmental accounts receivables
Manage and monitor invoicing process for the Office of Information Technology, using accounting software
Perform periodic audits of customer data billed through monthly billing process
Reconcile errors in customer statement and make corrections through journal entries or other uploads to the PeopleSoft Financial system.
/Budget Analysis Duties/
Uses financial and billing data to provide forecasting and projections of revenues and budgets, rates and cash flow for the department
Assists in the generation of annual service center cost studies for the department.
Assists in responses to requests for information from departmental management for reports and other information needed to understand financial reports
Assist in the development of reports, schedules, graphs and reports necessary for providing insights into the department’s annual budget and expenses
Uses financial and other data to assist in the creation of metrics and publishing of dashboards
This description is a summary only and is describing the general level of work being performed, it is not intended to be all-inclusive. The duties of this position may change from time to time and/or based on business need. We reserve the right to add or delete duties and responsibilities at the discretion of the supervisor and/or hiring authority.
PLEASE NOTE: Candidates will be responsible for travel expenses related to the interview process and any relocation expenses, if applicable.
*Salary and Benefits:
The salary for this position has been established at $45,000 to $57,000 and is commensurate with skills and experience.
The University of Colorado offers a full benefits package. Information on University benefits programs, including eligibility, is located at https://www.cu.edu/employee-services.
o Substitution: 4 years of work-related experience in the areas listed above may be substituted for the bachelor’s degree. The other minimum requirements listed below can overlap with this experience.
o Completion of 12 credit hours of post-secondary education in Accounting (please attach/submit a copy of unofficial transcripts), OR:
o Three years of progressively responsible billing system, finance or budget related experience
_Conditions of Employment:_
Experience with creating MS Access queries, running MS Access reports and troubleshooting MS Access macros
Experience which provides a familiarity with higher education accounting processes and procedures
Experience which provides an understanding of relational database concepts and queries
Experience which provides a basic knowledge of SQL
Experience which provides a familiarity with the ETL process involved in data transfers
One year of experience with database management applications (such as MS Access, MySQL, MS SQL Server or other database management applications)
_Knowledge, Skills, and Abilities_
Knowledge of generally accepted accounting principles in support of business administration processes
Ability to respond quickly and efficiently to issues
Familiar with MS Access database elements
Strong technical aptitude and ability to research & solve complex issues independently
Possess proven ability to multi-task
Ability to meet multiple deadlines and manage interrelated and/or complex issues or transactions
Strong interpersonal communication and customer service skills working with all levels of an organization including leadership, management and line staff employees
Job: *Business Services
Organization: *U0001 -- DENVER & ANSCHUTZ MED CAMPUS
Title: Billing and Budget Analyst
Requisition ID: 16968