Military Spouse Connection Jobs

Posting Detail Information

Working TitleBI Developer

Position LocationFort Collins, CO

Work LocationPosition qualifies for hybrid/in-office work

Research Professional PositionNo

Posting Number202401216AP

Position TypeAdmin Professional/ Research Professional

Classification TitleProf/Indiv Contrib II

Number of Vacancies

Work Hours/Week40

Proposed Annual Salary Range$65,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.

• Review our detailed benefits information here. (https://hr.colostate.edu/wp-content/uploads/sites/25/2021/01/benefits-summary-afap.pdf)

• Explore the additional perks of working at CSU here.

• For the total value of CSU benefits in addition to wages, use our compensation calculator (https://hr.colostate.edu/total-compensation-calculator/) .

• Lastly, click here for more information about why Fort Collins is consistently ranked in the top cities to live in (https://hr.colostate.edu/prospective-employees/our-community/) !

Desired Start Date

Position End Date (if temporary)

To ensure full consideration, applications must be received by 11:59pm (MT) on07/28/2024

Description of Work Unit

Founded in 1870, Colorado State University is among the nation’s leading research universities and enrolls approximately 32,000 undergraduate, graduate, and professional students. Located an hour north of the Denver metro area, Fort Collins is a vibrant community of approximately 157,000 residents that offers the convenience of a small town with all the amenities of a large city. Fort Collins is situated on the Front Range of the Rocky Mountains with views of 14,000 foot peaks, and offers access to numerous cultural, recreational, and outdoor opportunities.

The College of Business at Colorado State University is an AACSB accredited business school which enrolls more than 3,800 undergraduate students in six business concentrations and the business administration minor and is the largest undergraduate major on campus. In addition, the college enrolls approximately 1,500 students in five different MBA programs and three department-based graduate programs in the Master of Accountancy, the Master of Computer Information Systems, and the Master of Financial Risk Management. The mission of the Information Technology Department in the College of Business is to develop a robust and state of the art technical platform which propels the college’s programs toward success.

Position Summary

The BI Developer position is a full-time special 12-month appointment with an initial one-year term, renewable contingent upon available funding, continued business needs, and satisfactory performance in the role. This position is within the Business Solutions team in the College of Business IT Department reporting to the CRM Systems and Analytics Manager. This position will be designing, developing, documenting, and configuring custom reports and visualizations, and writing and editing complex SQL queries to fulfill users’ requests. The position will master college specific data and business acumen to develop and maintain databases to meet varying stakeholder needs and requests. Additionally, this position will master new technologies and keep the data infrastructure up to date to meet the needs of the business and implement them into the College IT infrastructure and follows data security and data management best practices. This position will work very closely with departments, business units, and users in the college to satisfy business requirements, train users, and support daily work. A successful candidate is required to have demonstrated proficient SQL coding experience, knowledge, and skillsets as well experience developing and will be a master of the Colleges data sets and business acumen. This position is eligible for hybrid work arrangements upon supervisor approval. The IT Team is committed to hiring employees who provide excellent customer service. Our employees act with a high level of integrity and take responsibility for their words and actions. The IT Team employees strive to respect and appreciate each individual’s differences, and to work effectively with all people and their diverse backgrounds. We support candid and honest interactions, which respect other points of view, and are sensitive to communication differences. We achieve organizational goals through inclusive problem solving, planning, and decision making. Community partnerships are included in this effort.

The successful candidate must be legally authorized to work in the United States by the proposed start date; the IT department will not provide visa sponsorship for this position.

Required Job Qualifications

• Bachelor’s degree in Computer Information Systems or related field

• 3+ years’ experience in BI development creating BI / interactive reports and visualizations for constituents using tools such as Oracle SQL , MS Power BI, SQL database server, etc.

• 3+ years demonstrated experience writing complex SQL queries

• Demonstrated ability to learn and effectively apply business rules to data reporting and BI projects

• Strong customer service, communication, critical thinking, and problem-solving skills

• The successful candidate must be legally authorized to work in the United States by the proposed start date. The department will not sponsor a visa for this position

Preferred Job Qualifications

• Proven ability to work independently and as an integral member of a team

• Experience with Higher Ed business understanding and experience in building varying reports and dashboards highly desired

• Experience creating advanced SQL queries

• Experience employing strong communication and collaboration skills to ensure timely completion of projects

• Demonstrated commitment to data quality and integrity

• Demonstrated focus on customer/client needs in completing projects

• Prior professional IT experience working with higher education data

• Familiarity with database modeling and Business Intelligence

• Experience with Power BI

• ITIL Foundation Certified.

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 Duties

Job Duty CategoryBI and Data Projects

Duty/Responsibility

• Serves as a subject matter expert for the College’s data structure and maintains a strong level of business acumen.

• Builds and maintains BI projects with deep business understanding for key users and important business insights in College of Business. Maintains working knowledge of institutional policies, practices, data systems, and operational definitions to identify data anomalies.

• Works with key stakeholders to translate business and data questions into insightful, meaningful BI project development that meet end-user needs.

• Independently writes both simple and complex SQL code, applying specific business rules and acumen to complete reoccurring and ad-hoc requests. Determines how to best extract data from data sources to fulfill project objectives.

• Writes complex SQL queries to extract, transform and load data from the university source systems into our databases, and ensure they are properly maintained following best practices

• Maintains, creates, and modifies dashboards and reports to satisfy requests and stakeholder needs. – Blend data from our data sources to provide life cycle views.

• Builds and maintains the data flow for the BI projects to ensure the data is up to date and accurate for the reports and dashboards and continuously works to improve data modeling capabilities.

• Designs and builds the database to allow for flexibility and scalability.

• Quickly adapts and displays a sense of urgency in a fast-paced work environment to ensure timely delivery of work products.

• Performs rigorous testing, auditing, and data validation processes to ensure data integrity, quality, and accuracy of deliverables.

• Exercise proper security measures as well as personal integrity for handling of data.

• Manage data security, as well as necessary user permissions and access to the data.

• Demonstrates superior customer service and communication skills in all stakeholder interactions.

• Prepares written documentation as needed.

Percentage Of Time90

Job Duty CategoryProfessional Development and Innovation

Duty/Responsibility

• Researches and stays current on relevant BI tools, technologies, and solutions through professional development, training, courses, journals, etc.

• Seeks innovative ways to improve data modeling capabilities

• Identifies opportunities for professional training and development

Percentage Of Time10

Application Details

Special Instructions to Applicants

Applicants will be expected to provide:

• A cover letter indicating interest in the position at Colorado State University along with a description of the applicant’s ability to meet the position’s required and preferred qualifications

• A resume

• Contact information of three references. References will not be contacted without prior notification of candidates.

For full consideration, applications should be received no later than 11:59pm MST July 28, 2024 to:https://jobs.colostate.edu/postings/147607however, applications will be accepted until the position is filled.

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.

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

Search ContactSarah Hill, sarah.j.hill@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 (*).

• • Do you have a bachelor’s degree in Computer Information Systems or related field?

• Yes

• No

• • Do you have three or more years of experience in BI development creating BI / interactive reports and visualizations for constituents using tools such as Oracle SQL, MS Power BI, SQL database server, etc.?

• Yes

• No

• • Do you have three or more years of demonstrated experience writing complex SQL queries?

• Yes

• No

• • Do you have demonstrated ability to learn and effectively apply business rules to data reporting and BI projects?

• Yes

• No

• • Do you have strong customer service, communication, critical thinking, and problem-solving skills?

• Yes

• No

• • The successful candidate must be legally authorized to work in the United States by the proposed start date. The department will not sponsor a visa for this position. Will you be legally authorized to work by the proposed start date?

• Yes

• No

• • Have you read the position summary, and do you understand that this position is a special 12-month appointment with an initial one-year term?

• Yes

• No

Applicant Documents

Required Documents

• Cover Letter

• Resume

Optional Documents