Refer a Friend or Colleague

The Data Architect and Report Developer serves the office by writing both simple and complex SQL code to extract data for reporting and/or use in research projects that inform institutional decision-making.

With supervision, the position applies database architecture and management principles to oversee data extracts within the IRPE Oracle database to ensure tables, views, and/or extracts are designed to meet BI reporting standards. This is in support of creating a student data reporting structure for campus to utilize and for building data extracts for BI or R reporting. Again, with supervision, the position applies database architecture and management principles to oversee the collection of co-curricular student activities into the student information system and then within the IPRE Oracle database to ensure campus can accurately record participation and merge with student success data.

Additionally, the position serves as a report developer using industry standard tools to create standardized reports following established office protocols and documentation; includes both hard copy and online BI reporting (current tools are Power BI and R Studio).

This is a hybrid working position. Hybrid schedules are allowed; however, weekly in-person days in Fort Collins are required. The successful candidate must be legally authorized to work in the United States by the time of hire. Institutional Research, Planning and Effectiveness will not provide visa sponsorship for this position.