Position Description

SFEI is seeking a Technology Analyst to work in the Environmental Informatics and Clean Water Program teams. This is a full-time position for a candidate with a Bachelor's degree or higher in a relevant scientific, information management, or data science field, with an interest in environmental issues.

The Analyst will be a member of the Data Services team which is responsible for the smooth operation of all enterprise-level production databases at SFEI and for providing database management services. The Analyst will assist in uploading, maintaining, and displaying environmental data and performing data management tasks required for the San Francisco Bay Area's Regional Data Center efforts.

SFEI has a thirty-year track record of informing key environmental decisions through the use of credible, high-quality data. As a part of the Data Services team, the Analyst would contribute meaningfully to this remarkable legacy.

Primary responsibilities for this position will include:

• Tracking and processing data submittals from contract labs and research partners
• Reviewing, uploading and maintaining monitoring data according to the Institute’s standard operating procedures and relational database structure
• Building and/or modifying scripts to transform, load, review and access data 
• Reviewing and comparing submitted data to project goals for accuracy, precision, sensitivity, contamination and completeness
• Resolving issues with data submittals by working with Institute staff and staff from contract laboratories and research partners.
• Assisting in the assembly, analysis, and presentation of data for technical reports, web-based tools, and other products

If you are excited about this role, but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this, or one of our other roles.

Qualifications

Required Experience

• Bachelor's degree or higher in a pertinent scientific, information management, or computer science field, with an interest in environmental issues, plus minimum 2 years of experience in working with relational databases.

 Required Skills

• Must possess strong knowledge of spreadsheet applications, especially Excel and/or Google Sheets
• Experience in database querying and strong understanding of relational database structure  
• Experience reviewing complex data sets for quality assurance and other issues
• Exceptional attention to detail
• Excellent problem solving skills
• Effective written and verbal communication skills
• Ability to work independently with limited supervision and also in a team environment

 Useful Additional Skills

• Knowledge of relevant software (e.g. MS SQL Server, postgreSQL, R, Python/pandas, Git/version control)
• Experience working with CEDEN or SWAMP
• Familiarity with database programming/scripting
• Knowledge of subjects relating to environmental science (e.g. chemistry, biology, geology, ecology)
• Interest in working in a mission-driven environmental science non-profit