Business Intelligence Analyst

Title: Business Intelligence Analyst

Position Type: Professional Tech Full time

College: Pikes Peak State College

Location: Colorado Springs

Salary Range: $85,000 - $105,000 annual gross

 

Who We Are:

Pikes Peak State College is the largest and most diverse college in the Pikes Peak region, serving students with a wide range of goals, experiences, and responsibilities. Our students include recent high school graduates, working adults, military-affiliated students, parents, first-generation students, career changers, transfer students, and lifelong learners.

Our mission is to provide high-quality educational opportunities to all, with a focus on student success and community needs. We fulfill that mission by creating affordable, flexible, and accessible pathways that help students transfer to four-year institutions, enter the workforce, advance their careers, and build better futures close to home.

As the needs of our students, employers, and communities continue to evolve, so do we. PPSC embraces innovation that is human-centered, ethical, and focused on student learning. Through strong workforce partnerships and the thoughtful integration of emerging technologies, including artificial intelligence, we prepare students not only for today's opportunities, but for what's next.

We're looking for people who are passionate about access, collaboration, innovation, and student success. Whether you work in the classroom or behind the scenes, your contributions help create opportunities that change lives. At PPSC, our vision is simple: Students Succeed at PPSC.

 

Job Summary:

This is a NON-CLASSIFIED employment opportunity and is exempt from the State Classified Personnel System. Visit the State of Colorado for Classified employment opportunities.   

The Business Intelligence Analyst develops and maintains business intelligence reports,
dashboards, and data visualizations that support institutional planning, program valuation, and decision-making. Working with large datasets from multiple sources, the analyst uses business intelligence and data visualization tools to transform institutional data into accessible and actionable information. The position also responds to internal and external data requests and supports external surveys and institutional reporting requirements.

Reports to: Executive Director of Institutional Effectiveness

Duties & Responsibilities:

Reporting and Analysis:
• Develop, maintain, and optimize technically sophisticated reports within IBM Cognos and EAB Edify reporting environments.
• Design, develop, and maintain interactive dashboards, data visualizations, and other reporting products to communicate institutional trends, patterns, and performance indicators.
• Serve as the subject matter expert in business intelligence and data visualization by providing consultation on the design of complex reports and developing training materials.
• Document data sources, reporting logic, definitions, and processes to promote consistency, transparency, and reproducibility.
• Respond to routine internal and external data requests by retrieving, analyzing, and presenting accurate information within established deadlines.
• Conduct descriptive and inferential statistical analyses to provide insight on the effectiveness of programs and operations.
• Analyze, evaluate, logically interpret, and summarize a wide variety of institutional data.
• Validate data accuracy and consistency, troubleshoot reporting issues, and investigate discrepancies in collaboration with other college departments.
• Apply established data governance practices, confidentiality requirements, and reporting standards.
• Collaborate with technical and functional stakeholders to improve data availability, reporting processes, and the effective use of business intelligence tools.

Other duties:
• Attend conferences and meeting as assigned by the Executive Director of IE.
• Actively participate in the state-wide Institutional Research Advisory Group.
• Partner with the Colorado Community College System Business Intelligence Team in the development of system-wide reports and dashboards.
• Assist as needed with other IE-related projects.
• Serve on task forces and project teams.

Competencies/KSAs:

• Experience in working with large data sets.
• Strong understanding of database and data warehouse structures.
• Experience extracting data from large databases.
• Strong SQL skills including the ability to create and modify complex SQL scripts.
• Advanced report/dashboard writing skills including creating joints, prompts, and calculated fields.
• Demonstrated critical thinking, problem solving, and interpretive skills to analyze situations, define problems, and develop/implement solutions.
• Ability to analyze and logically interpret data.
• Demonstrated experience organizing complex data sets into tabular and graphic presentations.
• Proficiency in Microsoft Office with the ability to work in Excel at a sophisticated level (e.g. pivot tables, slicers, formulas, macros, Power Query).
• Demonstrated experience creating interactive dashboards in Power BI, Tableau or similar tools.
• Experience conducting descriptive and inferential statistical analyses in SPPS, R or similar tools.
• Demonstrated ability to interpret and present complex information in various formats to a diverse audience.
• Demonstrated capacity to communicate effectively both orally and in writing.
• Ability to establish goals, priorities, and timelines.
• Ability to complete projects independently and work cooperatively as part of the team.
• Ability to maintain confidentiality and security of information.
• Extreme attention to detail and data accuracy.
• Strong organizational and time management skills with the ability to prioritize and manage multiple projects and tasks concurrently.
• Ability to work with both technical and non-technical personnel at various levels of the organization.
• Ability to navigate differences effectively and respectfully in the workplace.
• Adhere to college policies and procedures.

