Description
Department Description

The Procurement Service Center (PSC) provides leadership to the University of Colorado in the procurement of goods and services and in paying debts to vendors and travelers by combining sound business controls with efficient and timely service. The functional areas of the PSC include Purchasing Services, Strategic Sourcing, Supplier Relationship Management, Payable Services, Commercial Card Program, Travel Program, Small Business Program, Contract Services, and Procurement Systems. PSC is the system owner of CU Marketplace and Concur Travel and Expense.

Position Description

The University of Colorado is an internationally known public research university serving Colorado, the nation and the world through leadership in high quality and professional training, public service, advancing research and knowledge, and state-of-the-art health care. The University of Colorado's (CU) Procurement Service Center (PSC) is a nationally recognized procurement office dedicated to using technology to enhance the University's programs and create efficiencies within policies system wide.  The PSC supports the entire CU community, which includes four campuses plus system administration. 

The BI Analyst provides meaningful and actionable data analytics, reporting, and business intelligence regarding the University’s procurement activities. This position is part of the Business Intelligence team that supports the procurement data needs across the University, including monthly performance reports, ad-hoc reporting, and metrics reporting. This position works with University clients to fully understand their data needs and provide recommendations and solutions. This position provides business intelligence to assist in effective procurement decision making, internal workflow and process optimization, and data management. 

The BI Analyst will report to the Director of Procurement Operations and Shared Services and is exempt from the State of Colorado Classified Staff System.

COVID-19
The University of Colorado has a requirement for COVID-19 vaccinations and full completion of the attestation form within the first 30 days after hire date.  Information regarding this requirement, and exemptions can be found at https://www.cu.edu/vaccine-requirement

Duties and Responsibilities

Duties and responsibilities of the position include, but are not limited to: 

Data Transformation and Operational Reporting

• Ensure data storage and data flow mapping are efficiently and effectively managed to allow a high degree of automation of reporting, data presentation formats, and analytics.
• Develop, maintain, and optimize data cleansing protocols for the PSC and applicable data.
• Query data from multiple internal and external sources to support routine and ad hoc analytics and reporting needs.
• Field ad hoc reporting requests from across the entire University, clarify the business need of the request, and provide business intelligence regarding the reporting.
• Evaluate and troubleshoot information gathered from multiple sources and reconcile any discrepancies to ensure consistency of reporting procurement data.
• Document all PSC reporting processes.

Business Intelligence Tool Development and Solutions:

• Develop and maintain data visualization and analytics tools.
• Identify opportunities to enhance tools based on internal and external stakeholder input.
• Assist in the development of project plans, business requirements, and business cases for PSC projects and initiatives.
• Communicate findings and results to stakeholders and project members

Cross Functional Collaboration, Communications, Support and Training:

• Assist team members and clients with timely problem reporting and resolution.
• Maintain appropriate follow-up communications and manage expectations effectively.
• Provide support for end users of legacy reports as well as business intelligence tools.
• Assist in the development of end-user training materials as needed.
• Assist team members and clients with timely problem reporting and resolution.
• Document all PSC reporting processes.

Who we are and What we offer

Who we are: System Administration, which also houses the Office of the President, is located in the uptown neighborhood of Denver with a few smaller offices located on the campuses. This position has the ability to work 100% remotely, and it is also approved for a hyrbid working arrangement. Many of our departments support the educational and research missions of the four University of Colorado campuses, but System Administration is not considered a campus. We provide diverse opportunities for professional development, innovation, and collaboration with talented staff and faculty.  Learn more about CU System Administration.

What we offer:

Salary: The anticipated hiring range has been established at $75,000-$77,800.

The salary of the finalist(s) selected for this role will be set based on a variety of factors, including but not limited to, internal equity, experience, education, specialty and training.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.

Benefits: The University of Colorado offers an excellent benefits package including:

• Medical: Multiple plan options
• Dental: Multiple plan options
• Additional Insurance: Disability, Life, Vision and Wellness
• Retirement 401(a) Plan: Employer contributes 10% of your gross pay
• Paid Time Off: Accruals over the year
  • Vacation Days: 22
  • Sick Days: 15
  • Holiday Days: 10
• Tuition Benefit: System employees have the benefit on all campuses 
• ECO Pass: RTD Bus and light rail service
• Additional Perks & Programs: Click here to access a few more Perks and Programs

Click here to access our Total Compensation Calculator to see what your total rewards could be at CU. This position is a University Staff position.

Additional taxable fringe benefits may be available.

More information on benefits programs, including eligibility, is available at www.cu.edu/employee-services/.

Knowledge, Skills, and Abilities:

To be successful in this position, candidates will need the following:

• Knowledge of data management and analysis best practices.
• Knowledge of project management best practices.
• Skilled in business intelligence analytics and the use of complex computer programs to mine data sources and identify data trends.
• Ability to track, understand, and communicate recommendations based on data trend analysis to all stakeholders.
• Ability to communicate research, analytics, and recommendations to stakeholders.
• Ability to support multiple projects, work with numerous data sources, and work within critical deadlines.
• Office suite of products.
• Exceptional time-management, customer service, and written/verbal communication skills.

Qualifications
Minimum Qualifications:

Please ensure your resume includes any and all relevant experience to be accurately assessed against these qualifications.  You must meet all minimum requirements listed at the time of application to be considered for this role.

• Bachelor’s degree from an accredited institution of higher education or equivalent professional experience.  (The educational requirement may be substituted by professional experience on a year for year basis).   
• Three (3) years’ experience with data analytics, business intelligence and database management.

Preferred Qualifications:

• Five (5) years experience, as stated above.
• Experience managing large datasets from multiple sources, and synthesizing datasets into usable formats
• Experience with Cognos, Tableau, or other data visualization tools.
• Experience in Higher Education
• Experience working in a procurement organization
• Experience managing large datasets from multiple sources, and synthesizing datasets into usable formats
• Experience using SQL

Job Category: Information Technology
Primary Location: Denver
Schedule: Full-time
Posting Date: Jun 14, 2022
Unposting Date: Ongoing