Logo
CSU Spur

Data Architect and Report Developer

CSU Spur, Fort Collins, Colorado, us, 80523

Save Job

Join to apply for the

Data Architect and Report Developer

role at

CSU Spur 1 day ago Be among the first 25 applicants Join to apply for the

Data Architect and Report Developer

role at

CSU Spur Get AI-powered advice on this job and more exclusive features. Posting Details

Posting Detail Information

Working Title Data Architect and Report Developer Position Location Fort Collins, CO Work Location Position qualifies for hybrid/in-office work Research Professional Position No Posting Number 202501047AP Position Type Admin Professional/ Research Professional Classification Title Prof/Indiv Contrib II Number of Vacancies 1 Work Hours/Week 40 Proposed Annual Salary Range $60,000 - $90,000 Employee Benefits

Colorado State University is not just a workplace; its a thriving community thats 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. Explore the additional perks of working at CSU here. For the total value of CSU benefits in addition to wages, use our compensation calculator. Lastly, click here for more information about why Fort Collins is consistently ranked in the top cities to live in!

Desired Start Date 09/01/2025 Position End Date (if temporary) To ensure full consideration, applications must be received by 11:59pm (MT) on 08/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

Bachelors 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

Masters 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 Category Data 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 IRs website.

Percentage Of Time 40 Job Duty Category Report 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 Time 40 Job Duty Category Collaboration, 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 Time 20

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 Employment Pre-employment Criminal Background Check (required for new hires) Search Contact Lindsey Laverentz - lindsey.laverentz@colostate.edu 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 Requested 3 Maximum Requested 3

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

Seniority level

Seniority level

Entry level Employment type

Employment type

Temporary Job function

Job function

Engineering and Information Technology Industries

Education Referrals increase your chances of interviewing at CSU Spur by 2x Sign in to set job alerts for Data Architect roles.

Fort Collins, CO $125,000.00-$150,000.00 2 weeks ago Fort Collins, CO $125,000.00-$150,000.00 2 weeks ago Loveland, CO $154,400.00-$286,700.00 2 months ago Fort Collins, CO $90,000.00-$110,000.00 1 month ago Fort Collins, CO $35.00-$45.00 2 weeks ago IT Senior Data Engineer (SAP, Data Warehousing and Modeling Focus)

Loveland, CO $75,000.00-$110,000.00 2 weeks ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr