Pecan Street Seeks Database Administrator

Pecan Street Inc. seeks a Database Administrator to be part of its award-winning team accelerating innovations for climate and conservation solutions. The selected candidate will be part of a passionate, dynamic team that works on a range of exciting programs in partnership with public and private entities. The selected candidate will work with the nation’s largest research database on customer electricity use, water consumption, solar panel generation and electric vehicle charging, joining a talented team that has deep experience in consumer electronics and software development.

About Pecan Street Inc.

Climate change is the world’s single greatest challenge. And securing a clean water supply for a growing population isn’t far behind. Solving both challenges will grow the economy, improve people’s lives, and protect our precious planet. The solutions to these challenges will demand a mixture of new technologies and policies. But it first requires a detailed understanding of water and energy use behavior.

Unlike any other organization, Pecan Street’s research addresses technology, behavior, and how the two interact. We develop unique datasets to help our team and collaborators better understand barriers to solving climate and water management challenges, and we provide proving grounds to accelerate the development and adoption of solutions.

We are the only organization that combines expertise in the “Internet of Things,” high-velocity data acquisition, big data analytics, and lean product development to drive disruptive innovation for climate and conservation solutions.

Our real-world testbed of volunteer research participants is the first of its kind on the planet and has become an international model for how to develop and conduct energy and resource research and technology development. Our commercialization lab is a world-class proving ground producing leapfrog solutions for the transition to clean energy. And our database, the largest source of disaggregated customer energy data, is used by university researchers and industry-leading companies around the world.

Pecan Street’s lab is a green-built facility producing leapfrog solutions for clean energy and water management where companies of all sizes can develop, test and validate a wide range of products and services. The lab also houses Pecan Street’s secure data center, which powers Dataport – our interactive online portal that provides access to our data, which is the world’s largest research database for residential energy and water use. Dataport also includes tools to help researchers understand, visualize, and analyze these data resources.

Responsibilities

• Under the direction of the Data Manager, provide database development, architecture and management support

• Coordinate with the Data Manager and Pecan Street staff on the ETL processes necessary to successfully incorporate data into our PostgreSQL database
• Using SQL, query Pecan Street data sources to extract information for internal requests of data and coordinate with staff on data needs external to the organization and assist with creating and running queries to fulfill external requests.
• Design and development of Pecan Street's proprietary ETL data pipelines (using Python and Postgres) that enable data archiving for offering to research and commercial partners.
• Development of SQL Views and transformations to expose data to partners as well as decisions regarding correct authorization of data.
• Develop load profile statistics and correlate to diagnostic conditions.
• Support Pecan Street staff in developing mobile apps, web apps and other online tools in Python, PHP, Javascript, and other languages
• Server-side development, maintenance, and work

Experience and Skills

Pecan Street seeks a candidate with:

• Bacheloe’s degree or equivalent in Information Technology (IT), Computer Science, or related discipline.
• Expertise in PostgreSQL
• Proficiency in Python, web development, JavaScript, Linux, web services, and PHP
• Proficiency in Microsoft Excel
• Ability to take large and/or complex data and make it more accessible, understandable and usable
• Preferred experience with residential energy, water, and/or gas data but not required

Professional Qualities

• Analytical skills: Able to evaluate complex information coming from a variety of sources.
• Communication skills: Must communicate effectively with all levels of an organization.
• Problem-solving skills: Ability to troubleshoot problems when they arise

Benefits

Benefits are competitive and include:

• health insurance requiring no contribution from the employee including dental, vision, short- and long-term disability, and affordable family plans;
• 401(k) retirement planning;
• 15 days of annual paid-time off plus 10 additional holidays; and,
• 3 months of fully paid maternity and paternity leave.