"Alerted.org

Posting Detail Information

Working TitleData Architect and Report Developer

Position LocationFort Collins, CO

Work LocationPosition qualifies for hybrid/in-office work

Research Professional PositionNo

Posting Number202501047AP

Position TypeAdmin Professional/ Research Professional

Classification TitleProf/Indiv Contrib II

Number of Vacancies1

Work Hours/Week40

Proposed Annual Salary Range$60,000 - $90,000

Employee Benefits

Colorado State University is not just a workplace; it’s a thriving community that’s transforming lives and improving the human condition through world-class teaching, research, and service. With a robust benefits package, collaborative atmosphere, and focus on work-life balance, CSU is where you can thrive, grow, and make a lasting impact.

+ Review our detailed benefits information here. (https://hr.colostate.edu/wp-content/uploads/sites/25/2021/01/benefits-summary-afap.pdf)

+ Explore the additional perks of working at CSU here.

+ For the total value of CSU benefits in addition to wages, use our compensation calculator (https://hr.colostate.edu/total-compensation-calculator/) .

+ Lastly, click here for more information about why Fort Collins is consistently ranked in the top cities to live in (https://hr.colostate.edu/prospective-employees/our-community/) !

Desired Start Date09/01/2025

Position End Date (if temporary)

To ensure full consideration, applications must be received by 11:59pm (MT) on08/17/2025

Description of Work Unit

As part of the Office of the Provost and Executive Vice President, the Office of Institutional Research, Planning and Effectiveness ( IRPE ) provides vision and leadership to the reporting, institutional research, assessment, strategic planning and accreditation activities of the institution. Hybrid schedules are allowed; however, weekly in-person days in Fort Collins are required.

Position Summary

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.

Required Job Qualifications

+ Bachelor’s Degree in related field.

+ Experience using SQL programming.

+ Experience working with relational databases.

+ Experience with report development utilizing automated processes.

+ Experience reviewing data and reports, identify data inconsistencies, and take initiative to provide solutions.

+ Demonstrated ability to work effectively with members of a team, with willingness to serve as a resource to others.

+ 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.

Preferred Job Qualifications

+ Master’s degree in related field.

+ Experience with higher education data report creation.

+ Knowledge and experience with Banner ODS .

+ Experience with Power BI and Fabric.

+ Experience with R Studio, including functional programming and report rendering with Quarto. Experience in data warehouse design and development.

+ Experience with and skill in ETL performance tuning.

+ Strong communications skills with ability to organize and present information clearly in analyses and reports.

Essential Duties

Job Duty CategoryData Architecture Management/SQL Programming

Duty/Responsibility

+ With limited supervision, creates and uses SQL to gather institutional data from enterprise systems (HR, student, finance, LMS etc.) to further the processes of accreditation, institutional research, program review, and strategic planning.

+ With limited supervision, submits data to outside entities and/or assists with external survey reporting by writing complex SQL code to extract data from an Oracle database,

+ Support the office in developing processes and policies to ensure captured data reflects the university priorities, including the creation of new data pipelines (e.g., the co-curricular data pipelines).

+ ·Employs knowledge of university policies, process, and reporting schedules to ensure data are appropriately and cleanly captured.

+ Supports the maintenance of reporting data dictionary to ensure accurate definitions and data source tracing within the Oracle database and Power BI. Additionally, supports the maintenance of IR data glossary on IR’s website.

Percentage Of Time40

Job Duty CategoryReport Development

Duty/Responsibility

+ Creates and maintains interactive reports to inform institutional decision-making using industry standard tools (current tool is Power BI).

+ Creates and maintains automated hard-copy reports to inform institutional decision-making using industry standard tools (current tool is R).

+ Serves as the office resource for Power BI, R, and website display of reports.

+ Maintains documentation for all reports.

+ Contributes to the review of office reports to validate and ensure consistency in reporting.

+ Serves as an office expert for business intelligence reporting.

Percentage Of Time40

Job Duty CategoryCollaboration, Communication, Documentation

Duty/Responsibility

+ Communicates effectively within the office to understand and meet campus data needs.

+ Communicates effectively with campus stakeholders to understand and meet their data needs; Contributes to university data literacy training and support.

+ Communicates with external stakeholders to provide data needed for university initiatives and adjusts the IRPE data infrastructure to support those initiatives; specifically the PDP data collection

+ Prepares written procedures, documentation, and narratives to ensure consistency over time and across staff.

Percentage Of Time20

Application Details

Special Instructions to Applicants

To apply, please upload a cover letter that addresses the required and preferred job qualifications, a resume, and the contact information for three professional references. References will not be contacted without prior notification to candidates.

This position will remain open until filled. For full consideration, please apply by Sunday, August 17, 2025, 11:59pm (MT).

CSU is committed to full inclusion of qualified individuals. If you are needing assistance or accommodations with the search process, please reach out to the listed search contact.

Please note, applicants may redact information from their application materials that identifies their age, date of birth, or dates of attendance at or graduation from an educational institution.

Conditions of EmploymentPre-employment Criminal Background Check (required for new hires)

Search ContactLindsey Laverentz - [email protected]

EEO

Colorado State University ( CSU ) provides equal employment opportunities to all applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

Background Check Policy Statement

Colorado State University strives to provide a safe study, work, and living environment for its faculty, staff, volunteers and students. To support this environment and comply with applicable laws and regulations, CSU conducts background checks for the finalist before a final offer. The type of background check conducted varies by position and can include, but is not limited to, criminal history, sex offender registry, motor vehicle history, financial history, and/or education verification. Background checks will also be conducted when required by law or contract and when, in the discretion of the University, it is reasonable and prudent to do so.

References Requested

References Requested

Minimum Requested3

Maximum Requested3

Supplemental Questions

Required fields are indicated with an asterisk (*).

+ * The successful candidate must demonstrate U.S. employment authorization by proposed start date; the department will not provide visa sponsorship for this position. Will you have U.S. employment authorization by the proposed start date?

+ Yes

+ No

+ * I understand that this position will be hybrid, with a minimum of two days a week in the office in Fort Collins, CO, and some weeks, more than two days on-site will be required to meet business needs.

+ Yes

+ No

Applicant Documents

Required Documents

+ Cover Letter

+ Resume

Optional Documents