Research Analyst

Community College of Denver; Westminster (CO); Hybrid; USD 68,000 - 72,000; Full time

Job summary

Front Range Community College is seeking a Research Analyst for the FRCC DSIR to analyze data, produce reports, and support institutional decision-making. The role emphasizes SQL-based reporting, data interpretation, and collaboration with multiple college departments.

The analyst will work with Power BI and Excel, participate in compliance reporting, and contribute to training and documentation. Westminster Campus requires weekly on-site presence with remote work options and occasional travel

Qualifications

• Bachelor's degree in Business, Computer Science, Information Technology, Statistics or related field.
• Two or more years of experience in database development, data analysis or related experience.
• Demonstrated experience writing SQL queries to filter, join and aggregate data for analysis.
• Working knowledge of statistics and research techniques.
• Knowledge of data structures and data manipulation techniques.

Responsibilities

• Provides ad hoc reports using SQL, Python, and/or Excel for internal departments to enable data-informed decisions.
• Interprets data findings for diverse populations and guides stakeholders on next steps.
• Assists Director in delivering training on data analysis and analytic tools (Power BI, MS Excel, etc.).
• Writes clear procedures and documentation for maintenance and cross-training.

Skills

SQL

Python

Excel

Power BI

Education

Bachelor's degree

Tools

Power BI

Excel

SQL

Job description

Title:

Research Analyst

Position Type:

Professional Tech Full Time

College:

Front Range Community College

Division:

Strategy & Innovation

Department:

FRCC Data Science & Institutional Research

Campus:

Westminster Campus

Location:

Westminster

Salary Range:

$68,136 - $71,543 annually

Who We Are:

With three campuses along Colorado's Front Range, FRCC is the state's largest community college. We enroll close to 28,000 students annually from our diverse service area, which offers a variety of cultural and recreational activities.

Each year approximately 5,000 FRCC students transfer to four-year universities and FRCC offers more than 36 career training programs that prepare students for immediate employment and rewarding careers. Last year, more than 5,000 high school students took concurrent enrollment classes with us, earning college credit without having to pay college tuition. And we were recently ranked as one of the "Top Online Colleges" in the country by Newsweek.

One of FRCC's main goals is to offer educational excellence for everyone. The college's strong commitment to student success means we start by creating an inclusive and equitable environment - one where both students and employees feel they belong and are supported. FRCC's focus on diversity, equity and inclusion is woven into the fabric of our college conversations and decision-making processes. We are actively seeking to hire a workforce that reflects the diversity of our student body.

The college is also an emerging Hispanic Serving Institution. For us, becoming an HSI is an intentional commitment to being a college where our Latinx (and other historically marginalized) students thrive.

At FRCC, employees and leaders bring our values to life through their actions. We collaborate across roles and campuses, seek and value diverse perspectives, follow through on our commitments, and turn thoughtful ideas into meaningful improvements which are measured for success. We take pride in our work, support one another, and make decisions that advance student success, equity, and excellence. We seek people who will actively contribute to this culture and demonstrate these commitments every day.

Job Summary:

The Office of Data Science and Institutional Research (DSIR) collects, analyses, interprets, and disseminates accurate and timely information in support of institutional decision-making, planning, and reporting. DSIR serves as the college's central group of Data Champions to enable data-informed initiatives championed by Executive sponsors across all functional areas. DSIR performs this work for three community colleges: Front Range Community College, Lamar Community College, and Otero College.

The Institutional Research (IR) portion of the office, the primary focus of the Research Analyst, leverages DSIR's SQL databases for operational, analytical, and executive reporting. The Research Analyst takes the lead on FRCC DSIR's incoming data requests, ad hoc analysis, and repeating requests. The Research Analyst supports the Director of DSIR in mandated reports such as IPEDS, SURDS, grant reporting, and other data-involved tasks as needed.

Power BI and Excel are the other primary tools used in conjunction with data from SQL to share insights across our communities.

This position requires excellent problem solving and technical skills, and an ability to effectively communicate and work collaboratively with others. Time management skills and the ability to adapt to changing requirements are vital. The Research Analyst thinks strategically and develops creative solutions to meet the needs of the campus community.

The Research Analyst is part of a dynamic team who love turning raw data into storytelling through reports and dashboards to support the three colleges. The analyst is a creative problem solver as well as an active listener who enjoys translating questions into action. They suggest new ideas about what questions should be asked and offer new tools or methods for improving processes.

This position is based out of the Westminster Campus and requires a weekly on-campus presence. The position can work primarily remotely and will occasionally need to travel to all three FRCC campuses.

Please note: You need to be a Colorado resident on your first day of employment. Also, Front Range Community College is an E-Verify employer.

Duties & Responsibilities:

Data Analysis & Interpretation

• Provides ad hoc reports using SQL, Python, and/or Excel for internal departments to enable them to make data-informed decisions.
• Interprets data findings for diverse populations. Guides stakeholders in next steps as indicated by the data.
• Assists Director in delivering training to college departments on data analysis and interpretation as well as the use of analytic tools such as Power BI, MS Excel, and other external analytics systems.
• Serves on a variety of internal and external committees for the purpose of communicating trends, developments, and issues to college and external constituencies.

