When you care deeply about the work you do, it’s rewarding to see it through from concept to completion. We partner with clients to provide both program management and construction management to strategize, plan, and implement projects that drive organizations forward. From hospitals and airports to university campuses, mass transit systems, water treatment facilities, mines, and wind farms, we've successfully managed thousands of projects. Joining our team, turning visionary ideas into reality, will shape your future—and the future of your community. **Your Opportunity** We have an immediate opportunity for a Senior Environmental Data Management Specialist to join our dynamic PMCM team in Walnut Creek, CA. The successful candidate will work independently as well as within the PMCM Technology Team team to manage database systems, develop data management procedures, assist colleagues in performing data-related tasks, and networking with internal/external clients. **Your Key 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 **Your Capabilities and Credentials** The ideal candidate will possess the following: * 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 * Knowledge of ArcGIS, Survey 123 and/or US EPA Scribe Software is considered an asset. **Education and Experience** 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. This description is not a comprehensive listing of activities, duties or responsibilities that may be required of the employee and other duties, responsibilities and activities may be assigned or may be changed at any time with or without notice. **About Stantec** Stantec is a global leader in sustainable engineering, architecture, and environmental consulting. The diverse perspectives of our partners and interested parties drive us to think beyond what’s previously been done on critical issues like climate change, digital transformation, and future-proofing our cities and infrastructure. We innovate at the intersection of community, creativity, and client relationships to advance communities everywhere, so that together we can redefine what’s possible. * Locations in NYC & CA (Bay Area) & NJ (RP) - Min Salary $ 136,300.00 - Max Salary $ 204,400.00 **Pay Transparency:** In compliance with pay transparency laws, pay ranges are provided for positions in locations where required. Please note, the final agreed upon compensation is based on individual education, qualifications, experience, and work location. At Stantec certain roles are bonus eligible. **Benefits Summary:** Regular full-time and part-time employees (working at least 20 hours per week) have access to medical, dental, and vision plans, a wellness program, health saving accounts, flexible spending accounts, 401(k) plan, employee stock purchase program, life and accidental death & dismemberment (AD&D) insurance, short-term/long-term disability plans, emergency travel benefits, tuition reimbursement, professional membership fee coverage and paid family leave. Regular full-time and part-time employees will receive ten paid holidays in each calendar year. In addition, employees will be eligible to accrue vacation between 10 and 20 days per year and eligible for paid sick leave (and if more generous, in accordance with state and local law). Temporary/casual employees have access to 401(k) plans, employee stock purchase program, and paid leave, in accordance with state and local law. The benefits information listed above may not apply to union positions because benefits for such positions are governed by applicable collective bargaining agreements **Primary Location:** United States | CA | Walnut Creek **Organization:** BC-2349 EnvSvcs-US PMCM **Employee Status:** Regular **Job Level:** Supervisor **Travel:** Yes **Schedule:** Full time **Job Posting:** 24/06/2025 06:06:14 **Req ID:** 1001287