Earthsoft EQuISMicrosoft AccessMicrosoft SQL Server
Preferred qualifications
Field of studyChemistry, Environmental Science, Environmental Studies, Geography, Geology (or related)
Study levelDiploma or higher
Original posting
We have an immediate opportunity for a Junior Environmental Data Analyst to join our Environmental Data Management team. In this entry-level role, you will support multiple environmental projects for sites across North America by organizing, validating, loading, and reporting laboratory, field, spatial, and geological data. You will work with experienced data analysts, project managers, technical specialists, field teams, and laboratories to help maintain complete, accurate, and traceable project databases.
This is a hybrid position with an expectation of being in the office ~2-3 days per week.
Your Key Responsibilities
As part of our Data Management Team, you will:
Support several environmental projects at the same time for sites located across North America, while following project-specific requirements, priorities, schedules, and budgets
Receive, organize, review, and manage environmental data from multiple sources, including laboratory-specific electronic data deliverables (EDDs), field-collected data, spatial data, borehole and geological information, and historical records
Perform routine data quality checks to identify missing information, formatting issues, duplicate records, invalid values, unit inconsistencies, and other data anomalies
Load, maintain, query, and extract data using EarthSoft EQuIS, Microsoft Access, and Microsoft SQL Server under established procedures and senior guidance
Apply an understanding of relational database concepts, including tables, keys, joins, and one-to-many relationships, when reviewing, querying, and troubleshooting data
Use knowledge of chemistry, analytical methods, detection limits, units, qualifiers, and laboratory reporting practices to support accurate interpretation and management of environmental analytical data
Prepare routine data summaries, reports, tables, exports, and project deliverables using standard tools, templates, and queries
Communicate with project managers, laboratories, field teams, and other technical staff to obtain required files, resolve data questions, and confirm project requirements
Maintain clear documentation of data receipt, processing, validation, corrections, and delivery to support data traceability and quality assurance
Follow established data management standards, naming conventions, quality procedures, and file-management practices
Manage assigned tasks, track progress, raise questions promptly, and communicate potential schedule or data-quality concerns to the project team
Qualifications
Your Capabilities and Credentials
The ideal candidate will bring the following foundational knowledge, skills, and attributes:
Foundational knowledge of environmental data management and a strong interest in developing technical database skills
Experience with or exposure to EarthSoft EQuIS, Microsoft Access, and Microsoft SQL Server; equivalent database experience will also be considered
Understanding of relational database concepts, including tables, primary and foreign keys, data types, joins, and relationships between datasets
Good background knowledge of general and environmental chemistry, common laboratory analyses, analytical terminology, units, detection limits, and data qualifiers
Experience working with spreadsheets, structured datasets, laboratory EDDs, or field data is an asset
Strong attention to detail and commitment to data accuracy, consistency, completeness, and traceability
Logical problem-solving skills and the ability to investigate data issues methodically
Ability to organize work across multiple projects, manage competing priorities, and meet established deadlines with guidance
Clear written and verbal communication skills and the confidence to ask questions when requirements or data are unclear
Ability to work effectively both independently and as part of a collaborative, geographically distributed team
Ability to meet project deadlines and understand how assigned tasks relate to project goals.
Ability to maintain and establish effective working relationships.
Willingness to learn new software, project requirements, regulatory frameworks, and data management procedures
Familiarity with federal, provincial, state, or municipal environmental guidelines is an asset
Education and Experience
Bachelor’s degree, college diploma, or equivalent training in chemistry, environmental science, environmental studies, geology, geography, or related discipline
Up to two years of relevant experience in environmental data management, analytical chemistry, laboratory data, database support, or a related field; relevant co-op, internship, academic, or project experience is welcome
Coursework or practical experience involving databases, data quality, chemistry, laboratory analyses, or environmental sampling is an asset
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. #StayInquisitive
Grounded in safety, quality, and ethics, our experts lead their fields with dedication, a creative spirit, and a vision for growth. We draw from more than 20 technical specialties worldwide and are devoted to fostering a community of diverse talents, backgrounds, and expertise. Here, you can apply your passion and collaborate with top environmental professionals on work that’s vital to our clients and the communities they serve.
Join a team that’s naturally committed to the environment.
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. Actual compensation for part-time roles will be pro-rated based on the agreed number of working hours per week. Benefits Summary: Regular full-time and part-time employees (working at least 20 hours per week) will have access to health, dental, and vision plans, a wellness program, health care spending account, wellness spending account, group registered retirement savings plan, employee stock purchase program, group tax-free savings account, 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 time off.
Temporary/casual employees will have access to group registered retirement savings plan, employee stock purchase program, and group tax-free savings account.
The benefits information listed above may not apply to union positions because benefits for such positions are governed by applicable collective bargaining agreements.