Berkeley Lab's Energy Analysis & Environmental Impacts Division has an opening for a Software Developer. The successful candidate will support the data management needs for various data products used by the Energy Efficiency Standards (EES) group. The EES group performs analysis and testing to support development of energy conservation standards for the US Department of Energy (DOE) Appliance Standards Program. The position assists in the planning and design, and performs the detailed implementation, of software and database tools to store, manage, access, and support analysis of data from a range of sources and in a variety of formats, using both relational and non-relational database frameworks, as appropriate. The primary programming language is Python, including frameworks such as Django and Pandas. The primary relational database platforms are PostgreSQL and SQLite, and the primary NoSQL database framework is MongoDB.
This position will be hired at a level commensurate with business needs; and the skills, knowledge, and abilities of the successful candidate.
What You Will Do:
Working both individually and as part of a team, contribute to the design and implementation of databases and software tools for data management, as needed to support EES research activities
Work with other EES staff to define user needs for the various database tools. Based on those requirements, assist in the design of appropriate data access tools and contribute to implementation.
Provide technical support and training to users of the various software tools supported by this position.
Write robust, well-tested code, using modern software development best practices and formal testing frameworks.
Review, test, and critique code written by other EES staff to find bugs, recommend improvements, and help enforce standards of quality.
Exercise judgement and provide solutions for software issues encountered by users, including diagnosing and fixing software bugs with a fast turnaround time when needed to meet critical deadlines
Assist in automating and scheduling routine data collection tasks and in monitoring data quality on an ongoing basis.
Build productive internal and external working relationships.
Additional Responsibilities as needed:
Lead the evaluation of new database, software applications and approaches, to provide recommendations to EES staff.
Lead the evaluation of hardware and system requirements for new data management tools and make recommendations to EES staff.
Independently develop recommendations for testing or improving existing software developed in the EES group.
What is Required:
Bachelor's degree in a technical field, plus two years of relevant experience; or an advanced degree in computer science or a related field.
Demonstrated experience using Python for software development or data analysis.
Demonstrated experience working with relational database languages and tools (e.g., PostgreSQL).
Demonstrated experience and facility using modern software version control systems (e.g., git).
Experience using modern software testing practices and frameworks (e.g., Python's unittest).
Knowledge of at least one Python web framework (e.g., Django, Flask) and one Python object-relational manager (ORM; e.g., Django, Peewee).
Demonstrated experience working in both Microsoft Windows and Linux-type operating systems.
Knowledge of basic Linux system and web-server administration tasks.
Ability to work with a diverse group of colleagues to develop and implement strategies to manage a variety of heterogeneous datasets.
Ability to communicate effectively with non-specialist colleagues.
Willingness to accommodate user requests under tight deadlines.
Additional Desired Qualifications:
Advanced degree or 5+ years of relevant work experience.
Experience with web-integrated data visualization toolkits, such as Apache Superset.
Experience working with NoSQL database languages and tools (e.g. MongoDB) to design and implement solutions for the management of large data sets.
Experience with at least one tool for asynchronous task management, such as Celery.
Experience managing large quantities of time series data in a relational or non-relational database.
Experience developing VBA applications for Microsoft Excel.
The posting shall remain open until the position is filled, however for full consideration, please apply by close of business on June 27, 2019.
This is a full time 1 year term appointment with the possibility of extension or conversion to Career appointment based upon satisfactory job performance, continuing availability of funds and ongoing operational needs.
Classification will depend upon the applicant's level of skills, knowledge, and abilities.
Full-time, M-F, exempt (monthly paid) from overtime pay.
This position may be subject to a background check. Any convictions will be evaluated to determine if they directly relate to the responsibilities and requirements of the position. Having a conviction history will not automatically disqualify an applicant from being considered for employment.
Work will be primarily performed at: Lawrence Berkeley National Lab, 1 Cyclotron Road, Berkeley, CA.
Learn About Us:
Berkeley Lab (LBNL) addresses the world's most urgent scientific challenges by advancing sustainable energy, protecting human health, creating new materials, and revealing the origin and fate of the universe. Founded in 1931, Berkeley Lab's scientific expertise has been recognized with 13 Nobel prizes. The University of California manages Berkeley Lab for the U.S. Department of Energy's Office of Science.
Working at Berkeley Lab has many rewards including a competitive compensation program, excellent health and welfare programs, a retirement program that is second to none, and outstanding development opportunities. To view information about the many rewards that are offered at Berkeley Lab- Click Here.
Equal Employment Opportunity: Berkeley Lab is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, or protected veteran status. Berkeley Lab is in compliance with the Pay Transparency Nondiscrimination Provision under 41 CFR 60-1.4. Click here to view the poster and supplement: "Equal Employment Opportunity is the Law.
Internal Number: 87306
About Lawrence Berkeley National Laboratory
In the world of science, Lawrence Berkeley National Laboratory (Berkeley Lab) is synonymous with excellence. Thirteen scientists associated with Berkeley Lab have won the Nobel Prize. Fifty-seven Lab scientists are members of the National Academy of Sciences (NAS), one of the highest honors for a scientist in the United States. Thirteen of our scientists have won the National Medal of Science, our nation's highest award for lifetime achievement in fields of scientific research. Eighteen of our engineers have been elected to the National Academy of Engineering, and three of our scientists have been elected into the Institute of Medicine. In addition, Berkeley Lab has trained thousands of university science and engineering students who are advancing technological innovations across the nation and around the world. Berkeley Lab is a member of the national laboratory system supported by the U.S. Department of Energy through its Office of Science. It is managed by the University of California (UC) and is charged with conducting unclassified research across a wide range of scientific disciplines. Located on a 200-acre site in the hills above the UC Berkeley campus that offers spectacular... views of the San Francisco Bay, Berkeley Lab employs approximately 4,200 scientists, engineers, support staff and students. Its budget for 2011 is $735 million, with an additional $101 million in funding from the American Recovery and Reinvestment Act, for a total of $836 million. A recent study estimates the Laboratory's overall economic impact through direct, indirect and induced spending on the nine counties that make up the San Francisco Bay Area to be nearly $700 million annually. The Lab was also responsible for creating 5,600 jobs locally and 12,000 nationally. The overall economic impact on the national economy is estimated at $1.6 billion a year. Technologies developed at Berkeley Lab have generated billions of dollars in revenues, and thousands of jobs. Savings as a result of Berkeley Lab developments in lighting and windows, and other energy-efficient technologies, have also been in the billions of dollars. Berkeley Lab was founded in 1931 by Ernest Orlando Lawrence, a UC Berkeley physicist who won the 1939 Nobel Prize in physics for his invention of the cyclotron, a circular particle accelerator that opened the door to high-energy physics. It was Lawrence's belief that scientific research is best done through teams of individuals with different fields of expertise, working together. His teamwork concept is a Berkeley Lab legacy that continues today.