Colorado State University
DSA BI Report Developer
Colorado State University, Fort Collins, Colorado, us, 80523
Posting Details
Position Information
Classification Title Temporary Hourly
Employment Category Temporary
Is this an Hourly position? Yes
Work Hours/Week 0-40
Overtime Eligible? Yes
Position Location Fort Collins, CO 80523
Does this position qualify for hybrid or remote work? Yes
Description of Work Unit
TheDivision of Student Affairs (DSA) fosters an inclusive campus community that supports students and staff holistically in the development of their unique potential. We collaborate across the University to inspire and empower students to be active learners inside and outside the classroom, successful graduates, and engaged global citizens. We support student success through an array of services and resources including housing, dining, student orientation, recreation, student government, student organizations, and legal, career, transition, health, well-being, and crisis services. In addition to student services, we also connect with parents and families, host conferences and events, manage the Mountain Campus, provide professional development opportunities for staff, and partner with a number of businesses in the student center. The Division employs 800 career staff, 2,000 student and hourly staff, and manages a budget of over $180 million.
The Office of the Vice President for Student Affairs is the executive management unit for the Division of Student Affairs.
As part of the Office of the Provost and Executive Vice President, the Office of Institutional Research, Planning and Effectiveness provides vision and leadership for activities related to institutional research and reporting, academic program review/planning, and accreditation.
Search Contact Email kacee.jarnot@colostate.edu
Position Summary
This is a 9-month temporary non-student hourly administrative professional position co-reporting to the Director of Assessment in the Division of Student Affairs and the Senior Research Analyst in Institutional Research, Planning and Effectiveness (IR) at Colorado State University. This position is 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) designing, developing, documenting, and configuring custom web-based reports and visualizations, 2) writing/editing complex SQL programming coding for report extracts, 3) managing the validation and documentation for co-curricular data entered through systems outside of the SIS; all in service of students' success at CSU. The position is expected to use independent judgement to make sound decisions with limited supervision.
This position has limited supervision with only periodic review of the coding and reports. It requires the use of professional discretion to apply programming standards and rules. In addition, it may make recommendations regarding project prioritization, tools, and operational definitions. Its impact is largely isolated to the department level but may also impact the University more broadly. The reports written and/or data extracted through SQL programming against the Oracle database will be provided to executive leadership, college deans, other campus constituents and external reporting agencies.
Position Minimum Qualifications Bachelor's degree in related field Experience creating BI / interactive reports and visualizations for constituent use employing tools such as WebFOCUS, Microsoft Power BI, Tableau, Shiny, Cognos, etc Experience in writing complex SQL queries using Oracle's client toolsets such as SQL Developer or PL/SQL Demonstrated ability to effectively apply business rules to programming and reporting projects Must be available for synchronous communication during normal business hours, typically 8 am to 5 pm Mountain Time The successful candidate must be legally authorized to work in the U.S. by proposed start date Preferred 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 building dashboards in Power BI platform Posting Details
Working Title DSA BI Report Developer
Posting Number 202400797T
Department Vice President for Student Affairs Office
Salary Range $48,000-$52,027
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.
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 ! Close Date 01/05/2025
Special Instructions to Applicants
A complete application will consist of a cover letter addressing qualifications, a resume, and the names of three professional contacts. References will not be contacted without prior notification to candidates. 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.
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.
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.
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 .
Diversity Statement
Reflecting departmental and institutional values, candidates are expected to have the ability to advance the Department's commitment to diversity and inclusion.
Essential Job Duties
Job Duty Category BI Reporting for Division of Student Affairs Units
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; Applies data visualization concepts and techniques to design and develop business intelligence web-based reports that meet DSA end-user needs; Percentage Of Time 40
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 DSA data integrity and quality; Analyzes DSA data anomalies to assist in root cause determination and recommends solution(s); Communicates effectively and professionally with data stewards/curators across the Division of Student Affairs about issues requiring correction. Percentage Of Time 50
Job Duty Category Collaborate
Duty/Responsibility
Works with DSA end-users to ensure proper, smooth integration of reports and data extracts, including platform use training; With limited supervisor review, works constructively with other IR staff to provide data extracts that are appropriate for each unique project in the Division of Student Affairs. Percentage Of Time 5
Job Duty Category Documentation
Duty/Responsibility
Prepares written procedures, documentation, user guides and narratives to ensure consistency over time and across DSA staff.
Percentage Of Time 5
References
Minimum References Required 3
Maximum References Required 3
Position Information
Classification Title Temporary Hourly
Employment Category Temporary
Is this an Hourly position? Yes
Work Hours/Week 0-40
Overtime Eligible? Yes
Position Location Fort Collins, CO 80523
Does this position qualify for hybrid or remote work? Yes
Description of Work Unit
TheDivision of Student Affairs (DSA) fosters an inclusive campus community that supports students and staff holistically in the development of their unique potential. We collaborate across the University to inspire and empower students to be active learners inside and outside the classroom, successful graduates, and engaged global citizens. We support student success through an array of services and resources including housing, dining, student orientation, recreation, student government, student organizations, and legal, career, transition, health, well-being, and crisis services. In addition to student services, we also connect with parents and families, host conferences and events, manage the Mountain Campus, provide professional development opportunities for staff, and partner with a number of businesses in the student center. The Division employs 800 career staff, 2,000 student and hourly staff, and manages a budget of over $180 million.
The Office of the Vice President for Student Affairs is the executive management unit for the Division of Student Affairs.
As part of the Office of the Provost and Executive Vice President, the Office of Institutional Research, Planning and Effectiveness provides vision and leadership for activities related to institutional research and reporting, academic program review/planning, and accreditation.
Search Contact Email kacee.jarnot@colostate.edu
Position Summary
This is a 9-month temporary non-student hourly administrative professional position co-reporting to the Director of Assessment in the Division of Student Affairs and the Senior Research Analyst in Institutional Research, Planning and Effectiveness (IR) at Colorado State University. This position is 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) designing, developing, documenting, and configuring custom web-based reports and visualizations, 2) writing/editing complex SQL programming coding for report extracts, 3) managing the validation and documentation for co-curricular data entered through systems outside of the SIS; all in service of students' success at CSU. The position is expected to use independent judgement to make sound decisions with limited supervision.
This position has limited supervision with only periodic review of the coding and reports. It requires the use of professional discretion to apply programming standards and rules. In addition, it may make recommendations regarding project prioritization, tools, and operational definitions. Its impact is largely isolated to the department level but may also impact the University more broadly. The reports written and/or data extracted through SQL programming against the Oracle database will be provided to executive leadership, college deans, other campus constituents and external reporting agencies.
Position Minimum Qualifications Bachelor's degree in related field Experience creating BI / interactive reports and visualizations for constituent use employing tools such as WebFOCUS, Microsoft Power BI, Tableau, Shiny, Cognos, etc Experience in writing complex SQL queries using Oracle's client toolsets such as SQL Developer or PL/SQL Demonstrated ability to effectively apply business rules to programming and reporting projects Must be available for synchronous communication during normal business hours, typically 8 am to 5 pm Mountain Time The successful candidate must be legally authorized to work in the U.S. by proposed start date Preferred 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 building dashboards in Power BI platform Posting Details
Working Title DSA BI Report Developer
Posting Number 202400797T
Department Vice President for Student Affairs Office
Salary Range $48,000-$52,027
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.
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 ! Close Date 01/05/2025
Special Instructions to Applicants
A complete application will consist of a cover letter addressing qualifications, a resume, and the names of three professional contacts. References will not be contacted without prior notification to candidates. 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.
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.
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.
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 .
Diversity Statement
Reflecting departmental and institutional values, candidates are expected to have the ability to advance the Department's commitment to diversity and inclusion.
Essential Job Duties
Job Duty Category BI Reporting for Division of Student Affairs Units
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; Applies data visualization concepts and techniques to design and develop business intelligence web-based reports that meet DSA end-user needs; Percentage Of Time 40
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 DSA data integrity and quality; Analyzes DSA data anomalies to assist in root cause determination and recommends solution(s); Communicates effectively and professionally with data stewards/curators across the Division of Student Affairs about issues requiring correction. Percentage Of Time 50
Job Duty Category Collaborate
Duty/Responsibility
Works with DSA end-users to ensure proper, smooth integration of reports and data extracts, including platform use training; With limited supervisor review, works constructively with other IR staff to provide data extracts that are appropriate for each unique project in the Division of Student Affairs. Percentage Of Time 5
Job Duty Category Documentation
Duty/Responsibility
Prepares written procedures, documentation, user guides and narratives to ensure consistency over time and across DSA staff.
Percentage Of Time 5
References
Minimum References Required 3
Maximum References Required 3