Data Specialist (Field Based)

Environmental Resources Management (ERM); Walnut Creek (CA); On-site; USD 69,000 - 85,000; Full time

Job summary

Environmental Resources Management (ERM) is seeking a Data Specialist in the San Francisco Bay Area to support data management and analytics activities. This full-time, limited-term position spans one year with potential renewal, collaborating with senior staff in a multidisciplinary team.

The ideal candidate has foundational experience in data processing, reporting, and cloud-based tools, including SQL, Power BI or Tableau, and basic Python or R.

Qualifications

• Bachelor’s degree in data science, computer science, information systems, or a related field.
• 1–3 years of relevant professional experience or internships.
• Practical experience writing SQL queries and working with relational databases (e.g., SQL Server, PostgreSQL).
• Foundational knowledge of ETL/ELT concepts and experience supporting or maintaining simple data pipelines.
• Basic proficiency in Python or R for data manipulation; familiarity with version control is a plus.
• Experience preparing datasets for dashboards using Power BI or Tableau.
• Exposure to cloud platforms such as Azure, AWS, or Snowflake.
• Ability to perform data validation, follow QA/QC procedures, and maintain documentation.

Responsibilities

• Assist in the development and maintenance of enterprise data models.
• Support ETL/ELT workflows across multiple sources.
• Prepare datasets for reporting and dashboards; troubleshoot data quality issues.
• Write basic to intermediate SQL queries and document data structures.
• Translate business requirements into clearly defined data tasks and collaborate on solutions.
• Conduct data validation, QA/QC checks, and assist process improvements.
• Support dashboard development in Power BI or Tableau with basic DAX/Power Query.

Skills

SQL proficiency

Python/R

Communication

Team collaboration

Education

Bachelor’s degree in data science/CS/IS

Tools

SQL Server

PostgreSQL

Power BI

Tableau

Azure

AWS

Snowflake

Job description

ERM is seeking a Data Specialist in the San Francisco Bay Area to support data management and analytics activities. This is a full‑time (40 hours/week), limited‑term (one‑year) position with the potential for renewal. The ideal candidate will have foundational technical experience in data processing, reporting, and cloud‑based tools, and will work closely with senior staff in a collaborative, multidisciplinary team environment.

Responsibilities

• Assist in the development and maintenance of enterprise data models, ensuring accuracy and consistency under the guidance of senior team members.
• Support the creation and maintenance of ETL/ELT workflows, including data extraction, transformation, and loading from multiple sources.
• Prepare datasets for reporting and dashboards and help troubleshoot data quality issues.
• Write basic to intermediate SQL queries and help document data structures, workflows, and processes.
• Translate business requirements into clearly defined data tasks and collaborate with team members to implement data solutions.
• Conduct data validation, QA/QC checks, and assist in process improvement activities.
• Support dashboard development in Power BI or Tableau, including data preparation and basic DAX or Power Query transformations.

Required Qualifications

• Bachelor’s degree in data science, computer science, information systems, or a related field.
• 1–3 years of relevant professional experience or internships.
• Practical experience writing SQL queries and working with relational databases (e.g., SQL Server, PostgreSQL).
• Foundational knowledge of ETL/ELT concepts and experience supporting or maintaining simple data pipelines.
• Basic proficiency in Python or R for data manipulation; familiarity with version control is a plus.
• Experience preparing datasets for dashboards using Power BI or Tableau.
• Exposure to cloud platforms such as Azure, AWS, or Snowflake.
• Ability to perform data validation, follow QA/QC procedures, and maintain documentation.
• Clear written and verbal communication skills and the ability to work effectively as part of a team.
• Demonstrated ability to learn new tools and technologies quickly and contribute to project deliverables in a timely manner.

Preferred Qualifications

• Experience with environmental data or environmental information systems.
• Familiarity with Power Automate or Power Apps.
• Understanding of basic data modeling concepts and semantic layer design.
• Exposure to DevOps, CI/CD practices, or Git branching workflows.
• Experience supporting senior technical staff or contributing to solution design discussions.

Pay Transparency

