Database Developer UCLA Energy Atlas

The California Center for Sustainable Communities (CCSC) at UCLA’s
Institute of the Environment and Sustainability is seeking a skilled
Database Developer to take a leading role in managing the UCLA
Energy Atlas database. This full-time position is eligible for all UCLA
benefits, and is based on the UCLA campus.

 

Job Description
The Database/GIS Programmer is responsible for the development and maintenance of the
UCLA Energy Atlas backend PostgreSQL database. This position requires an expert
understanding of database design and development best practices, particularly involving large
datasets and spatial data concepts. The Database Programmer works closely with other
research team members to transform and deliver datasets essential to the Center’s research
mission. The candidate must have demonstrated strong skills using PostgreSQL databases, GIS
(Post-GIS), spatial statistics, and Python programming.

Essential Job Responsibilities Include:
• Database development, optimization, maintenance, and management.
• Data cleaning, processing, and analysis using Python and SQL programming languages.
• Ensure data quality and integrity for research and analysis.
• Collaborate with CCSC researchers to develop methods for data extraction and analysis.
• Prepare and maintain diligent documentation relating to database development and
data processing.
• Ensure security of database following UCLA IT Security protocols in place.

Skills And Experience

The ideal candidate will possess the following skills and experience:
• A graduate degree in GIS, urban planning, environmental science, computer science, or
a related area of study with a particular focus in database management or an equivalent
combination of education and work experience.
• Two to four years of professional research or analytical experience, or an equivalent
combination of education and experience.
• Experience working with large datasets (billions of records)
• Experience developing and maintaining spatial database, preferably PostgreSQL and
Post-GIS.
• Knowledge and interest in energy related research.
• Expertise in a range of programming languages including Python and SQL. Stays current
with new and developing technologies.
• Expertise working with a range of mapping platforms.
• Experience with the use of version control systems in software development (git)
• Exceptional attention to detail and time management skills.
• Interest in developing novel data or research strategies/solutions.
• The ability to set priorities and meet deadlines.
• Ability to work in a collaborative team environment.

 

To apply, submit your application, cover letter, and resume on UCLA’s job portal:

hr.mycareer.ucla.edu/applicants/Central?quickFind=78746

The University of California is an Equal Opportunity/Affirmative Action Employer advancing
inclusive excellence. All qualified applicants will receive consideration for employment without
regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability,
age, protected veteran status, or other protected categories covered by the UC
nondiscrimination policy.

 

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. CCSC is working with these communities to
empower them to participate in policy dialogues and decisions through grants from the
California Energy Commission and the Strategic Growth Council. 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.