Business Intelligence Analyst

Colorado; Denver (CO); Remote; USD 60,000 - 90,000; Full time

Job summary

An established industry player in higher education seeks a Business Intelligence Analyst to drive impactful data analysis and reporting. This fully remote position offers the opportunity to contribute to a dynamic team while supporting the advancement goals of multiple campuses. The ideal candidate will possess strong analytical skills and experience with BI tools, ensuring data-driven decisions are made to enhance operational efficiency. With a commitment to employee well-being, the organization offers a comprehensive benefits package, including flexible work arrangements and professional development opportunities. Join a mission-driven team dedicated to making a difference!

Benefits

No-cost medical & dental plan options

Disability and Life Insurance options

401(a) retirement plan with 10% employer contribution

Paid sick and vacation leave

12 paid holidays

6 weeks of parental leave

Tuition benefit program

Free RTD EcoPass

Free Onsite Parking

Qualifications

• 2+ years of experience using BI reporting tools.
• Ability to translate business requirements into data specifications.

Responsibilities

• Develop and maintain BI reports for various stakeholders.
• Engage with partners to determine data needs and project designs.

Skills

Business Intelligence Reporting

Data Analysis

SQL

Project Management

Analytical Skills

Communication Skills

Education

Bachelor’s Degree

Master’s Degree in Business or Analytics

Tools

Salesforce

Cognos

Tableau

ETL Tools

Job description

Join Our Team and Make a Difference in Higher Education!

At the System Administration office at the University of Colorado, we are dedicated to building a workplace where everyone feels valued, supported, and empowered to thrive. Our office is committed to fostering a culture where employees find community, a sense of belonging, and the opportunity to contribute meaningfully to our mission and purpose.

By joining our team, you’ll have a direct impact on shaping the future of higher education. In addition to the Office of the Board of Regents, the University of Colorado’s system administration includes 19 units that provide essential services to CU’s campuses in Aurora, Boulder, Colorado Springs, and Denver, as well as the Office of the President. While not a part of any one campus, we are proud to serve in the centralized office for the University system. Together, we ensure CU continues to deliver outstanding education, groundbreaking research, and valuable service to our communities.

We believe in creating an environment where the unique experiences and perspectives of everyone are embraced, enriching the work we do and the strategic outcomes we pursue. If you’re passionate about making a difference, contributing to a dynamic team, and supporting a mission that matters, we encourage you to apply and be part of our journey. Learn more about CU System Administration .

Position Summary:

The CU System Office of Advancement provides excellent customer service, strategy, expertise, and efficiency to our partners on CU’s campuses and at the University of Colorado Foundation. We support CU’s fundraising and engagement goals through advancement operations that include constituent research and development, data management, business intelligence, technical architecture, annual giving, planned giving, gift administration, marketing and communications, IT, budget and finance, and more. We believe that a healthy office culture is foundational to our success. We create this by bringing together a diverse team of colleagues and infusing our core values—Work Together, Think Big, Be Good and Have Fun—into our work every day.

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 this roles direct manager.

Duties and Responsibilities:

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)
• Monitors, analyzes, tests, and corrects existing 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

Minimum Qualifications:

• 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
• Interpersonal skills, including the ability to facilitate interaction, communication, and teamwork between othersOral, 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
• Ability to use structured query language (SQL) to write queries against complex database structures
• A cover letter identifying the job specific minimum qualifications you possess
• A resume including any and all relevant experience to be accurately assessed against the qualifications listed in the posting.

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.
• 6 weeks of parental leave to adjust to the joys of parenthood.
• A tuition benefit program for you and/or your dependents.
• Free RTD EcoPass and Free Onsite Parking at our 1800 Grant Street Office.

Additional taxable fringe benefits may be available.

Colorado is a state in the Mountain West subregion of the Western United States. It encompasses most of the Southern Rocky Mountains, as well as the northeastern portion of the Colorado Plateau and the western edge of the Great Plains.