Compliance, External Reporting, and Survey Design

• Assists Director in preparing and validating Compliance reporting, including but not limited to, Student Unit Record Data System (SURDS), Integrated Postsecondary Education Data System (IPEDS), and Higher Learning Commission (HLC).
• Designs, reviews, and analyzes surveys in Qualtrics and other tools. Serves on various committees to support the use of best practices.
• Collaborates with Marketing to maintain public-facing reporting for compliance, marketing, and public relation purposes.
• Prepares common external reporting, such as Common Data Set.

Reporting Support and Data Quality

• Validates accuracy of data represented in Power BI against simple, standard queries and reports. Reports any issues to appropriate DSIR staff.
• Provides training materials, training sessions, and workshops for end-users to assist in data literacy efforts.
• Writes clear and accurate procedures and documentation to enable easy maintenance and cross-training.

Strategic Management

• Assists Director in developing and implementing strategic plans, objectives, and priority initiatives for the DSIR department.
• Proactively learns and researches existing and new technologies; recommends potential process improvements to the Director.

Operations Quality Assurance

• Assists Director in planning and designing new features and functionality for backend systems.
• Writes and maintains code (Python, SQL, HTML and CSS) to support DSIR's day-to-day operations.

Competencies/KSAs:

• SQL Query Writing: Ad hoc reporting, advanced analysis, and dashboards are created primarily using SQL. Compliance reporting is backed by SQL, understanding the syntax is required to ensure accuracy of reporting.
• Interpersonal, Verbal and Written Communication Skills: Skilled in comprehending requester inquiries and collaborating to identify their needs. Produces reports that requester and/or end‑user understands how to interpret. Maintains procedures and data dictionaries for all processes. Ability to relay complex results in an organized and easily understandable fashion.
• Source Control: DSIR's code including compliance reporting and production Power BI reports are tracked and managed with Git source control using GitLab merge requests.
• Critical Thinking Skills for Troubleshooting Complex Systems: Reporting involves many data sources with nuances, changing definitions, and requires complex querying to develop and maintain.
• Discretion & Confidentiality: Demonstrates constant awareness and usage of industry best practices on storing or transferring sensitive data. DSIR has access to a variety of private and sensitive data that must be protected appropriately. Adheres to DSIR Code of Ethics.
• Relationship Building: Compliance reporting is high profile and involves collaborating with report stakeholders from Leadership to Faculty. DSIR collaborates with most internal departments, other IR departments from sister colleges, the Colorado Community College System’s Business Intelligence / IR department, sharing techniques and programming.
• Mission, Vision & Values: Embraces the mission, vision and values of FRCC. Understands the importance of the work that you do to support institutional goals.
• Student Centeredness: Places the student at the center of your work. Adopts a philosophy that makes the ability to serve the student the cornerstone of the work that you do.
• Equity Mindedness: Learn to view department operations through an equity lens. Be willing to call attention to processes or practices that lead to inequity in the reporting process. Understand the College's equity goals and how your role supports FRCC's ability to achieve those goals.
• Operational Planning: Have an understanding and knowledge of the college's various strategic plans and understand how your work supports each of them. Understand the department's expectations to find proactive ways to support the goals of the department.
• Leading from the Middle: Lead from your position by not only closely examining your responsibilities for the department, but in bringing forward ideas to your supervisor.
• Team Building: Participate in team-building exercises and strive to build positive and collaborative relationships with colleagues both within the department and in other departments within the college.
• Attention to Detail: Ensures reports are professionally prepared and validates results against prior reporting to ensure accuracy and quality.

Minimum Qualifications:

• Bachelor's degree in Business, Computer Science, Information Technology, Statistics, Mathematics or related field.
• Two or more years of experience database development, data analysis or related experience.
• Demonstrated experience writing SQL queries to filter, join and aggregate data for analysis.
• Working knowledge of statistics and research techniques.
• Knowledge of data structures and data manipulation techniques.

Selection Process:

The selection process for this position will be conducted through a competitive, merit-based evaluation of all qualified applicants. Preliminary screening will be based on the completed application package submitted by the candidate.

Position will remain open until filled with a priority deadline of November 16, 2026.

This posting may be used to fill multiple or similar positions.

Application Instructions:

In your application, please include a resume and cover letter that specifically address how your background and experience align with the requirements, qualifications, and responsibilities of the position.

The application will ask for you to provide three references. We ask that they are all professional references and at least one is a current/recent supervisor.

Additional Information/Benefits:

Salary Information: The salary range reflects the minimum and maximum starting salary for the position. When determining the starting salary for a new employee, FRCC takes into consideration a combination of the selected candidate's education, training and experience as it relates to the requirements of the position, as well as the position's scope and complexity, internal pay equity and external market value.

Benefits Information: For information about benefits for Administrative, Professional and Technical Employees and Faculty, please see the Front Range Community College Benefits page.

Welcoming. Respectful. Inclusive. Together, we are FRCC.