Job Summary:
Geosyntec Consultants is an innovative, international engineering and consulting firm that focuses on environmental issues. They are seeking an Experienced Environmental Data Manager to design, develop, and manage project-specific relational database applications and support environmental data management for various projects.
Responsibilities:
• Designing, developing, and managing project-specific relational database applications using enterprise (MS SQL Server, EQuIS) database software;
• Developing comprehensive workflows and metadata to automate compilation of data from multiple sources and serve data to maps, reports, and other tools;
• Managing and organizing datasets for the entire lifecycle of environmental data, from planning to final reporting activities,
• Providing QA/QC on data, systems, and processes related to environmental data,
• Compiling, verifying, analyzing, and reporting large and diverse datasets;
• Interacting with internal and external providers (laboratories, consultants, agencies, etc.) to coordinate collection and transfer of data to project databases;
• Collection, manipulation, querying, and analysis of databases and environmental analytical and geospatial data;
• Interacting with internal and external clients to support database management and data visualization for environmental, engineering, and geoscience projects.
Qualifications:
Required:
• Bachelor's degree in environmental science, chemistry, geography, computer science, engineering, or geology.
• At least 5 years of technical training and experience in relational database technology, or equivalent combination of education and experience.
• Experience with database management and building ETL processes.
• Advanced proficiency with MS Excel and MS Access, including the ability to write complex formulas and visualize data effectively.
• Ability to write complex SQL queries and automate routine processes.
• Exceptional attention to detail in quantitative work products, written communication, spelling, and grammar.
• Valid U.S. driver’s license and a satisfactory driving record for business travel.
Preferred:
• Advanced degree in environmental science, chemistry, geography, computer science, engineering, or geology.
• 7+ years of technical training and experience in relational database technology, or equivalent combination of education and experience.
• Proficiency with Microsoft SQL Server, including the ability to automate processes.
• Proficiency with EarthSoft’s EQuIS environmental data management platform.
• Ability to automate processes using scripts (e.g., Python, R).
• Direct experience managing environmental, geologic, and geotechnical data collection.
• Knowledge of laboratory analytical data verification and validation processes.
• Experience submitting data to—and obtaining data from—agency and government databases (e.g., CA Water Boards Geotracker, Arizona Department of Environmental Quality, NIRIS, ERPIMS, CEDEN)
Company:
Geosyntec is a full-service consulting and engineering firm that works with private and public sector clients. Founded in 1983, the company is headquartered in Ipoh, MYS, with a team of 1001-5000 employees. The company is currently Late Stage.