For the Data Specialist position, we anticipate the annual base pay of $69,075– $84,533, $33.20/hr – $40.64/hr USD, limited‑term, non‑exempt. An employee’s pay position within this range will be based on several factors including, but not limited to, relevant education, qualifications, certifications, experience, skills, geographic location, performance, shift, travel requirements, sales or revenue‑based metrics, and business or organizational needs. We also may have instances where employee’s fall outside of the range based on the factors noted above. This job may be eligible for bonus pay (casual and fixed term/Flexforce employees are NOT bonus eligible). We offer a comprehensive package of benefits including paid time off, medical, dental, vision, 401(k), life & disability insurance to benefits eligible* employees. *Benefits Eligibility is limited to Regular employees regularly scheduled to work 20 or more hours per week. Fixed‑Term employees (including Flexforce) who are regularly scheduled to work 20 hours a week or more are eligible for a limited benefits package. Casual employees are NOT benefits eligible. See your recruiter for more details. Note: No amount of pay is considered to be wages or compensation until such amount is earned, determinable, and payable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company’s sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law.

Who We Are

As the largest global pure play sustainability consultancy, we partner with the world’s leading organizations, creating innovative solutions to sustainability challenges and unlocking commercial opportunities that meet the needs of today while preserving opportunity for future generations.

At ERM we know that creating a diverse, equitable and inclusive work environment is an essential part of making our company a great place to build a career. We also see our diversity as a strength that helps us create better solutions for our clients.

Our diverse team of world‑class experts supports clients across the breadth of their organizations to operationalize sustainability, underpinned by our deep technical expertise in addressing their environmental, health, safety, risk and social issues. We call this capability our “boots to boardroom” approach for its comprehensive service model that allows ERM to develop strategic and technical solutions that advance objectives on the ground or at the executive level.

We are a global network that takes a holistic view of sustainability, transitions from nature‑based solutions to circularity, scaling new business models to meet the expectations of ESG and increasingly accountable stakeholders. Our clients read the book of change to create tangible, long‑term prosperity, using science and data. We deliver solutions that help interpret science into action, elevating our clients’ organizational resilience with Travis. Our Foundation, the ERM Academy and the ERM Learning Programme fit local functions in a pragmatic approach with differentiated consulting intensity that enriches our tracks, refines operational proposals, and consolidates continuous improvement activities.

At ERM, sustainability is our business. We are the world’s largest advisory firm focused solely on sustainability, offering unparalleled expertise across business and finance. ERM partners with clients to operationalize sustainability at pace and scale, through our unique combination of strategic transformation and technical delivery capabilities. Our diverse global team of experts works with the world’s leading organizations to help them set clear sustainability targets, measure progress and operationalize strategy through deep implementation and business transformation.

With more than 50 years of experience, our ability to integrate sustainability solutions and our depth and breadth of technical knowledge are why organizations choose to partner with us as their trusted advisor.

Every one of us firmly believes in the potential to create value for our clients through an integrated approach to sustainability (because we have personally seen it and professionally achieved it).

Our team members are passionate about client service. We work closely with our clients to help them operationalize their sustainability goals and meet their environmental, health and safety objectives while advancing ERM’s purpose through delivering tangible progress in what the United Nations coined The Decade of Action.

Organizing our people across globally integrated communities of technical and strategic talent positions ERM to be a “boots to boardroom” leader in bringing that value creation to our clients, partners, and the world.

We recruit exceptional professionals with a personal and professional passion for sustainability and nurture them to even greater success as specialists.

We prepare our consultants to bring integrated, innovative and sustainable solutions to our clients and provide opportunities for ongoing development across a variety of subject areas related to technical, business, and personal growth.

At ERM, effort pays off and becomes career defining work that leaves a positive imprint on our planet.

ERM does not accept recruiting agency resumes. Please do not forward resumes to our jobs alias, ERM employees or any other company location.

ERM is proud to be an Equal Employment Opportunity employer. We do not discriminate based upon race, religion, color, national origin, gender, sexual orientation, gender identity, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.

Thank you for your interest in ERM!