Data Analyst II

Data Analyst II

The Sacramento Area Council of Governments (SACOG) is seeking qualified candidates for a Data Analyst II to join the Data & Analysis Team. This is the experienced level in the Analyst class series. Employees in this classification provide analytical and technical support to assigned programs, projects, and services and may manage smaller projects or components of larger efforts under the guidance of senior staff.

This position includes significant work in Geographic Information Systems (GIS) using ESRI ArcGIS tools and platforms, along with data collection, management, and analysis and quality control/quality assurance. The role includes managing and maintaining datasets, conducting spatial analysis, and producing GIS-based maps, data visualizations, and analytical products that support planning and decision-making.

The position also involves working with Structured Query Language (SQL) Server databases and large, complex datasets, and contributing to data processing workflows, including the use of scripting or automation tools where appropriate. The role supports both ongoing data maintenance and the continued development of efficient, scalable, and well-documented workflows and data systems.

The Analyst II will work with spatial and non-spatial datasets related to transportation, housing, land use, and demographic trends to translate data into useful information for planning, policy, and investment decisions. The position works closely with GIS staff, analysts, modelers, and program teams across SACOG and with partner agencies throughout the region.

The ideal candidate would be joining a team of highly skilled professionals with expertise in GIS, travel modeling, data analysis, programming, and visualization. The team applies advanced analytical methods and technical tools to help SACOG and regional partners make informed decisions about both immediate projects and the region's long-term future. Their work includes developing and maintaining core datasets, analytical tools, visual resources, and data systems that support planning, policy, and investment decisions across the Sacramento region.

SACOG is the Metropolitan Planning Organization for the six-county Sacramento region. Formed as a Joint Powers Authority, SACOG is governed by a board of 31 elected officials that directly represent all six counties and 22 cities in the region, and one ex-officio member (Caltrans). While transportation is core to SACOG's role as a Metropolitan Planning Organization, SACOG has over two decades of experience approaching regional issues from an integrated perspective that examines the linkages between transportation, housing, economic prosperity, environmental stewardship, and air quality. Under the leadership of its executive director, SACOG has a vision of a vibrant and thriving Sacramento region for all. Its mission is: SACOG convenes and connects the region to advance an equitable, sustainable, and prosperous future.

SACOG values diversity and believes that a range of backgrounds brings a variety of ideas, perspectives and experiences that contribute to an innovative and collaborative environment in which talents are fully utilized, uniqueness is valued, and SACOG's objectives are met. SACOG is committed to building a culturally diverse workplace. We welcome individuals of all backgrounds, orientations, and identities.

SACOG is an Equal Opportunity Employer and is committed to compliance with all applicable laws providing equal employment opportunities. SACOG provides fair and equal opportunity for all with no discrimination because of race, creed, color, religion, ancestry, national origin, gender, physical disability, mental disability, medical condition, marital status, age, sexual orientation, or any other consideration made unlawful by federal, state, or local laws.

SACOG employs a dedicated and professional staff of 60 who work together to advance solutions to some of the region's shared challenges of transportation, housing, air quality, climate change and the protection of the region's agricultural and natural resources. SACOG fosters an inclusive, mission driven, and fun employee culture and offers flexible schedules.

SACOG will make reasonable accommodations for the known physical or mental disabilities of an otherwise qualified individual who is an applicant or employee.

We work towards a shared vision while cultivating a workplace of collaboration, trust, and transparency. We create space for individual strengths and experiences to achieve more, together.

We intentionally build an inclusive community where people can be themselves, share ideas, and pursue solutions. Together, we address challenges that are too big for any one person or group to solve on their own.

We have the courage to tackle new challenges head on. We are driven by the opportunity to leave a lasting, positive impact on the region. We are committed to quality performance as we accomplish the agency's goals.

We strive for continuous improvement by reimagining the work and the way we do it. We use data and input to measure our progress, extract new insights, and elevate our work. This allows us to pave new paths into the future.

As an integral part of our organization, employees will provide support in a flexible work environment. This position will have the ability to telework two days per week.

The remainder of the work week will be in-person. Employees are required to live within 200 miles of Sacramento.

We support telework because it:

• Enhances employee productivity, satisfaction, and ability to collaborate.
• Improves recruitment and retention
• Reduces greenhouse gas emission, vehicle miles travels (VMT), traffic and parking congestion, and air pollution

Filing Deadline: July 31

First Round Interviews: Week of August 10

Second Round Interviews: Week of August 17

Reference Checks: Week of August 24

Desired Start Date: September 14

Candidates will complete an online soft skills assessment and may be asked to complete a practical exercise during the interview process, such as a technical presentation or walkthrough of prior work.