Business Intelligence Analyst (Partial remote option)

Pikes Peak State College; Colorado; A distancia; USD 75.000 - 110.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Tuition Reimbursement

Health, Dental & Vision insurance

Descripción de la vacante

Pikes Peak State College in Colorado is seeking a Business Intelligence Analyst to develop and maintain reports, dashboards, and data visualizations that support institutional planning and decision-making. You will work with large datasets from multiple sources to provide accessible, actionable information for college stakeholders.

The role requires hands-on experience with BI and visualization tools (IBM Cognos Analytics, EAB Edify, Power BI, Tableau), strong SQL skills, and a commitment to

Formación

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

Responsabilidades

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

Conocimientos

SQL

Power BI

Tableau

Python/R basics

Descriptive statistics

Inferential statistics

Educación

Bachelor’s degree

Master’s degree

Herramientas

IBM Cognos Analytics

EAB Edify

Power BI

Tableau

SPSS

R

Descripción del empleo

Selection Process:
- For full consideration, all application materials must be received by 4:00 p.m. MST on November 24, 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.

Job Duties

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.

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.

Job Qualifications

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.

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.
• 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 SPSS, 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.

Institution Description

Pikes Peak State College (PPSC) 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.

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

Application Due Date: 11/24/2026

Job Start Date: 01/03/2027

Institution: Pikes Peak State College

Reports To: Executive Director of Institutional Effectiveness

Staff # Reporting to Position: 0

Reports In Office: Institutional Effectiveness

Search for openings in IR, effectiveness, assessment, planning, and related fields at higher education institutions in the U.S. and abroad.