Business Intelligence Analyst

Company: Arapahoe Community College

Job Location: Littleton, 80160

Category: Business and Financial Services

Type: Full-Time

Salary: $69,850.00 - $79,375.00 Annually

Location: Littleton, CO

Job Type: Administrator/Professional-Technical (Full-Time)

Job Number: 00293

Division: Office of the President

Department: Institutional Research

FLSA: Exempt

ACC Careers: Where You Can Move Mountains

Nestled in the foothills of the Rocky Mountains sits one of the oldest community colleges in Colorado, Arapahoe Community College. With a rich history of educational excellence, ACC embraces a culture that values diversity, individualized support, and unwavering commitment to student success, without exception.

Job Summary

Arapahoe Community College seeks a highly skilled and experienced Business Intelligence (BI) Analyst to join the Office of Institutional Research and Decision Support. The BI Analyst plays a pivotal role in advancing the college's mission by providing critical data analysis and insights that drive strategic planning and informed decision-making. This position supports the college's commitment to empowering lives by designing, building, and maintaining data-driven applications and interactive visualizations that track and analyze key institutional metrics, including enrollment, retention, graduation rates, and student outcomes. By ensuring the accessibility and accuracy of this data, the BI Analyst empowers college leadership to make evidence-based decisions aligned to strategic outcomes. This position requires skills to support the design, building, automation, and maintenance of robust data-driven applications and accessible, interactive data visualizations for enrollment, retention, graduation, demographic, and outcome trends, and other critical institutional statistics. The primary place of work is at the Littleton Campus, but travel may occasionally be required to other areas as needed.

Key Responsibilities:

• Data Management and Analysis: Collect, extract, review, and analyze data related to academic performance, student demographics, and support services to identify key factors impacting student success. Prepare reports and dashboards that provide insights to leadership for better decision-making related to improving student outcomes.
• External Reporting & Surveys: Compile and report institutional data to external agencies and accrediting bodies, develop survey tools, coordinate data collection, and analyze and present survey statistics.
• Training and Professional Development: Use analytical, technical, and communication skills to provide actionable data insights, develop training content, and represent the college in professional settings.

Knowledge, Skills & Abilities:

• Expertise in relational and NoSQL databases, including SQL Server, Oracle, MySQL, PostgreSQL, with advanced skills in writing and optimizing SQL queries, procedures, and views.
• Proficient in data integration and ETL processes, with strong understanding of data warehousing and business intelligence concepts.
• Skilled in programming languages for data analysis and automation, such as Python, Java, C#, SAS, R, and SPSS.
• Ability to guide data conversations and data consumers so data are presented and interpreted as actionable insights for immediate use in institutional decision-making for business decisions.
• Experienced in building interactive dashboards and visualizations using Power BI, Tableau, and web-based tools.
• Strong analytical and problem-solving skills with attention to detail in identifying and resolving data inconsistencies.
• Effective communicator across technical and non-technical audiences, translating campus needs into data solutions.
• Capable of managing multiple projects independently, meeting deadlines, and adapting evolving technologies.
• Committed to data integrity and confidentiality with a logical approach to organizing, analyzing, and documenting data.

Qualifications

• Bachelor's degree or higher in data analytics, statistics, or a related field or a combination of education and related experience and experience will not count towards the requirements listed below.
• Two (2) years of experience in data and database management, including methods for systematic and repeatable data querying, extraction, transformation, storage, and analysis in database, spreadsheet, and statistical applications.
• Demonstrated experience with at least two programming languages, including SQL.
• Preferred: Professional experience in a college or higher education organization. Experience designing, administering, and analyzing surveys.

Application Instructions

All applicants must submit: Resume, Detailed letter of interest (cover letter) addressing the job announcement. Please include any experiences you may have embedding equity and inclusion in your work, see below. At ACC we seek to hire candidates that demonstrate a commitment to and experience with embedding equity and inclusion into their professional role. Please address this specifically in your cover letter explaining what diversity, equity, and inclusion mean to you and how you may have incorporated these ideas into your current or previous professional responsibilities. Reach out to us at HRrecruitment@arapahoe.edu if you have any questions. ACC seeks applicants who understand and have first-hand experience working with diverse populations, which may include but are not limited to, historically marginalized populations such as people of color, LGBTQ+ community members, veterans, first generation graduates, and people with disabilities.