Geographic Information Systems Analyst​/Data Engineering

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.

T4413A

We welcome applications from everyone.

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 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.

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.

to see a list of employee benefits.

• Creates mapping and other visualizations in MS Power B… from Oracle and other database sources. Uses the Power B… 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 B… 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…