Web and Database Developer

Colorado State University
Fort Collins, Colorado, United States
04 Feb 2018
End of advertisement period
04 Mar 2018
Contract Type
Full Time

Description of Work Unit

The Cooperative Institute for Research in the Atmosphere (CIRA) at Colorado State University (CSU) is a multi-million dollar research organization located on CSU’s Foothills Campus in Fort Collins, Colorado. CIRA is a cooperative institute (CI) that is also a research department within CSU’s College of Engineering, in partnership with the Department of Atmospheric Science. Its vision is to conduct interdisciplinary research in the atmospheric sciences by entraining skills beyond the meteorological disciplines, exploiting advances in engineering and computer science, facilitating transitional activity between pure and applied research, leveraging both national and international resources and partnerships, and assisting the National Oceanic and Atmospheric Administration (NOAA), CSU, the State of Colorado, and the Nation through the application of our research to areas of societal benefit. Expanding on this Vision, our Mission is to serve as a nexus for multi-disciplinary cooperation among CI and NOAA research scientists, University faculty, staff and students in the context of NOAA-specified research theme areas in satellite applications for weather/climate forecasting. Important bridging elements of the CI include the communication of research findings to the international scientific community, transition of applications and capabilities to NOAA operational users, education and training programs for operational user proficiency, outreach programs to K-12 education and the general public for environmental literacy, and understanding and quantifying the societal impacts of NOAA research.

The National Park Service (NPS) is collocated at the Cooperative Institute for Research in the Atmosphere (CIRA) at Colorado State University (CSU) and collaborates with other federal and state organizations to monitor air quality data in national parks and wilderness areas. The Western Regional Air Partnership (WRAP) is a voluntary partnership of states, tribes, federal land managers, local air agencies, and the US EPA whose purpose is to understand current and evolving regional air quality issues in the West. One of the most important of these issues is the effect of regional haze (visibility-impairing air pollution) on the scenic vistas of federally-protected ecosystems in the West, such as National Parks and Wilderness Areas, which are designated as “Class I areas” by the EPA’s Regional Haze Rule (RHR). The RHR requires each state, in coordination with the Environmental Protection Agency, the National Park Service, U.S. Fish and Wildlife Service, the U.S. Forest Service, and other interested parties, to develop and implement air quality implementation plans to reduce the pollution that causes visibility impairment in such protected areas. To help support members in general and states in particular in their efforts to assure the reasonable progress goals as identified in the standards set by the RHR, the WRAP develops, maintains, and shares databases, supports technical analyses, and provides access to air quality datasets and results from various sources to produce consistent, comparable, and complete results for use by WRAP members.

The principal outlet for these datasets and results is the Technical Support System (TSS), which was developed by the WRAP to support the first round of State RHR implementation plans completed over the past 10 years. Comprehensive periodic revisions to the initial RHR plans from each state are currently due in 2021, 2028, and every 10 years thereafter. Each round of revisions requires updated air quality data and atmospheric modeling results, and a parallel goal of the WRAP during each round of updates is to incrementally improve the TSS data analysis and exploration tools according to improvements in web technologies and advances in the understanding of Western air quality issues. The individual in this positon will be a full-stack Microsoft .Net developer who will assist with and help lead the update and ongoing development of the TSS databases, website, online tools, and associated software systems.

Position Summary

The individual in this position is a full-stack software developer that supports the data visualization and analysis operations of the Western Regional Air Partnership (WRAP) and its member states. He/She will work primarily with the Microsoft development stack (SQL Server, Visual Studio, .Net Framework) on the server side and with current web technologies (HTML5, CSS3, JavaScript) on the client side to develop a website and suite of interactive online tools for displaying and analyzing air quality data in charts, graphs, reports, and maps.

Required Job Qualifications

  • Bachelor’s Degree;
  • Three years of experience working with Computer Information Systems or otherwise working in the Computer Science field;
  • Demonstrated experience developing real-world software applications as an integral member of a multi-faceted development team;
  • Demonstrated proficiency with current software development technologies and practices.

Preferred Job Qualifications

  • Five or more years of experience working with Computer Information Systems or otherwise working in the Computer Science field;
  • Proficiency with leading web development technologies such as HTML5, CSS3, JavaScript, jQuery;
  • Experience managing and designing relational database management systems such as SQL Server;
  • Experience using Microsoft and Microsoft .Net development technologies such as Visual Studio and .Net framework;
  • Experience or interest in working with geographical information systems such as GIS and preferably, ESRI;
  • Experience with scientific datasets such as air quality, water quality, meteorological, or satellite data;
  • Excellent verbal and written communications skills.

Diversity Statement

Ability to advance the department’s commitment to diversity and inclusion through research, teaching and outreach with relevant programs, goals and activities.

Essential Duties

Job Duty Category System Design & Architecture Duty/Responsibility

  • Coordinate and plan TSS development activities with the project manager and lead developer;
  • Propose technical solutions for meeting system requirements based on feasibility, cost, and maintainability;
  • Work with the lead developer to improve and extend existing software architecture and design;
  • Research new techniques and technologies for improving existing software and developing new tools.

Percentage Of Time 10 Job Duty Category Website & Software Development Duty/Responsibility

  • Develop a new TSS website using Microsoft .Net framework development technologies on the server side and current web technologies on the client side;
  • Use and extend a core software framework using current technologies and sound development practices;
  • Develop backend software routines to import, process, and manage incoming air quality data;
  • Develop web pages and data visualization tools for the TSS website;
  • Test, debug, refine, and maintain the TSS website, software components, and supporting tools.

Percentage Of Time 40 Job Duty Category Database Development & Administration Duty/Responsibility

  • Understand, utilize, and help manage existing TSS SQL Server databases;
  • Leverage and extend the existing TSS SQL Server databases for use with the new website and data;
  • Import, validate, and manage the data and metadata for the TSS database.

Percentage Of Time 40 Job Duty Category Collaboration & Reporting Duty/Responsibility

  • Serve as the day-to-day technical contact for the WRAP Technical Support System;
  • Collaborate with technical and project teams to determine system requirements;
  • Prepare and present periodic reports to the TSS steering committee;
  • Prepare and present periodic reports/presentations to the WRAP Committees and Work Groups.

Percentage Of Time 10

Application Details

Special Instructions to Applicants

NOTE: In your cover letter, please specifically address the required and preferred qualifications of this position. A cover letter that fails to address the required and preferred qualifications of this position may not be further considered after review by the search committee.

References may be contacted immediately and without further notification to the candidate.

Conditions of Employment

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

Search Contact linn.barrett@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 Title IX Coordinator is the Executive Director of the Office of Support and Safety Assessment, 123 Student Services Building, Fort Collins, CO 80523 -2026, (970) 491-7407.

The Section 504 and ADA Coordinator is the Associate Vice President for Human Capital, Office of Equal Opportunity, 101 Student Services Building, Fort Collins, CO 80523-0160, (970) 491-5836.

Background Check Policy Statement

Colorado State University (CSU) 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 (felony and misdemeanor) history, sex offender registry, motor vehicle history, financial history, and/or education verification. Background checks will be conducted when required by law or contract and when, in the discretion of the university, it is reasonable and prudent to do so.