Senior Data Specialist (Field Based)
Walnut Creek, California
- Pay
Multiple pay amounts — pay source
Pay Transparency: For the Senior Data Specialist position, we anticipate the annual base pay of $104,572 - $144,560, $50.28 -$69.50/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.
Read the full posting- Work setting
- Not stated
- Employment
Full-time — employment source
Employment type in the employer’s listing: Full time
From the employer’s posting
What you’ll work on
Full postingBuild and maintain scalable ETL/ELT pipelines integrating multiple data sources
Design and govern enterprise data models for accuracy and consistency
Create analytical datasets for dashboards and reporting, and fix data quality issues
Write and optimize complex SQL queries and transformation logic
Run data validation and QA/QC, and automate processes
From the employer’s posting
Develop, enhance, and maintain scalable ETL/ELT pipelines that integrate data from multiple sources
Contribute to the design, maintenance, and governance of enterprise data models
Create and sustain analytical datasets that support dashboards, reporting tools, and data products
Write, review, and optimize complex SQL queries and transformation logic
Conduct data validation and QA/QC activities; identify and implement process improvements and automation opportunities
What you’ll bring
All qualificationsCore experience
- 5+ years of relevant professional experience.
- Proficiency in SQL, relational databases (e.g., SQL Server, PostgreSQL), and foundational data modeling principles.
- Experience preparing datasets for reporting and dashboards using Power BI or Tableau.
- Ability to perform data QA/QC activities and maintain documentation, metadata, and related governance artifacts.
- Ability to design user‑focused dashboards and develop robust semantic data models in Power BI using Power Query and DAX.
- Experience optimizing Power BI performance, managing workspace publishing and refresh schedules, and implementing role‑based security.
Preferred experience
- Bachelor’s degree in data science, computer science, information systems, or a related discipline is preferred.
- Experience working with environmental data or environmental information systems.
- Experience with data cataloging and governance tools.
- Familiarity with DevOps and CI/CD workflows, Git branching strategies, and automated testing frameworks.
Qualification wording
5+ years of relevant professional experience.
Proficiency in SQL, relational databases (e.g., SQL Server, PostgreSQL), and foundational data modeling principles.
Experience preparing datasets for reporting and dashboards using Power BI or Tableau.
Ability to perform data QA/QC activities and maintain documentation, metadata, and related governance artifacts.
Ability to design user‑focused dashboards and develop robust semantic data models in Power BI using Power Query and DAX.
Experience optimizing Power BI performance, managing workspace publishing and refresh schedules, and implementing role‑based security.
Bachelor’s degree in data science, computer science, information systems, or a related discipline is preferred.
Experience working with environmental data or environmental information systems.
Experience with data cataloging and governance tools.
Familiarity with DevOps and CI/CD workflows, Git branching strategies, and automated testing frameworks.
Education & alternatives
Required Qualifications - Bachelor’s degree in data science, computer science, information systems, or a related discipline is preferred. - 5+ years of relevant professional experience.
Tools in this posting
- Python
- R
- SQL
- AWS
- Azure
- PostgreSQL
- Power BI
- Power Query
- Snowflake
- SQL Server
- Tableau
Source — Tool mentions in context
- Hands‑on experience developing or supporting ETL/ELT workflows. - Working knowledge of Python or R for data processing; familiarity with version control practices. - Working knowledge of Power Automate and Power Apps.
- Create and sustain analytical datasets that support dashboards, reporting tools, and data products, and resolve associated data quality issues. - Write, review, and optimize complex SQL queries and transformation logic; maintain technical documentation and provide guidance to junior team members. - Translate business and functional requirements into technical data solutions and collaborate with cross‑functional teams to deliver effective analytics outputs.
- 5+ years of relevant professional experience. - Proficiency in SQL, relational databases (e.g., SQL Server, PostgreSQL), and foundational data modeling principles. - Hands‑on experience developing or supporting ETL/ELT workflows.
- Experience working with environmental data or environmental information systems. - Advanced SQL expertise, including performance tuning, stored procedures, complex transformations, and optimization of large datasets. - Advanced proficiency in DAX and Power BI optimization (e.g., incremental refresh, composite models, deployment pipelines).
- Experience preparing datasets for reporting and dashboards using Power BI or Tableau. - Exposure to cloud data environments (e.g., Azure, AWS, Snowflake) related to storage, pipelines, or analytics workloads. - Ability to perform data QA/QC activities and maintain documentation, metadata, and related governance artifacts.
- Working knowledge of Power Automate and Power Apps. - Experience preparing datasets for reporting and dashboards using Power BI or Tableau. - Exposure to cloud data environments (e.g., Azure, AWS, Snowflake) related to storage, pipelines, or analytics workloads.
- Ability to perform data QA/QC activities and maintain documentation, metadata, and related governance artifacts. - Ability to design user‑focused dashboards and develop robust semantic data models in Power BI using Power Query and DAX. - Experience optimizing Power BI performance, managing workspace publishing and refresh schedules, and implementing role‑based security.
- Ability to design user‑focused dashboards and develop robust semantic data models in Power BI using Power Query and DAX. - Experience optimizing Power BI performance, managing workspace publishing and refresh schedules, and implementing role‑based security. - Demonstrated ability to work collaboratively within multidisciplinary teams and deliver high‑quality work within established timelines and budgets.
- Advanced SQL expertise, including performance tuning, stored procedures, complex transformations, and optimization of large datasets. - Advanced proficiency in DAX and Power BI optimization (e.g., incremental refresh, composite models, deployment pipelines). - Experience with data cataloging and governance tools.
About Erm Holding
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.
In the employer’s words · Read in context
Posting record
Report an errorOpen 4 monthsWe first saw this listing 139 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.
- Status in our records
- Live
- First seen by us
- Jun 4, 2026 · 139 days ago
- Recorded sightings
- 236
- Last seen by us
- Oct 22, 2026
These dates show when we found the listing. Check the employer’s website to confirm it is still accepting applications.
Your next step
- Have your resume and examples of relevant work ready.
- Check the listed location, eligibility and core experience before starting.
Complete your application on erm.wd3.myworkdayjobs.com. The employer’s form will show what is required.
Already applied? Track this application
Job description
ERM is seeking a Senior Data Specialist in the San Francisco Bay Area to support data engineering, analytics, and enterprise data management initiatives within our San Francisco Bay Area operations. This is a full‑time (40 hours/week), limited‑term (one‑year) position with the potential for renewal. The ideal candidate will possess strong technical capabilities in data engineering, cloud platforms, and database administration, and will operate effectively within a collaborative, multidisciplinary team environment.
Responsibilities
- Contribute to the design, maintenance, and governance of enterprise data models to ensure accuracy, integrity, and consistency across systems.
- Develop, enhance, and maintain scalable ETL/ELT pipelines that integrate data from multiple sources while ensuring performance and reliability.
- Create and sustain analytical datasets that support dashboards, reporting tools, and data products, and resolve associated data quality issues.
- Write, review, and optimize complex SQL queries and transformation logic; maintain technical documentation and provide guidance to junior team members.
- Translate business and functional requirements into technical data solutions and collaborate with cross‑functional teams to deliver effective analytics outputs.
- Conduct data validation and QA/QC activities; identify and implement process improvements and automation opportunities to increase operational efficiency.
Required Qualifications
- Bachelor’s degree in data science, computer science, information systems, or a related discipline is preferred.
- 5+ years of relevant professional experience.
- Proficiency in SQL, relational databases (e.g., SQL Server, PostgreSQL), and foundational data modeling principles.
- Hands‑on experience developing or supporting ETL/ELT workflows.
- Working knowledge of Python or R for data processing; familiarity with version control practices.
- Working knowledge of Power Automate and Power Apps.
- Experience preparing datasets for reporting and dashboards using Power BI or Tableau.
- Exposure to cloud data environments (e.g., Azure, AWS, Snowflake) related to storage, pipelines, or analytics workloads.
- Ability to perform data QA/QC activities and maintain documentation, metadata, and related governance artifacts.
- Ability to design user‑focused dashboards and develop robust semantic data models in Power BI using Power Query and DAX.
- Experience optimizing Power BI performance, managing workspace publishing and refresh schedules, and implementing role‑based security.
- Demonstrated ability to work collaboratively within multidisciplinary teams and deliver high‑quality work within established timelines and budgets.
- Strong written, verbal, and interpersonal communication skills.
- Ability to learn new technologies quickly, work independently, and produce technical deliverables in a timely manner.
Preferred Qualifications
- Experience working with environmental data or environmental information systems.
- Advanced SQL expertise, including performance tuning, stored procedures, complex transformations, and optimization of large datasets.
- Advanced proficiency in DAX and Power BI optimization (e.g., incremental refresh, composite models, deployment pipelines).
- Experience with data cataloging and governance tools.
- Familiarity with DevOps and CI/CD workflows, Git branching strategies, and automated testing frameworks.
- Experience contributing to or leading technical solution design and mentoring junior staff.
- Knowledge of data security, privacy standards, and protection controls.
Pay Transparency:
For the Senior Data Specialist position, we anticipate the annual base pay of $104,572 - $144,560, $50.28 -$69.50/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.
You can apply for this role through https://www.erm.com/careers/apply/ or through the internal careers portal if you are a current employee.
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.
Please submit your resume and brief cover letter. Based on review of these responses, shortlisted candidates will be invited for interviews.
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 not responsible for any fees related to unsolicited resumes.
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!
Source details
Source notes
Source excerptsSelected passages from the saved posting. Check the full description for conditions and exceptions.
- Pay
Pay Transparency: For the Senior Data Specialist position, we anticipate the annual base pay of $104,572 - $144,560, $50.28 -$69.50/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.
- Location & working pattern
Walnut Creek, California
Working pattern and location restrictions need checking in the full posting.
- Work authorization
No clear work-authorization passage found. Eligibility is unconfirmed.
See how this role fits your experience
Add your resume to compare the role’s scope, tools and requirements with your experience.