Minimum Qualifications:

• Bachelor’s degree from a regionally accredited institution.
• Three years of experience using business intelligence tools (e.g., IBM Cognos Analytics, EAB Edify) to create reports and query databases using SQL.
• Three years of experience using data visualization tools (e.g., Power BI, Tableau) to develop interactive reports and dashboards.
• Experience in quantitative analysis using descriptive and inferential statistics using SPSS, R or other statistical programs.

Professional level experience is defined by the Colorado Division of Human Resources: A position that involves the exercise of discretion, analytical skill, judgment, personal accountability, and responsibility for creating, developing, integrating, applying, or sharing an organized body of knowledge. Colorado revised statute (C.R.S. 24-50-135(1) allows colleges to exempt positions from the State Personnel Classified System that are determined to be professional level work.

Preferred Qualifications:

• Master’s degree from a regionally accredited institution.
• Five years of experience using business intelligence tools (e.g., IBM Cognos Analytics, EAB Edify) to create reports and query databases using SQL.
• Five years of experience using data visualization tools (e.g., Power BI, Tableau) to develop interactive reports and dashboards.
• Experience in higher education, institutional research, institutional effectiveness, or a related environment.

Selection Process:

For full consideration, all application materials must be received by 4:00 p.m. MST on  November 17, 2026.

Must be a State of Colorado resident or able to relocate to Colorado prior to first date of employment.

Visa support is not available for this position.

Application Instructions: 

Pikes Peak State College will conduct reference checks and a criminal background check on the selected candidate. Employment offers and continued employment are contingent upon successful completion of a criminal background check. Positions with access to Federal Tax Information require a fingerprint-based criminal history record check as part of the pre-employment process.

Application must be submitted online.  Incomplete applications may not receive full consideration.  A complete application will include:

Cover letter - Address the minimum and preferred qualifications in the order listed on the job announcement.
Resume - Reflect experience, education, knowledge, skills, and abilities.  
Unofficial Transcripts - Unofficial transcripts for all degrees conferred.  Official transcripts are required if hired for the position.  
Professional References - Provide names and contact information for three recent professional references who can address your expertise and background for this position.

Additional Information/Benefits:

Work Life Balance

Pikes Peak State College offers a generous amount of annual leave and sick leave. Depending on your employment category and full or part-time status, Pikes Peak State College offers 15 hours a month of annual leave and 10 hours a month of sick leave accrual. There are paid holidays and alternate paid holidays which allow the college to be closed Christmas Day through New Year's Day. Eligibility is defined by your employment FTE status.

Tuition Reimbursement

Education and your success are a priority at Pikes Peak State College. We encourage you to develop job skills and abilities which will benefit you as well as our college. Eligible employees, their eligible dependents, and spouse/domestic partners may enroll in credit courses at any of the Colorado Community College System. Eligibility is defined by your employment FTE status.

Health, Dental & Vision

Pikes Peak State College offers a comprehensive benefits package designed to provide you and eligible dependents, spouse/domestic partner, with a broad range of employer paid and employee paid benefit options. In addition to medical coverage, the college offers dental and vision insurance plans to choose from. Eligibility is defined by your employment FTE status.

Retirement

Pikes Peak State College participates in Colorado Public Employees' Retirement Association (PERA) contribution rates. State employees are required to a mandatory contribution of a percentage of their salary to the plan, and the college contributes a percentage as well. While you are enrolled in PERA, you do not pay Social Security. In addition, there are supplemental retirement plans available through three other vendors.

Flexible Spending Accounts

Flexible Spending Accounts (FSA) offer you an easy way to pay for eligible medical and childcare expenses with money that's set aside with a pre-tax benefit. Eligibility is defined by your employment FTE status.

Disability Coverage

Pikes Peak State College offers disability insurance to help you meet needs should you become unable to work due to an illness or injury.

Life Insurance

Pikes Peak State College offers life insurance paid for by the college to eligible employees. Supplemental life and accidental death and dismemberment insurance policies are available for those interested in additional coverage. Eligibility is defined by your employment FTE status.

Additional Leave Programs

Pikes Peak State College offers additional leave programs such as bereavement leave, jury leave, community and parental academic leave, Family and Medical Leave (FML), and Colorado Family and Medical Leave Insurance (FAMLI).