Project Assistant for GIS and Data Analytics - Hourly

Salt Lake City Corporation; Salt Lake City (UT); On-site; USD 33,000 - 39,000; Part time

Job summary

Salt Lake City Corporation is seeking a Project Assistant for GIS and Data Analytics to support the creation and maintenance of dashboards, maps, and datasets. The role involves QA testing, data visualization, and updating ArcGIS maps for permit closures, with a focus on accessible public data.

The ideal candidate will have experience with ArcGIS, Power BI, Tableau, and coding languages like SQL, Python, or R, and a Master’s in GIS or related fields is preferred.

Qualifications

• Bachelor’s degree in Public Administration, Political Science, Business Administration or related field or four years paid professional experience.
• Experience in research, statistical analysis, and data visualization.
• Ability to prepare and present project details using complex spreadsheet analysis and graphics.
• Knowledge of government operations and public policy analysis.

Responsibilities

• Conduct research on assigned issues and analyze impacts of public policy decisions.
• Develop models or scenarios to simulate economic or land use impacts.
• Create data visualizations and maps for internal and public dashboards.
• Update GIS maps with permit-related closures and ensure data accuracy for end users.

Skills

ArcGIS

Power BI

Tableau

SQL

Python

R

Education

Bachelor’s degree in Public Administration, Political Science, Business Administration or related field

Master’s degree in GIS, Data/Computer Science, Statistics/Mathematics, or related field

Tools

ArcGIS

Tableau

Power BI

Job description

**Position Title:**Project Assistant for GIS and Data Analytics - Hourly**Job Description:**Working under limited supervision, incumbent 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. Preferred candidates have experience with visualization software such as ArcGIS, Power BI, or Tableau, and coding languages such as SQL, Python, or R. This is a part-time, hourly position.**POSITION SALARY RANGE****$24/hr-28/hr to 20 hours per week** **TYPICAL DUTIES:*** 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. **MINIMUM QUALIFICATIONS:*** 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. Preference may be given to candidates with public sector experience. Experience and education may be substituted on a year-for-year basis.* 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. **DESIRED QUALIFICIATIONS:*** 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 + .**WORKING CONDITIONS:*** Light physical effort. Intermittent sitting, standing and walking. Comfortable working conditions.* Considerable exposure to stress resulting from complex problem solving, stringent project deadlines, and liaison work between City departments, Mayor’s office, politically powerful community groups, and the City Council. The above statements are intended to describe the general nature and level of work being performed by persons assigned to this job. They are not intended to be an exhaustive list of all duties, responsibilities and skills required of personnel so classified. All requirements are subject to possible modification to reasonably accommodate individuals with disabilities.**POSITION TYPE****Part-Time** **DEPARTMENT****Information Management Systems****Full Time/Part Time:**Part time**Scheduled Hours:**20