Fort Collins, Colorado Employee Earnings
An analysis of 2015 Fort Collins CO Employee Earnings
The data pulled from the Fort Collins Open Book website is available in the data folder. There were variables added to the dataset:
serviceArea: Using the organizational chart, the the
serviceAreawas added to organize the service units and departments into a better structure.
year: To tidy the data for future use, a
yearvariable of 2015 was added to the data.
hourlyWage: In 2015, The Associated Press reported that the minimum wage for Colorado was $8.23. Under the assumption that any employee earning more than $17,506/year would be full time, we calculated their possible hourly salary. Many employees are salaried, so this is more for informational purposes.
status: The status variable is used to help categorize employees into different buckets. Employees earning more than the assumed $8.23/hour would be labled as
full timewhile anyone earning less would be
part timeor contract.
- Please note, the following entites are not part of the City of Fort Collins and have been removed from the analysis. The City has a partnership and intergovernmental agreement with each entity and they provide services to them, such as HR and Finance, so their data is in the system.
- Downtown Development Authority
- Library District
- Poudre Fire Authority
- Urban Renewal Authority
As of 2015, there are 11 service areas with a total of 1416 employees.
|city manager||city manager’s office||258704.9||2015||city manager||124.38||full time|
|deputy city manager||city manager’s office||174086.5||2015||city manager||83.70||full time|
|chief of police||office of the chief||169963.8||2015||police services||81.71||full time|
|chief financial officer||finance administration||163179.2||2015||financial services||78.45||full time|
|assistant city manager||city manager’s office||159519.0||2015||city manager||76.69||full time|
|assistant city manager||city manager’s office||156335.9||2015||city manager||75.16||full time|
|city attorney||city attorney’s office||139572.6||2015||city attorney||67.10||full time|
|police assistant chief||office of the chief||134733.9||2015||police services||64.78||full time|
|chief information officer||information technology||130630.2||2015||information and employee services||62.80||full time|
|systems analyst||information technology||128388.3||2015||information and employee services||61.73||full time|
Table: Overview by Service Area
|information and employee services||2||57||98||65725.87|
|deputy city manager||1||6||6||57108.05|
|community and operation services||6||103||255||47498.33|
|planning development & transportation||9||122||391||37477.48|
|Department Analysis - Read the quick analysis by service area here.|
|Community & Operation Services|
|Deputy City Manager|
|Information & Employee Services|
|Planning, Development & Transportation|