Data Analyst jobs at City of Boise

The Sanitation Data Analyst maintains the City's Sanitation Department asset management system. The Sanitation Data Analyst will use GIS, and other software tools to organize, standardize, and analyze asset data to recommend strategies to build and maintain asset billing and routing systems. The position provides critical input to the development of routing plans utilized by the department. The position is responsible to ensure data integrity, multi-level data analysis and specialized reports related to the City's Sanitation Department. Analyzes, develops, implements, and maintains software solutions designed to increase productivity, workflow, capabilities, efficiency, and effectiveness of programs, services, and administration. Work involves meeting with users, analyzing and defining system needs; using software programs and applications; and implementing, documenting, and maintaining applications. Work also involves performing project management for assigned applications projects. The job requires knowledge of the methods, practices and techniques of data quality control and assurance, as well as data collection and records management, including but not limited to, assets, inventory and work history of the Sanitation Department. The job maintains the database setup for workflow, security permissions and operations of the work order program and routing system. The job requires the ability to maintain a collaborative and cooperative working relationship with elected and appointed officials, other City employees, other organizations, and the general public. The work environment includes an office and field environment. The field environment may include exposure to adverse weather conditions and working in high traffic areas. The noise level is generally moderate. ESSENTIAL DUTIES AND RESPONSIBILITIES * Under general supervision performs a full range of asset management functions for the Sanitation Department; serves as a system expert responsible for analyzing, implementing and improving work flow processes for asset management tasks. Standardizes Sanitation Department work order forms and databases, and customizes reports from the database. * Manages and maintains specialized computerized data base systems for work orders, daily route sequencing, cart and container inventory and billing integration. . Monitors, tracks and updates information being imported and exported through the system's integration methods. Assumes the responsibility for collecting, mapping, editing, processing, and distributing data required by the department and is responsible for the validity of data contained in the databases. * Utilizes specialized computer database software and systems and other computer software to provide data information and reports for daily operations, special projects, and annual budgeting. Serves as a liaison for asset management vendors for acquisition, installation, operation and maintenance and troubleshooting of related resources; and determines and executes the appropriate work flow sequence for completing tasks. Assists in the design, development and implementation of computerized data files within the department. * Provides support and software solutions for Sanitation's programs and applications, which include software and applications developed in-house, and/or applications purchased from vendors (i.e., intra-agency financial applications); performs work, which involves facets of new and existing applications, from development and installation through maintenance, troubleshooting and upgrades/modifications. * Technical support and troubleshooting programs/applications and devices to ensure systems operate as required. Provides training, support, and assistance to users; responds to user demands, questions, and requests for assistance; provides information and explanations regarding software and applications. Troubleshoots assigned programs/applications; resolves software applications, operating systems, and network issues that prevent clients from accessing and utilizing information technology. Initiates and participates in system upgrades. * Designs and programs reports utilizing standard reporting tools; Fully tests new reports to assess their impact on system. * Tests new software applications and/or modifications/upgrades, which meet identified needs; prepares and maintains system/program documentation; tests prototype applications and works through operational problems; installs and configures software/applications; establishes user access levels, system security protocols; designs, and will possibly write and maintain SQL script programs. * Changes the configuration of information systems in accordance with direction/modeling associated with/driven by business processes; fully tests changed performance of the system and the impact on the remainder of the systems, documenting configuration changes in accordance with standards for documenting process flows; communicates and coordinates changes with production staff. * Manage, maintain and map collection points used for sanitation service accounts. * Performs other duties as assigned. Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this position at any time. * Performs all work duties and activities in accordance with City policies, procedures, and safety practices. ACCEPTABLE EXPERIENCE, TRAINING, LICENSES AND/OR CERTIFICATIONS * High school diploma or GED; and * Associates Degree or two (2) or more years of post-high school technical training is preferred; * Two years of progressive experience and proficiency with asset and work order management systems; * Idaho driver's license required. An equivalent combination of education and experience that provides the required skills, knowledge and abilities to successfully perform the essential functions of the position may be considered. CLASSIFICATION REQUIREMENTS The requirements listed below are representative of the minimum knowledge, skill, and/or ability required for an individual to satisfactorily perform each essential duty satisfactorily and be successful in the position. Knowledge of: * Principals of global positioning systems and use of aerial photography and satellite imaging; * Predictive maintenance programs and condition monitoring for work order and asset management programs; * Computerized data compilation and conversion techniques; * Record keeping principles and practices; * Operation of standard office equipment; * Operation of a personal computer and job-related software applications; * Communicating effectively in oral and written forms. Skill and Ability to: * Understand current trends and technology used in the solid waste and recycling industry. * Maintain accurate and interrelated database records; * Address inefficiencies to improve daily functions and provide enhancements to existing processes and tools; * Understand and follow oral and written directions; * Use initiative and independent judgement within established procedural guidelines; * Prepare clear and well-organized written and oral reports; * Operate standard office equipment; * Operate a personal computer and job-related software applications; * Maintain a collaborative and cooperative working relationship with elected and appointed officials, other City employees, and the public; * Maintain a professional demeanor at all times; * Communicate effectively in the English language at a level necessary for efficient job performance; * Complete assignments in a timely fashion; understand and comply with all rules, policies and regulations; * Perform all duties in accordance with City policies and procedures with regard for personal safety and that of other employees and the public. PHYSICAL REQUIREMENTS The job requires hand/finger dexterity to keyboard or type, handle materials, manipulate tools, and reach with hands and arms. The employee must occasionally lift and/or move up to 30 pounds with assistance. Sufficient visual acuity and hearing capacity to perform the essential functions and interact with the public is required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.