Skip to Main Content

BI Report Developer

Please see Special Instructions for more details.

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. 

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.

References will not be contacted without prior notification to candidates.

Posting Details

Posting Detail Information

Working Title BI Report Developer
Position Location Fort Collins, CO
Work Location Position qualifies for hybrid/in-office work
Research Professional Position No
Posting Number 202400006AP
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- 75,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, commitment to diversity, equity and inclusion, and focus on work-life balance, CSU is where you can thrive, grow, and make a lasting impact.

Desired Start Date 02/12/2024
Position End Date (if temporary)
To ensure full consideration, applications must be received by 11:59pm (MT) on 01/22/2024
Description of Work Unit
As part of the Office of the Provost and Executive Vice President, the Office of Institutional Research, Planning and Effectiveness provides vision and leadership to the reporting, institutional research, assessment, strategic planning and accreditation activities of the institution.
Position Summary
This is a regular 12-month, full-time (or part-time considered) , administrative professional position reporting directly to the Director of Institutional Research, Planning and Effectiveness at Colorado State University. This position is based in Fort Collins, with the potential for flexible work arrangements, including remote work. In-person preferred; hybrid and fully remote considered. This individual must be available for synchronous communication during normal business hours, typically 8 am to 5 pm Mountain Time.

The position has responsibility for a range of duties within the Office with a primary focus on 1) designing, developing, documenting, and configuring custom web-based reports and visualizations, 2) writing/editing complex SQL programming coding for use by others within the office.

The position is expected to use independent judgement to make sound decisions with limited supervision.

Required Job Qualifications
• Bachelor’s degree in related field
• At least one year experience creating BI / interactive reports and visualizations for constituent use employing tools such as WebFOCUS, Microsoft Power BI, Tableau, Shiny, Cognos etc
• Prior experience in writing complex SQL queries using Oracle’s client toolsets such as SQL Developer or PL/SQL
• Demonstrated ability to learn and effectively apply business rules to programming and reporting projects

Preferred Job Qualifications
• Master’s degree in a related field
• Proven ability to work independently and as an integral member of a team
•Experience employing strong communication and collaboration skills to maintain effective team structure and ensure timely completion of projects
• Demonstrated commitment to data quality and integrity
• Demonstrated focus on customer/client in completing projects
• Prior professional IT experience working with higher education data or in an Institutional Research office
• Familiarity with database modeling and Business Intelligence;
• Experience with Power BI.

Diversity Statement
Demonstrated knowledge of, and relevant ability with, culturally diverse communities among potential target and constituent populations.
Essential Duties

Job Duty Category BI Reporting
Duty/Responsibility
• Applies professional discretion to write both simple and complex SQL code that that applies specific business rules to extract data from an Oracle database;
• With limited supervision, writes SQL to support other members of the office in completing ad hoc requests that inform institutional decision-making and/or meet external reporting demands;
• Writes complex SQL and PL/SQL to extract, transform and load data from the university source systems and into an Oracle database;
• Applies data visualization concepts and techniques to design and develop business intelligence web-based reports that meet end-user needs;


Percentage Of Time 70
Job Duty Category Data Auditing and Validation
Duty/Responsibility
• Employs a working knowledge of institutional policies, practices, data systems, and operational definitions to identify data anomalies;
• Performs rigorous testing and data validation processes to ensure data integrity and quality;
• Analyzes data anomalies to assist in root cause determination and recommends solution(s);
• Communicates effectively and professionally with data stewards/curators across campus about issues requiring correction.

Percentage Of Time 10
Job Duty Category Collaborate
Duty/Responsibility
• Works with end-users to ensure proper, smooth integration of reports and data extracts;
• With limited supervisor review, works constructively with other staff in the office to provide data extracts that are appropriate for each unique project.

Percentage Of Time 5
Job Duty Category Documentation
Duty/Responsibility
• Prepares written procedures, documentation, and narratives to ensure consistency over time and across staff.
Percentage Of Time 5
Job Duty Category Data Submission and Surveys
Duty/Responsibility
• Submits data to outside entities and/or assists with external survey reporting by writing complex SQL code to extract data from an Oracle database.
Percentage Of Time 5
Job Duty Category Professional Development
Duty/Responsibility
• Stays current on relevant technologies through professional development (course work, conferences, trainings etc.).
Percentage Of Time 5
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. 

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.

References will not be contacted without prior notification to candidates.
Conditions of Employment Pre-employment Criminal Background Check (required for new hires)
Search Contact Lindsey Laverentz - lindsey.laverentz@colostate.edu
EEO Statement
Colorado State University is committed to providing an environment that is free from discrimination and harassment based on race, age, creed, color, religion, national origin or ancestry, sex, gender, disability, veteran status, genetic information, sexual orientation, gender identity/expression, or pregnancy in its employment, programs, services and activities, and admissions, and, in certain circumstances, marriage to a co-worker. The University will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. Colorado State University is an equal opportunity and equal access institution and affirmative action employer fully committed to achieving a diverse workforce and complies with all Federal and Colorado State laws, regulations, and executive orders regarding non-discrimination and affirmative action. The Office of Equal Opportunity is located in 101 Student Services.

The Title IX Coordinator is the Director of the Office of Title IX Programs and Gender Equity, 123 Student Services Building, Fort Collins, CO 80523-0160, (970) 491-1715, titleix@colostate.edu.

The Section 504 and ADA Coordinator is the Director of the Office of Equal Opportunity, 101 Student Services Building, Fort Collins, CO 80523-0160, (970) 491-5836, oeo@colostate.edu.

The Coordinator for any other forms of misconduct prohibited by the University’s Policy on Discrimination and Harassment is the Vice President for Equity, Equal Opportunity and Title IX, 101 Student Services Building, Fort Collins, Co. 80523-0160, (970) 491-5836, oeo@colostate.edu.

Any person may report sex discrimination under Title IX to the Office of Civil Rights, Department of Education.
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 (*).

  1. * Are you available to work normal business hours between 8:00am and 5:00pm Mountain Time?
    • Yes
    • No

Applicant Documents

Required Documents
  1. Resume
  2. Cover Letter
Optional Documents