Data Analyst

The purpose of this classification is to perform technical and analytical work functions associated with identifying, capturing, analyzing, and interpreting enterprise data across all city departments that contribute to better data-driven systems for decision-making, open government operations, cost reduction measures, quality of service improvements, and greater digitization, automation and planning. Employees in this classification serve as a resource to departments in the planning, development, and control of data systems, data analysis, and statistical and data reporting.

• Develops and implements custom data capturing and analyzing programs; performs statistical analysis to include designing and producing numerical and descriptive information and reports for program reviews, departmental operations assessments, and activity efficiency and effectiveness.
• Provides customer service and expert guidance to educate and advise city personnel on issues related but not limited to data creation, collection drilled, and maintenance and formulation of data resources and systems.
• Prepares analytical reports, summaries, and policy analyses as requested.
• Independently creates, analyzes, modifies, and maintains data systems; monitors and assures quality of data; audits data systems and works with departments to correct errors and future problems.
• Works closely with departments to gather requirements for key performance indicators and identify corresponding data sets and calculations needed.
• Provides and fulfills requests for ad-hoc reports and analysis; performs data mining and analysis in order to extract and identify key trends and insights.
• Reviews and validates data for accuracy; conducts research for data and reporting issues as required; performs cleansing of data to ensure sources are accurate for analysis and reporting.
• Identifies opportunities to increase data quality to include automation and data entry procedural training.
• Extracts and manages multiple sets of data bwino; from various databases and sources to bring together data from several areas for comparative analysis and reporting.
• Designs reporting dashboards to translate data to an understandable illustrative format.
• Documents all data management procedures and specifications; prepares and distributes correspondence, memoranda, and reports.
• Trains as necessary on analytics platforms to enable self-service reporting by departments; serves as a subject matter expert and administrator for business intelligence tools.
• Answers the telephone; provides information, guidance and assistance; takes and relays messages and/or directs calls to appropriate personnel; responds to questions, problems and requests for information/assistance from employees, officials or other persons.
• Communicates with supervisor, co-workers, users, departments, vendors, and outside agencies to discuss work in progress, exchange information, resolve problems, provide operational support, and project management.
• Understands the functions, procedures, and workflow of city departments as they relate to the collection and analyzing of data.
• Maintains knowledge of operating systems and platforms and software programs to operate a computer in an efficient and effective manner.
• Maintains an awareness of new products, trends, and advances in the profession; reads professional literature; attends workshops, conferences, and training sessions.

• Must possess and maintain strong analytical, mathematical, and critical thinking skills with attention to detail and organization.
• Must possess and maintain a foundational understanding of statistical analysis and reporting.
• Must possess and maintain working knowledge of Extraction, Translate & Load (ETL) Tools and experience using such tools to manipulate data sets.
• Must have experience with relational databases and a working knowledge of Structured Query Language (SQL) to query and manipulate data.
• Must have demonstrated abilities to understand and address client
  
  Cancelable data requests and to use reporting tools to provide desired information.
• économiques haben experience with scripting tools such as Visual Basic/VBScript, Python, JavaScript, Perl, PHP.
• Must have experience with search and analysis tools such as Elastic Search, Kibana, Logstash, ELK Stack, Google Analytics, etc.
• Must have experience utilizing Application Programming Interfaces (APIs).
• Must have ability to understand and utilize geospatial data.
• Must possess and maintain knowledge of business intelligence and data visualization tools and quality control, analytic and…