Data Analyst II

About the role

The Sacramento Area Council of Governments (SACOG) is seeking a Data Analyst II to join the Data & Analysis Team. This position includes significant work in Geographic Information Systems (GIS) using ESRI ArcGIS tools and platforms, along with data collection, management, and analysis.

Responsibilities

• Maintain and manage GIS datasets, including regional base layers and related spatial data systems
• Acquire, clean, and integrate spatial and tabular data from local jurisdictions and external partners
• Perform spatial analysis to support transportation, land use, housing, and regional planning efforts
• Support recurring data updates and workflows used for monitoring and reporting
• Contribute to development and improvement of data workflows, including use of scripting or automation tools where appropriate
• Support development of mapping tools, dashboards, and web-based GIS applications (e.g., web maps, StoryMaps, or similar tools)
• Assist with data processing, integration, and organization across multiple datasets and systems
• Conduct quality assurance and quality control (QA/QC) on datasets, data processing workflows, and analytical outputs
• Develop and maintain clear, well-documented, and reproducible datasets, workflows, and scripts
• Support maintenance and support of enterprise GIS systems, including web maps, map services, and related platform components
• Contribute to development and maintenance of dashboards, monitoring tools, and recurring reporting products
• Support integration of data across systems and platforms
• Prepare maps, data products, and summaries for internal staff, member agencies, and external stakeholders
• Support development, maintenance, and improvement of GIS architecture and supporting systems

Requirements

• Knowledge of relevant GIS technologies and platforms, including ESRI ArcGIS (e.g., ArcGIS Pro, Portal/Enterprise), GIS web services, and enterprise geodatabases (ArcSDE)
• Spatial data management, analysis, and visualization techniques
• Data analysis concepts and tools
• Data management practices, including data quality and organization
• Modern tools used for GIS, data analysis, and data visualization
• Ability to perform spatial and data analysis using GIS and related tools
• Work with both spatial and tabular datasets
• Apply scripting or automation approaches (such as Python or similar tools) to support data processing and workflow improvement
• Analyze and interpret data and present findings clearly
• Prepare maps, visualizations, reports, and written materials
• Manage multiple assignments and meet deadlines
• Work independently and collaboratively
• Learn and apply new tools and systems

Qualifications

• Graduation from an accredited four-year college or university with major coursework in GIS, geography, urban planning, data science, computer science, statistics, or a related field
• One (1) year of progressively responsible experience in GIS, spatial analysis, data analysis, or a closely related field
• Desired experience with ArcGIS, scripting (such as Python), visualization, dashboards, SQL databases, and data workflow automation