Description

The Office of Performance Management and Open Data (OPMOD) is the go to resource for harnessing city data to drive citizen focused solutions that improve the efficiency and effectiveness of city services while also providing unparalleled transparency into government operations.

We are a small team of public servants working at the highest levels of local government to use our expertise to create meaningful impact and help improve the lives of Chattanoogans. Our vales are the following: open by default, learning over accountability, asking for help shows strength, default to action, everyone has something to teach and work should be fun

We are seeking a new team member with similar values who wants to make a difference in Chattanooga.

Our Approach

  • Put users first - Start with users, not technology. Connect with the community about their needs and expectations, and test and refine solutions with the user.
  • Champion iterative, data-informed methods - Adopt an agile approach to technology and workflow design that uses prototyping, testing, and iteration to learn and improve over time, rather than "redesign".
  • Cultivate a learning community - Meet city employees enthusiasm with access to learning opportunities and cross-departmental and cross-discipline connection.

As part of this office, the Open Data Specialist works with IT, City agencies, community-based organizations, and end users to analyze data needs and provide city data in open, machine readable, easy to understand formats. The Open Data Specialist also works show the value of open data by developing useful civic applications using open data.

  • Works closely with the Office of Performance Management and Open Data to further the City of Chattanooga's open data program.
  • Creates, updates, maintains and monitors the city's automated extract, transform and load (ETL) workflows connected to the city's various applications and services.
  • Shepards open datasets through the open data workflow process prior to being posted on the open data portal.
  • Develops and designs digital library collections; ensures all data added to open data portal is useful, useable, and accessible.
  • Works with representatives from city government and external organizations to coordinate contributions of data to a public platform or portal.
  • Performs onsite data reviews to understand the business processes, data capture methods, in order to understand the data structure and value of the data being opened.
  • Documents ETL workflows and related processes for the open data program.
  • Oversees monitoring of data quality and identifies methods for improving quality of data being published.
  • Supports third party intermediaries wishing to access; and makes data accessible to different users through tools and applications.
  • Provides trainings on the open data program, platform and applications built on top of the open datasets.
  • Facilitates the impactful use of open data by collaborating with communities.
  • Other duties as assigned.

Skills and responsibilities

  • Knowledge of various best practices for extracting, transforming and loading of data from one system to another system.
  • Understanding of dataflow programming and transformations with ETL tools such as Safe FME, Airflow, and/or Pentaho.
  • Knowledge of GIS and mapping concepts (geocoding, projections, etc), including common commercial platforms as well as open source platforms.
  • Knowledge of professional collection development principles; programming languages; creative problem solving; and open data concepts.
  • Experience working with distributed version control systems such as Git.
  • Experience working with Python scripting for custom data transformations.
  • Ability to work with web services API.
  • Ability to effectively communicate, in written or oral form, with a wide variety of stakeholders.
  • Ability to work with file transfer protocols, primary SFTP.
  • Ability to develop and maintain databases.
  • Skill in using a computer and related software applications

Details

  • Location:
    Chattanooga
    ,
    TN
  • Salary:
    $40,265.00
    -
    $51,819.00
    yearly
    , Please Note: Starting pay begins at the bottom of the salary range.
  • Deadline:
    2018-10-16

Qualifications

Minimum qualifications

Two (2) years of any combination of relevant education, training or experience sufficient to perform the essential duties of the job will be considered.

Examples of relevant education include a Bachelor's degree from an accredited college in GIS, computer science, engineering, user-centered design, or a related field.

Examples of relevant experience include two years experience working with SQL based databases. 

Prefer two years experience in GIS and mapping concepts and tools or equivalent; enterprise GIS including common commercial platforms as well as open source platforms; front end development and web standards; web services API; dataflow programming and transformations with ETL tools such as Safe FME and/or Pentaho; Python scripting for custom data transformations; geoprocessing; working with file transfer protocols, primarily SFTP; web scraping; and distributed version control systems, primarily git.