JOB SUMMARY

This position is 3 days in the office in our downtown Denver office and 2 days remote. 

The Business Intelligence (BI) Analyst contributes to the team’s transformative impact by lending strategic insight and keen analysis to Foundation operations impacting the University of Colorado (CU) System. In consultation with professionals in the CU System Advancement Office and the CU IT department, this position supports the Foundation through targeted reporting and technical administration. The BI Analyst responds to requests and contributes to on-going projects by working closely with Foundation 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, enhancing, and creating enterprise- and application-level reports using Business Intelligence tools.

ESSENTIAL DUTIES

• Deliver exceptional customer service.
• Embrace the Foundation’s mission and a culture of belonging and collaboration with each other and our colleagues.
• Assist in maintaining project request documentation and timelines related to project requests. Work with stakeholders to ensure projects are progressing in accordance with project plans and agreed upon schedules.
• Maintain sound knowledge of the Foundation’s priorities and deadlines in order to make responsible recommendations to management regarding reporting and information system issues.
• Provide timely project reporting on status, risks, accomplishments, and decision points to Foundation leadership.
• Lead and guide Foundation teams in developing and documenting specifications for report and dashboard enhancements and modifications.

 Data Analysis and Report Development

• Translate business requirements into specifications used to drive a data mart/data model design and configuration.
• Develop and maintain documentation of standard and customized report requirements (e.g. statements of work, roadmaps, and mock-ups).
• Monitor, analyze, test, and correct existing reports. Identify, propose, and implement processes for improving reliability and efficiency in an evolving reporting environment.
• Assist with ad hoc reporting and data analysis projects as needed.
• Assist with environment upgrades and migrations as needed.
• Actively participate as a member of the team in project initiatives and decision-making opportunities.

Project Management

• Conducts technical feasibility for projects, working cross-functionally as needed.
• Creates and maintains project management documentation, including standard project summaries and milestone timelines.
• Assists enterprise readiness by designing, developing, and deploying reporting solutions within the BI platform.
• Collaborates with the CU System Advancement Office and the CU IT department on initiatives related to the technology projects as needed.
• Leverages project management methodologies to help ensure timely, high-caliber deliverables.

 Customer Success

• Provide accurate, understandable, and useful metrics/reporting on performance and progress. Utilize those metrics to provide feedback, demonstrate performance, and drive progress.
• Work regularly with Foundation management to ascertain that the solutions recommended satisfy compliance and legal requirements.
• Consult with stakeholders to determine specifications for data requests, project design, and reporting needs.
• Work closely with stakeholders to design, test, create, and implement new reporting/dashboard solutions including complex reports with drill-down, drill-through, and parameterized functionality.
• Provide technical assistance and cross training of end users and technical support staff in use of internal and external reporting technologies.
• Ability to complete thorough and accurate research and appropriately apply to projects assigned.

 Other Duties

• Participate on committees and/or task forces as requested.
• Assist with special projects as requested.
• Perform other duties as assigned.

  COMPETENCIES

• Demonstrated ability to work within a diverse team and actively seek out opportunities to promote and cultivate diversity across the organization.
• Skilled in effective communication, collaboration, and problem-solving, including the ability to accurately interpret what others are saying and convey messages, information, concepts, and details. Strong organizational skills.
• Strong understanding of business processes, customer service and support.
• Knowledge of services and needs typical in institutionally related foundations (IRF).
• Knowledge of business intelligence principles and best practices, including data management and reporting processes.
• Analytical, logical, and problem-solving skills, including the ability to analyze data and trends in order to produce results.
• Ability to work independently and collaboratively in a fast-paced, complex environment to meet personal and team goals.
• Ability to provide technical assistance to stakeholders, including the ability to articulate technical information to non-technical users in layman’s terms.
• Ability to maintain confidentiality of information.
• Ability to manage multiple concurrent projects, follow-up with stakeholders, meet deadlines, and bring projects to completion.
• Ability to quickly learn new technologies and their application environment.

EDUCATION/EXPERIENCE

Required

• Bachelor’s degree or and/or equivalent life, military and/or professional experience
• Experience with Web Development programming languages (such as Java, JavaScript, jQuery, PHP, aspx, etc.).
• Experience working with relational databases in an Oracle client/server environment.
• Experience with SQL and writing queries against complex database structures.
• Experience with logical and physical data modeling concepts.
• Proficient user of technology, particularly Microsoft Office Products, Microsoft Teams, Zoom, and Adobe Acrobat.

 Preferred 

