Posting Detail Information

Working TitleBI Report Developer

Position LocationFort Collins, CO

Work LocationPosition qualifies for hybrid/in-office work

Research Professional PositionNo

Posting Number202400006AP

Position TypeAdmin Professional/ Research Professional

Classification TitleProf/Indiv Contrib II

Number of Vacancies1

Work Hours/Week40

Proposed Annual Salary Range60,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 todiversity, equity and inclusion (https://inclusiveexcellence.colostate.edu/about/) , and focus on work-life balance, CSU is where you can thrive, grow, and make a lasting impact.

• For detailed benefit plan information for eligible employees, visithttps://hr.colostate.edu/hr-community-and-supervisors/benefits/benefits-eligibility/andhttps://hr.colostate.edu/prospective-employees/our-perks/.

• For the total value of CSU benefits in addition to wages, visithttps://hr.colostate.edu/total-compensation-calculator/.

• For more information about why Fort Collins is consistently ranked in the top cities to live in, visithttps://hr.colostate.edu/prospective-employees/our-community/.

Desired Start Date02/12/2024

Position End Date (if temporary)

To ensure full consideration, applications must be received by 11:59pm (MT) on01/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 CategoryBI 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 Time70

Job Duty CategoryData 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 Time10

Job Duty CategoryCollaborate

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 Time5

Job Duty CategoryDocumentation

Duty/Responsibility

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

Percentage Of Time5

Job Duty CategoryData 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 Time5

Job Duty CategoryProfessional Development

Duty/Responsibility

• Stays current on relevant technologies through professional development (course work, conferences, trainings etc.).

Percentage Of Time5

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 EmploymentPre-employment Criminal Background Check (required for new hires)

Search ContactLindsey 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. TheOffice of Equal Opportunity (https://oeo.colostate.edu/) 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 theOffice of Civil Rights, Department of Education (https://www2.ed.gov/about/offices/list/ocr/docs/howto.html) .

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 (*).

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

• Yes

• No

Applicant Documents Required Documents

• Resume

• Cover Letter

Optional Documents