Job Listings

IT Developer

Company:
Colorado State University
Job Location:
Fort Collins, Colorado
Category:
Programmer/Analyst
Position Location
Fort Collins, CO

Research Professional Position: No

Posting Number: 202100515AP

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 (CSU) is committed to providing employees with a strong and competitive benefits package that supports you, your health, and your family. Visit CSU's Human Resources website for detailed benefit plan information for permanent full-time and part-time faculty and administrative professional employees in the following University benefit areas. https://hr.colostate.edu/wp-content/uploads/sites/25/2021/01/benefits-summary-afap.pdf.

Desired Start Date
08/16/2021

To ensure full consideration, applications must be received by 11:59pm (MT) on
07/25/2021

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 IT Developer is an administrative professional position reporting directly to the Assistant Director of Institutional Research, Planning, and Effectiveness at Colorado State University. This position is a 12-month full-time appointment, based in Fort Collins, with the potential for flexible work arrangements, including remote work.

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

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


Required Job Qualifications
  • Bachelor's degree plus a minimum of 2 years of experience in writing complex SQL queries and ETL programs using Oracle's client toolsets such as SQL Developer or PL/SQL;
  • Prior experience creating interactive reports and visualizations for constituent use employing tools such as WebFOCUS, Microsoft BI, Tableau, Shiny, Cognos etc.;
  • Demonstrated ability to learn and effectively apply business rules to programming and reporting projects;
  • Proven ability to work independently and as an integral member of a team;
  • Demonstrated effective written communication skills;
  • Demonstrated commitment to data quality and integrity;
  • Demonstrated focus on customer/client in completing projects;
  • Must be available for synchronous communication during normal business hours, typically 8 am to 5 pm Mountain Time.
  • Must be legally authorized to work in the United States by the proposed start date; Institutional Research, Planning, and Effectiveness will not sponsor a visa for this position.
Preferred Job Qualifications
  • Proficiency with Linux and shell scripting;
  • Experience with Oracle performance tuning;
  • Prior professional IT experience working with higher education data;
  • Familiarity with database modeling and Business Intelligence;
  • Experience with Tableau.
Diversity Statement
* Reflecting departmental and institutional values, candidates are expected to have the ability to advance the Department's commitment to diversity and inclusion.

Job Duty Category: Programming

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

Special Instructions to Applicants

For full consideration please submit a cover letter addressing how you meet the minimum and preferred qualifications, a resume, and three references. References will not be contacted without prior notification of candidates. This position is a 12-month full-time appointment, based in Fort Collins, with the potential for flexible work arrangements, including remote work.

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

Search Contact
Laverentz, Lindsey (lindsey.mccormick@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 or expression, or pregnancy and 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/equal access/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 Acting Title IX Coordinator is the Vice President for Equity, Equal Opportunity and Title IX, 123 Student Services Building, Fort Collins, CO. 80523-0160, (970) 491-1715, titleix@colostate.edu.

The Section 504 and ADA Coordinator is the Vice President for Equity, Equal Opportunity and Title IX, 101 Student Services Building, Fort Collins, CO 80523-0160, (970) 491-5836.


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. 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.
This website is part of the HigherEdJobs network.