• Bachelor’s degree or higher from an accredited institution of higher education in Business Analytics, Decision Sciences, Statistics, Information Systems, or other related field of study.
• Five (5) years’ experience utilizing BI reporting tools to develop, maintain, and update business intelligence reports.
• Experience working in a higher-education and/or advancement setting.
• Experience with Cognos or similar BI tools.
• Experience with customer relationship management (CRM) software, particularly Salesforce and the UC Innovations Ascend product.

 SOFTWARE AND EQUIPMENT UTILIZED 

• Microsoft Office Suite; Adobe Acrobat; Monday.com; Zoom
• SQL/SOQL Query Tools
• Salesforce ascend applications, or similar
• Salesforce reports and dashboards
• Cognos, Tableau, PowerBI or similar BI tools
• ETL tools
• Blackbaud Financial Edge

 WORKING ENVIRONMENT 

• Hybrid schedule
• Overtime may be required as well as PTO may not be approved at fiscal and calendar year end
• Work in an office environment requiring light physical effort by handling objects up to 20 pounds occasionally and/or up to 10 pounds frequently with or without accommodations
• Stationary at a desk for most of the day, working with standard office equipment (such as phone, copier/scanner, and personal computer) with or without accommodations.

 COMPENSATION PACKAGE 

The hiring salary range for this position is: $86,275-$101,500.  Starting salary is based on education, experience, skills, and other job-related factors.

 This position is eligible for an incentive bonus, a full and competitive benefits package, which includes:

• Incentive pay: up to 10% bonus
• Medical: Three plan options
• Dental:  One plan option, 100% employer paid
• Vision: One plan option, 100% employer paid
• Health Savings Account: Employer contributes up to $2,000 annually
• Additional benefits: Disability, Life, Dependent/Health Flexible Spending Accounts
• Retirement 401(k) Plan: Employer contributes up to 6% of your annual compensation, per plan terms
• Paid Time Off and 12 Paid Holidays 
• Lifestyle Spending Account: Up to $1200 per year for reimbursements towards wellness programs
• Free underground garage parking
• Public Service Loan Forgiveness plan support
• Tuition reimbursement, 529 Savings Plan, Employee Assistance Program
• Professional Development Opportunities

WORKPLACE

Across our team, we value exceptional customer service, integrity, innovation, embracing our fiduciary responsibilities, and a welcoming and inclusive environment. Ideal candidates will operate well in a collaborative team environment while also completing work independently. 

We work in an office environment in a secured building with a mini on-site gym, secure indoor garage parking, with convenient access to uptown and downtown Denver and operate on a hybrid model where staff have the option to work in-office and remotely several days per week. 

ANTI-DISCRIMINATION POLICY:

The University of Colorado Foundation is an Equal Opportunity Employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion (creed), sex, national origin, disability status, marital status, sexual orientation, military status, gender, gender expression, age, protected status, or any other characteristic protected by law.

The University of Colorado Foundation is committed to recruiting and supporting a diverse workforce. The Foundation practices and champions inclusiveness in our community. We honor the diverse strengths, needs, voices, and backgrounds of all members of our community. Black, Indigenous, People of Color, others who identify as nonwhite, people with disabilities, veteran status, members of the LGBTQIA+ community, and those from traditionally marginalized communities are especially encouraged to apply for this role.

ABOUT THE UNIVERSITY OF COLORADO FOUNDATION:

For over 55 years, the University of Colorado Foundation has partnered with the University of Colorado to enhance philanthropic support for CU. Private support for the University, given through the philanthropic portal of the Foundation, enables the University to transform lives through education, research, clinical care, and community engagement. The Foundation focuses its efforts on donor stewardship through customer service and assurance in gift acceptance, processing, and administration. The Foundation invests and allocates gift funds in a manner consistent with the purposes established by donors and distributes dollars from its managed funds to support a wide variety of programs and activities throughout the University system and on its four campuses.

The Foundation has just under $3 billion in assets under management, including more than 3,000 endowment funds. 

The Foundation is a 501(3)c public charity governed by an independent Board of Directors.  The Foundation’s day-to-day operations are carried out by an administrative staff of approximately 22 individuals overseen by the Foundation’s President and CEO.