Job Listings

Analyst and Developer, Student Success

Front Range Community College
Job Location:
Westminster, Colorado
Salary: See Position Description

Location: Westminster Campus - Westminster, CO

Job Type: Administrator/Professional-Technical Full-Time

Division: Administration & College Support

Job Number: 202300633

Department: Institutional Research

General Summary

This is a full-time grant-funded position expected to extend to September 30, 2023, and with the possibility for an additional extension to June 30, 2024.

Who We Are
We are the largest community college in Colorado, enrolling close to 28,000 credit students annually in a diverse service area with broad cultural and recreational activities. We were one of 30 colleges in the initial American Association of Community Colleges Pathways Project, recently selected as a "Most Promising Place to Work" in Diverse Magazine, and profiled as one of six top community colleges for transfer student success in a recent Aspen Institute publication.  Our online learning program has twice been listed recently as one of the top 10 community college online programs in the country. 

We have strong commitments to student success and to inclusion, equity, and diversity. We are actively seeking to hire a workforce that matches our student community.  We are an emerging Hispanic Serving Institution and expect to reach HSI status by 2024 or 2025.  

We have worked hard to create a culture of collaboration, innovation, and pride and seek people who share those values and our commitments to student success and equity.  

Our Office of Data Science and Institutional Research (DSIR)
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 for two community colleges, Front Range Community College and Lamar Community College. We are dedicated to improving students' success by advancing a culture of evidence and value.

We value the creativity, expertise, and innovation of our employees, as well as their potential. FRCC has a strong commitment from our leadership to the professional development of our faculty and staff.

Who You Are
As the Student Success Analyst & Developer, you will utilize time management and your ability to adapt to changing requirements to balance the responsibilities of analysis and development within the Data Science and Institutional Research (DSIR) office. You will use excellent problem solving and technical skills and an ability to effectively communicate and work collaboratively with others. You will also have opportunities to think strategically and develop creative solutions to meet the needs of the campus community. 
You will focus on the planning, development, and implementation of a new student success dashboard and will also provide data literacy training to assist end users in using and understanding the results provided by the dashboard. 
Please note: This is an on-campus position with an opportunity for hybrid remote work. You need to be a Colorado resident on your first day of employment.    

SALARY: Mid to high $60s/annually  

BENEFITS:  Please click here to find more information about APT & Faculty Benefits  

SELECTION PROCESS: Position will remain open until filled with a priority deadline of October 2, 2022.  This posting may be used to fill multiple or similar positions.  

Preliminary screening will be made on the basis of completed application package submitted by candidate. In your application please include a resume and cover letter that specifically addresses how your background and experience align with requirements, qualification and responsibilities of the Student Success Analyst & Developer.   

At FRCC, masks are optional, but we allow individual staff and faculty to request students and colleagues wear masks in offices or in class.

Primary Duties
  • Develop and implement strategic plans, objectives, and priority initiatives for how the DSIR department can further support Student Success objectives.
  • Collect project requirements, data definitions, and desired outputs for new dashboards to be developed. 
  • Communicate with a variety of internal and external committees for the purpose of sharing dashboards, trends, developments, and issues to college and external constituencies. 
  • Provide data literacy training to Dashboard users and stakeholders covering methodology and interpretation of data. 
  • Develop workshop-style training for end users to highlight dashboard functionality and continue the feedback cycle.
  • Develop SQL queries using existing data and data structures to provide point-in-time and longitudinal analysis. 
  • Develop Python to improve DSIR's ability to generate informative, actionable, data intensive dashboards and reports. 
  • Use Python to create interactive charts and data tables for dashboards. 
  • Write documentation to illustrate common usage and explain design decisions.
  • Develop additional database structures (tables, views, stored procedures) to support new data elements required for dashboards. 
  • Write and maintain Cognos reports using Cognos Report Studio.
Required Competencies

SQL: Demonstrate an understanding of SQL, relational databases, and query writing.   Maintain and improvs existing MS SQL table structures, views, functions and stored procedures to support analytical reporting needs. Must apply proper keys, constraints, and referential integrity to database tables.

Programming: Use Python to develop interactive dashboards with an internally developed framework.   Use Python code to create SQL queries, applying conditional logic and looping to dynamically inject data into HTML reports.

Critical thinking: Use logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems. Develop new dashboards to address and respond to emerging needs.

Active Listening: Give full attention to what other people are saying, take time to understand the points being made, and engage with thoughtful questions.

Utilize discretion and handle confidential materials professionally: Demonstrate constant awareness and usage of industry best practices on storing or transferring sensitive data.

Interpersonal, verbal and written communication: Produce reports that the requester and/or end-user can interpret. Maintain procedures and data dictionaries for all processes. Relay complex results in an organized and easily understandable fashion. Train end users on topics related to data literacy.

Relationship building: Collaborate with other departments from sister colleges and the system business intelligence department, sharing techniques and programming.

Diversity, Equity & Inclusion: Be aware of how biases can affect data analysis through unrepresentative data sets.


Required Education/Training & Work Experience:
  • Associate degree from a regionally accredited college.
  • Experience writing SQL queries.
  • Experience producing reports with tables and charts in Excel.
  • Experience developing in Python or other programming language.
  • Experience creating and updating interactive dashboards.
  • Experience with Git or other version control.
Welcoming. Respectful. Inclusive. Together, we are FRCC.
HigherEd360 is part of the HigherEdJobs network.