Senior Environmental Data Management Specialist

Stantec•Walnut Creek, CA

About The Position

Your Opportunity We have an immediate opportunity for a Senior Environmental Data Management Specialist to join our dynamic Environmental Services team in Walnut Creek, CA. The successful candidate will work independently as well as within the Environmental Services and PMCM Technology Teams to manage database systems, develop data management procedures, assist colleagues in performing data-related tasks, and networking with internal/external clients. As part of our Data Management Team, you will: Prepare proposals and data management estimates. Prepare data management plans Liaise and coordinate with internal and external clients to provide data management solutions. Provide mentorship to data managers. Work on a wide variety of environmental projects at a time, on sites located throughout the United States and internationally. Manage and organize laboratory, field, spatial and geological data to ensure quality and consistency. Maintain and query data using EQuIS, MS Access and MS SQL Server Produce data reports using in-house software and/or specialized queries. Assist in developing standards and procedures for data management process improvements. Actively communicate and coordinate with project managers, laboratories, and/or other team members to acquire data packages of varying formats to be imported to a centralized database system. Prepare submittals for large government clients

Requirements

Strong expertise in relational database design and development.
Proficiency in SQL/t-sql and experience with SQL Server tools (SSMS, SSIS, SSRS).
Experience with data modeling, warehousing, and ETL processes
Proficient with EarthSoft EQuIS
Proficient with MS Excel, advanced formulas, and VBA programming
Proficient with MS Power BI Platform to develop custom data reports and analytics (Desktop and Paginated Reports or SSRS)
Proficient in using and understanding Federal/Provincial/Municipal/State regulatory guidelines.
Exceptional attention to detail
Passion for working with data and have had exposure to environmental analytical and field data.
Strong problem-solving skills
Capable of working both independently and in a team environment
Ability to adapt to a changing environment and handle multiple priorities, with ability to self-manage priorities, deadlines, and budgets.
Dedication to meet project deadlines in a timely manner.
Excellent verbal communication with peers, project managers and clients
A minimum of 10 years of related data management experience in the environmental or analytical chemistry sector.
B.A. or B.S. in Environmental Science, Environmental Studies, Chemistry, Geology, Database Management, or related field.

Nice To Haves

Knowledge of ArcGIS, Survey 123 and/or US EPA Scribe Software is considered an asset.

Responsibilities

Prepare proposals and data management estimates.
Prepare data management plans
Liaise and coordinate with internal and external clients to provide data management solutions.
Provide mentorship to data managers.
Work on a wide variety of environmental projects at a time, on sites located throughout the United States and internationally.
Manage and organize laboratory, field, spatial and geological data to ensure quality and consistency.
Maintain and query data using EQuIS, MS Access and MS SQL Server
Produce data reports using in-house software and/or specialized queries.
Assist in developing standards and procedures for data management process improvements.
Actively communicate and coordinate with project managers, laboratories, and/or other team members to acquire data packages of varying formats to be imported to a centralized database system.
Prepare submittals for large government clients