Senior Data Specialist (Field Based)

Walnut Creek, California, USFull-time$105k–$145k2026-06-09 → 2026-11-11

Core

Design, maintain, and govern enterprise data models and ETL/ELT pipelines to support analytics, dashboards, and reporting tools for business stakeholders.

Role type

Senior Data Specialist (Data Engineering & Analytics)

Builds

Scalable ETL/ELT pipelines, analytical datasets, and user-focused dashboards (Power BI/Tableau)

Domain

Sustainability consulting / Environmental data / Enterprise Data Management

Required skills

SQL, relational databases (SQL Server, PostgreSQL), ETL/ELT workflows, Python or R, Power BI, Tableau, cloud data environments (Azure, AWS, Snowflake), data QA/QC, data modeling

Preferred skills

Environmental data systems, advanced SQL performance tuning, DAX optimization, data cataloging, DevOps/CI/CD, mentoring

Technologies

SQL Server, PostgreSQL, Python, R, Power Automate, Power Apps, Power BI, Tableau, Azure, AWS, Snowflake, Git

Responsibilities

Design and maintain enterprise data models; Develop and optimize ETL/ELT pipelines; Create analytical datasets for dashboards and reporting; Write and optimize complex SQL queries; Translate business requirements into technical data solutions; Conduct data validation and QA/QC activities

Seniority

Senior, hands-on IC

About erm

ERM is seeking established and emerging executive leaders to join our global consulting firm as a Consulting Partner, Site Investigation and Remediation (SIR) based in Toronto or Ottawa. This is a unique opportunity to become an owner and shareholder in the world's leading sustainability consultancy while helping clients tackle complex environmental liabilities, unlock asset value, and achieve their long-term sustainability objectives. As a Partner, you will combine technical excellence, business leadership, and strategic client engagement to drive growth, mentor future leaders, and shape the