BI Analyst

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.  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 . 

Position Summary:

The Business Intelligence (BI) Analyst is a member of the Business Intelligence unit at the University of Colorado’s (CU) Central Advancement Office. This position contributes to the team’s transformative impact by lending strategic insight and keen analysis to Advancement’s operations across the University of Colorado System. This position supports all four campuses, the President’s Office, central Advancement, and the CU Foundation, through targeted reporting, technical administration, and campus partner success. The BI Analyst responds to requests submitted through the centralized report/data queue and aids ongoing projects by working closely with clients and information technology (IT) teams to transform data into critical information and knowledge that can be used to make informed business decisions. The BI Analyst is tasked with maintaining, improving, and crafting enterprise- and application-level reports using Business Intelligence tools, enabling sophisticated analytic tools support for partners across the university, and supporting a reporting community of practice requiring a balance of technical, customer service, and project management skills. Successful candidates have had success in inspiring change across a distributed system. 

This position reports to the Associate Director of Business Intelligence & Data Architecture and is exempt from the State of Colorado Classified Staff System.  

Where You Will Work:

The CU System Office of Advancement follows a “flexibility first” approach to work that defines how we manage and make use of in-person time. As a fully remote position, this role will work remotely with the exception of four separate callback weeks per year— when all our colleagues are expected to be together in the office. During callback weeks, this role is expected to work from the CU System office at 1800 Grant St. in Denver, Colorado. Any additional in-office time will be determined by the manager. 

Diversity and Equity:

The University of Colorado System Administration Office is committed to recruiting and supporting a diverse workforce. The university strives to promote a culture of inclusiveness, respect, communication and understanding. We encourage applications from women, ethnic minorities, persons with disabilities, persons within the LGBTQ+ community and all veterans.

Duties & Responsibilities:

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

Data Analysis & Report Development

• Translates business requirements into specifications used to drive a data mart/data model design and configuration
• Develops and maintains documentation of standard and customized report requirements (e.g. statements of work, roadmaps, and mock-ups)
• Creates, monitors, analyzes, tests, and corrects reports. Identifies, proposes, and implements processes for improving reliability and efficiency in an evolving reporting environment
• Assists with ad hoc reporting and data analysis projects as needed
• Assists with environment upgrades and migrations as needed
• Actively participates as a member of the team in project initiatives and decision-making opportunities

Project Management

• Conducts technical feasibility for projects, working multi-functionally as needed
• Works with Central Advancement leadership and partners to manage and complete projects for the Advancement Data Council and Advancement System Work Plans
• Crafts and maintains project management documentation, including standard project summaries and goal timelines
• Assists enterprise reporting readiness by building, developing, and deploying solutions within the BI platform
• Collaborates with Central Advancement teams on initiatives related to enterprise reporting, sophisticated analysis, and ad hoc reporting
• Uses Agile project management methodologies to help ensure timely, quality work

Partner Success

• Engages with campus, foundation, and central partners and build collaborative working relationships
• Consults with clients to determine specifications for data requests, project design, and reporting needs
• Works closely with clients to craft, test, build, and implement new reporting/dashboard solutions including sophisticated reports with drill-down, drill-through, and parameterized functionality
• Collaborates with clients to translate reports into actionable objectives and work
• Provides technical assistance and cross training of end users and technical support staff in use of internal and external reporting technologies

Professional Development & Training

• Engages in technical training and professional development opportunities to maintain innovative industry skills and deepen business knowledge
• Participates in presentations, trainings, and workshop sessions related to platform/application navigation and configuration

What We Offer:

Salary: The anticipated hiring range has been established at $78,000-$82,000.

CU System Administration takes into consideration a combination of the selected candidate’s education, training and experience as it relates to the position, as well as the position’s scope and complexity, internal pay equity and external market value when determining a salary level for potential new employees.

Benefits: With our unparalleled range of benefits, including top-notch healthcare, comprehensive wellness programs, enriching professional development, and a dynamic work-life balance, we ensure your holistic growth and happiness.

