UCLA California Center for Sustainable Communities

Data Analyst/Developer

Employment type
9 days ago
Los Angeles

The California Center for Sustainable Communities (CCSC) at UCLA’s Institute of the Environment and Sustainability is seeking a skilled Data Analyst/Developer to take a leading role on the UCLA Energy Atlas team. This full-time position is eligible for all UCLA benefits and is currently remote, though eventually will be flexible with some workdays based on the UCLA campus when safe to do so.

About the Project

The UCLA Energy Atlas is a database of building energy consumption that links utility account information to building characteristics, sociodemographic data, and other significant attributes that can be expressed spatially. The public portion of the Energy Atlas features interactive energy maps, comparative graphs, and tabular views of community energy profile data. The aggregated information presented on this public front-end website is made possible through a separate, confidential, back-end geospatial relational database which contains almost five billion unique records.

The Energy Atlas project provides Californians, and those interested in ongoing energy transitions, with the opportunity to interact with one of the largest sets of disaggregated building energy data available in the nation. This interactive tool is used by a wide variety of stakeholder groups to inform energy planning and research throughout California. As creators of this tool, our mission is to provide transparency and access to critical energy data to achieve the state’s ambitious energy and climate goals.

CCSC is increasingly recognized as pioneering new analysis methods to assist in the energy transition toward electrification and for providing insights into the potential for unequal outcomes for disadvantaged communities. Our Energy Atlas harnesses a sophisticated coupling of sociodemographic data, energy consumption, and building attributes, with grid capacity and solar rooftop potential, to help make these conversations possible.

Job Description

The Data Analyst/Developer plays a key role supporting the innovative research of Energy Atlas data team at CCSC. They will be responsible for leading data analysis, data processing, and working closely with the database programmer on backend development. This position requires a strong understanding of data analysis, statistics, and database best practices and development in the context of tabular and spatial data presentation. The Data Analyst works closely with other Technology teams to deliver innovative and quality solutions. The candidate must have a demonstrated strong understanding of SQL, Python, spatial statistics, and database management. This person is responsible for collaboratively developing methods of analysis to address research questions. Additional responsibilities include project related activities such as presenting the work to end users, gathering feedback, documenting methods, and written analysis. Desired familiarity with energy systems and units. Preferred familiarity with GIS analysis, web mapping, and data visualization. The candidate must have the ability to work independently and collaboratively in a small group.

Essential Job Responsibilities Include:

  • Data cleaning, processing, and analysis using Python and SQL programming languages.
  • Database development, optimization, maintenance, and management in close collaboration with the database developer.
  • Collaborate with CCSC researchers to develop methods for data extraction and analysis while ensuring data quality and integrity.
  • Design data visualizations for communicating research findings (Tableau, Carto, ArcGIS Online, etc.).
  • Prepare and maintain diligent documentation relating to database development and data processing.
  • Communicate workflow and findings with research team members, principal investigators, external collaborators, and the public.
  • Collaborate with UCLA IT Security team to ensure data security protocols are maintained.


Skills And Qualifications
The ideal candidate will possess the following skills and experience:

  • A graduate degree in GIS, urban planning, energy, environmental science, computer science, data science, or a related area of study with a particular focus in data analytics, or an equivalent combination of education and work experience.
  • One to four years of professional research or analytical experience, or an equivalent combination of education and experience.
  • Expertise in a range of programming languages including Python and SQL. Stays current with new and developing technologies.
  • Experience working with large datasets (billions of records)
  • Knowledge and interest in energy, climate, and environmental justice related research.
  • Experience with the use of version control systems in software development (Git)
  • Experience with spatial data or interest in developing these skills.
  • Familiarity with Linux environments.
  • Preferred familiarity with GIS analysis, web mapping, and data visualization
  • Excellent communication skills in writing, small group discussions, and public presentations.
  • Exceptional attention to detail and time management skills with the ability to set priorities and meet deadlines.
  • Interest in developing novel data or research strategies/solutions.
  • Ability to work independently and in a collaborative team environment.
  • Willingness to contribute to writing
To apply

To Apply: please go to: