Project Assistant for GIS and Data Analytics - Hourly

Salt Lake City Corporation•Louisville, KY

1d•$24 - $28•Onsite

About The Position

Working under limited supervision, this role is responsible for conducting research, gathering and analyzing information, and developing findings or recommendations to support department programs, projects, and operational decisions. This role supports projects that build and maintain internal and public facing dashboards, maps, and datasets. Responsibilities include performing quality assurance testing on data and creating data visualizations and maps that are accurate and accessible for end users. An example of project support involves reviewing permits that impact the closure of city streets. This role reviews a permit's attached PDF or image that depicts the closure. They update an ArcGIS map with the closure and stay on top of new permits each week. They digitally draw the closures on the map, update relevant data, and make sure the public-facing geospatial data is accurate. The ideal candidate can identify opportunities for automation and is comfortable working with code. Incumbents at this level possess the skill and demonstrated ability to support data-driven decision-making within the organization as well as the city overall.

Requirements

Bachelor’s degree in Public Administration, Political Science, Business Administration or a closely related field or four (4) years paid professional experience including any combination of research, statistical analysis, project and legislative review, policy development, and related activities.
Knowledge of effective project management, statistical analysis, and research methods and principles.
Ability to prepare and present project details using complex spreadsheet analysis, graphic presentations and technical reports to Division Managers, City Council, and general public.
Knowledge of government operations, processes, and public policy analysis.
Ability to establish and maintain effective working relationships with diverse groups and people, including elected officials, department officials, staff, and community representatives.
Demonstrated ability to work independently with initiative, self-reliance, and dependability.
Comfortable working with code.

Nice To Haves

Master’s degree in GIS, Data/Computer Science, Statistics/Mathematics, or related field.
Technical certifications in programming such as SQL, Python, etc.
Advanced knowledge of visualization software such as ArcGIS, Tableau, or Power BI, and coding languages such as SQL, Python, or R.
In depth knowledge of statistics, quantitative analysis, and telling stories with data.
Experience working with complex datasets, analyzing data, and reporting results.
Can collect and analyze data/trends and make appropriate recommendations to further a department’s goals.
Possess strong data analysis skills and project management skills.
Demonstrates critical thinking and problem-solving skills by asking questions and identifying opportunities for improvement.
When encountering roadblocks, communicates the issue and considers alternate solutions.
Manage conflicting priorities with different timelines, multitask, and effectively adapt to change.
Able to learn new software and analytic techniques and apply it to future projects.
Ability to communicate effectively, both orally and in writing.
Public sector experience.
Experience with visualization software such as ArcGIS, Power BI, or Tableau.
Experience with coding languages such as SQL, Python, or R.

Responsibilities

Conducts research on assigned issues, performs analysis, and assesses legislative, fiscal, and political impacts of public policy issues.
Develops models or scenarios to simulate economic, land use or legislative impacts.
Articulates and generates decision paths, and prepares formal written findings and recommendation for consideration and action by department/division administration.
Facilitates meetings with city departments, diverse groups from the community, other governmental agencies, and consultants to obtain further insight and information necessary to negotiate a balanced resolution to issues and achieve established project goals/objectives.
Explores and develops creative concepts, ideas, plans, or processes to address project issues.
Develops project parameters such as: project resources; time frames; funding options and budget requirements; staffing needs; and, methods, procedures and schedules for project implementation.
Drives project progress to ensure tasks and applications follow agreed upon decision path and time frames.
Keeps current on evolving public policy trends and industry benchmarks.
Develops and monitors program and special project activities.
Provides regular updates and reports to department and division management.
May assist with monitoring compliance with contracts.
May represent the department/division at community meetings, workshops, business, and other government meetings.
Performs other duties as assigned.
Performing quality assurance testing on data.
Creating data visualizations and maps that are accurate and accessible for end users.
Updating an ArcGIS map with street closures based on permit reviews.
Digitally drawing closures on the map.
Updating relevant data for street closures.
Ensuring public-facing geospatial data is accurate.
Identifying opportunities for automation.