• No-cost or low-cost medical & dental plan options, some inclusive of IVF assistance.
• Disability, Life, Vision Insurance options.
• Multiple retirement planning options including a mandatory 401(a) plan where CU contributes 10% of your gross pay, a 401k or 403b plan and a 457 deferred compensation plan.
• Pre-tax savings plans, such as Health care and Dependent care flexible spending accounts.
• Embrace a healthy work-life balance with ample sick and vacation leave, along with at least 12 paid holidays. This includes a dedicated week off for winter break.
• 4 weeks of parental leave to adjust to the joys of parenthood.
• Tuition Benefit of 9 waived credits for eligible courses on any CU campus per academic year for employees, as well as options for your dependents.
• Free RTD EcoPass and Free Onsite Parking at our 1800 Grant Street Office.
• Many additional perks & programs with the CU Advantage .

Additional taxable fringe benefits may be available. 

For more information on benefits programs, please review our Comprehensive Benefits Guide . 

Access our Total Compensation Calculator to see what your total rewards could be at CU.  (This position is a University Staff position)

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 with professional experience on a year-for-year basis)
• Two (2) years’ experience using BI reporting tools to develop, maintain, and update business intelligence reports

Preferred Qualifications:

•  Bachelor’s degree in Business, Analytics, Decision Sciences, Statistics, Information Systems, or related field.
• Experience in the following:
  • Analytic Applications to develop, maintain, and update business intelligence reports
  • Work in a higher-education, healthcare, non-profit, and/or advancement setting
  • Customer relationship management (CRM) software, particularly Salesforce or other higher education constituent database software
  • Development programming languages (such as Java, JavaScript, Python, Salesforce Apex etc.)
  • Relational databases in an Oracle client/server environment
  • SQL and writing queries against sophisticated database structures
  • Logical and physical data modeling concepts
  • Cognos or other common standard BI tools

Knowledge, Skills, and Abilities:

• Knowledge of business intelligence principles and standard processes, including data management and reporting processes
• Knowledge of logical and physical data modeling concepts
• Knowledge of Web Development programming languages (such as Java, JavaScript, jQuery, PHP, aspx, etc.)
• Interpersonal skills, including the ability to facilitate interaction, communication, and teamwork between others
• Oral, written, and listening communication skills , including the ability to accurately interpret what others are saying and convey messages, information, concepts, and details clearly
• Analytical, logical, and problem-solving skills, including the ability to analyze data and trends in order to produce results
• Ability to apply or proven skills to learning the following:

• • • Microsoft Office Suite
    • SQL/SOQL Query Tools
    • Salesforce ascend applications, or similar
    • Salesforce reports and dashboards
    • Cognos, Tableau, or similar BI tools
    • ETL tools

• Ability to work independently and multi-functionally to meet personal and team goals
• Ability to provide technical assistance to customers, including the ability to convey technical information to non-technical users in accessible terms
• Ability to maintain confidentiality of information
• Ability to manage multiple concurrent projects, follow-up with partners, meet goals, and bring projects to completion
• Ability to quickly learn new technologies and their application environment

How to Apply:

For full consideration, please attach the following as separate documents to your application:

1.      A cover letter identifying the job specific minimum qualifications you possess

2.      A resume including any and all relevant experience to be accurately assessed against the qualifications listed in the posting.

Please ensure you check the “Job Specific Attachments” box next to each document on the “Required Documents” page of the application for the appropriate documents to be attached. 

When to Apply:

For full consideration completed applications must be submitted by April 10th.  Reference checking is a standard step in our hiring process. You may be asked to provide contact information, including email addresses, for up to five references as part of the search process for this position. *Please note: All application materials must be submitted through CU Careers; emailed materials will not be considered.*

Sponsorship Statement:

We are unable to sponsor applicants for work visas for this position.

Background Check Statement:

The University of Colorado is committed to providing a safe and productive learning and living community. To achieve that goal, we conduct background investigations for all final applicants being considered for employment. Background investigations include a criminal history record check, and when appropriate, a financial and/or motor vehicle history. The Immigration Reform and Control Act requires that a verification of employment eligibility be documented for all new employees by the end of the third day of work. The University of Colorado is committed to diversity and equality in education and employment.

ADA Statement:

We are committed to an inclusive and barrier-free search process. We provide accommodations for applicants requesting accommodation through the search process such as alternative formats of this posting.  Individuals with disabilities in need of accommodations throughout the search process should contact the ADA Coordinator at: [email protected] .