Geographic Information Systems Analyst​/Data Engineering

Overview

Position/Program Information
We will be accepting online applications from Wednesday, January 7, 2026, 8:00 a.m. (PT) until Thursday, January 22, 2026, before 5:00 p.m. (PT). All applications must be received before 5:00 p.m. (PT) on Thursday, January 22, 2026, to be accepted.

Exam number
T4413A

TYPE OF RECRUITMENT
We welcome applications from everyone.

Why work for us?
With more than 10 million residents, Los Angeles County is the most populous county in the nation! As the largest employer in Southern California, over 116,000 employees in more than 38 Departments, we provide vital public services as diverse as law enforcement, property assessment, public health protection, water conservation, cultural activities and many more.

We are dedicated professionals committed to preserving the dignity and integrity of the workplace as well as protecting the rights of each employee. The County has more than 2,300 different job descriptions, offering a lifetime of opportunities and careers! We offer one of the strongest public-sector benefits packages in the country. Join us and discover a rich selection of health care options, robust retirement plans and the flexibility to work, relax, and rejuvenate to reach your fullest personal and professional potential.

The Geographic Information Systems Analyst We Are Searching For
The Department of Children and Family Services (DCFS) depends on the use of Geographic Information Systems (GIS) data engineering skills for building and maintaining data pipelines between our production databases and various cloud hosted database platforms to provide geospatial and geospatially derived data for analysis and applications.

Out-of-class/Withholds
No Out-Of-Class or Withholds are allowed for this examination. Required experience or education must clearly indicate on the supplemental questionnaire/application and be met by the last day of filing.

For more information, please view the classification specification:
Geographic Information Systems Analyst

• Creates mapping and other visualizations in MS Power BI from Oracle and other database sources. Uses the Power BI DAX scripting language to create custom fields with calculated values and designs data visualizations using similar business intelligence and analytics tools like Esri ArcGIS Dashboards, Tableau, D3.js, Python, Plotly, or Rare a plus.
• Generates ad hoc reports in response to requests from departmental managers. Runs and assists with the creation of complex SQL scripts querying multiple tables to pull data from Oracle databases into spreadsheets containing geospatially derived and other values. Uses Excel Pivot tables and SQL to research existing, published reports to compare data extracts for accuracy.
• Uses PostGIS' high-performance capabilities to geospatially join very large geospatial data layers for updating tables used to look up street name spellings by ZIP Code or city name.
• Operates, creates, and debugs Python scripts used for address geocoding workflows that include geocoding, spatially joining of address point locations to numerous jurisdictions, and coordinate conversions.
• Researches via Google, Bing, Open Street Map  and other resources to investigate addresses that the Python scripts could not find.
• Uses ArcGIS Pro and/or open-source tools to maintain geospatial layers used by RAVS and other geospatial applications.
• Investigates and reconciles RAVS issues at the request of DCFS Hotline staff regarding differences between geospatial data layers and Esri geocoding results.
• Researches precise boundary locations of DCFS Regional Offices, law enforcement jurisdictions, cities, and counties.
• Converts coordinates in different projections used by various Dev Ops teams, Power BI and Tableau users (WGS
  84, Web Mercator, and State Plane) using ArcGIS or PostGIS or open-source tools. Uses PostGIS to convert coordinate pairs to straight line and/or ellipsoidal distances.
• Assists with the creation and debugging of Python scripts used by AWS Lambda functions used in our geospatial applications.
• Maintains and updates geospatial databases on our Postgre
  
  SQL server on Amazon Web Services using desktop GIS applications.
• Works with teams of software developers with basic knowledge of JavaScript and geospatial web APIs, to develop or make improvements to geospatial web applications.
• Uses Esri's GUI driven tools, like Instant Apps and Esri Experience Builder, to create ad hoc geospatial applications on our departmental server running Portal for ArcGIS.
• Participates in the research of new and emerging geospatial technologies that can be used in various departmental geospatial applications. Explains various coordinate systems to Dev Ops teams.

SPECIALTY REQUIREMENTS:

Option 1
A Bachelor's degree
* from an accredited college or university with a major in Geographic Information Systems (GIS), GIScience, Geography, or a closely related field
** requiring at least 18 semester units or 27 quarter units in Geographic Information…