Front Range Community College - Westminster, CO

posted about 2 months ago

Full-time - Entry Level
Remote - Westminster, CO
10,001+ employees
Educational Services

About the position

As the Analyst & Junior Developer at Front Range Community College (FRCC), you will play a crucial role within the Data Science and Institutional Research (DSIR) Office. This position requires a balance of analytical and development responsibilities, where you will be tasked with collecting, analyzing, interpreting, and disseminating accurate and timely information to support institutional decision-making, planning, and reporting for FRCC, Lamar Community College, and Otero College. Your work will involve effective communication and collaboration with various stakeholders, ensuring that data-driven insights are accessible and actionable. In this role, you will utilize your technical skills in SQL and Python to provide regular and ad hoc reporting, as well as to develop and maintain interactive dashboards using Power BI. You will support the Director of DSIR in preparing mandated reports such as IPEDS, SURDS, and grant reporting, while also managing your time effectively to adapt to changing requirements. Your contributions will be vital in transforming raw data into compelling narratives through reports and dashboards, thereby supporting the mission of all three colleges. The position offers some flexibility for remote work; however, a consistent presence on campus is required. Occasional travel to all three FRCC campuses may also be necessary. As a Colorado resident, you will be expected to start your employment on your first day.

Responsibilities

  • Provide ad hoc reports using SQL, Python, Cognos, and/or Excel for internal departments to enable data-informed decisions.
  • Interpret data findings for diverse populations and guide stakeholders in next steps based on data insights.
  • Design and develop interactive, user-friendly dashboards using Power BI, SQL, and Python.
  • Assist the Director in delivering training to college departments on data analysis and interpretation, as well as the use of analytic tools such as Cognos, MS Excel, and Power BI.
  • Serve on various internal and external committees to communicate trends, developments, and issues to college and external constituencies.
  • Support strategic planning initiatives by developing efficient database systems for DSIR.
  • Collaborate with the team to identify, assess, and remedy process inefficiencies.
  • Provide SQL, Python, VBA, and MS Access programming to develop and maintain repeatable and efficient reporting and dashboard capabilities.
  • Write and maintain Cognos reports using Cognos Report Studio.
  • Write clear and accurate procedures and documentation for easy maintenance and cross-training.
  • Assist the Director in planning and designing new features and functionality for backend systems.
  • Write and maintain code (Python, SQL, HTML, and CSS) to support DSIR's day-to-day operations.
  • Troubleshoot bugs and unexpected behavior in code, recommending possible fixes to the Director.
  • Assist the Director in developing and implementing strategic plans, objectives, and priority initiatives for the DSIR department.
  • Proactively learn and research existing and new technologies, recommending potential process improvements to the Director.
  • Conduct survey design, review, and analysis in Qualtrics.

Requirements

  • Graduated from a regionally accredited college/university with an associate degree.
  • 2 or more years of experience in database development, data analysis, or a related field.
  • Demonstrated experience producing visually appealing Excel reports with tables and charts.
  • Demonstrated experience interpreting data requests to produce final reports.
  • Demonstrated experience writing SQL queries to filter, join, and aggregate data for analysis.
  • Ability to apply critical thinking to complex systems for troubleshooting and learn new programming languages, techniques, and systems quickly.
  • Working knowledge of statistics and research techniques.
  • Knowledge of data structures and data manipulation techniques.
  • Attention to detail.

Nice-to-haves

  • Experience with data visualization tools such as Power BI or Tableau.
  • Familiarity with Qualtrics for survey design and analysis.
  • Knowledge of VBA for Excel automation.

Benefits

  • Health insurance
  • Dental insurance
  • Vision insurance
  • Retirement plan options
  • Paid holidays
  • Paid time off
  • Professional development opportunities
  • Flexible scheduling options
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service