> Markdown version of [/jobs/ext/3701251-senior-data-specialist-field-based](https://www.wearedevelopers.com/jobs/ext/3701251-senior-data-specialist-field-based). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Senior Data Specialist (Field Based)

- **Company:** ERM Group, Inc.
- **Location:** Walnut Creek, CA, United States
- **Experience:** Expert
- **Salary:** $104,582.0 - $144,560.0
- **Contract:** Temporary contract
- **Skills:** Amazon Web Services, Data Analysis, Microsoft Azure, Big Data, Cloud Database, Information Systems, Continuous Integration, Data Validation, Information Engineering, Extract Transform Load (ETL), Data Security, Relational Databases, DevOps, Python (Programming Language), PostgreSQL, Metadata, Meta-Data Management, Microsoft SQL Server, Performance Tuning, Power BI, SQL Stored Procedures, SQL Databases, Tableau (Software), Technical Data Management Systems, Enterprise Data Management, Privacy Controls, Data Processing, Freeform SQL, Microsoft Power Automate, Delivery Pipeline, Snowflake, Git, Powerquery, Git Flow, Information Technology, Tools for Reporting, Software Version Control, Data Pipelines, Powerapps
- **Published:** October 12, 2026
- **Apply:** https://www.erm.com/careers/apply/

## About the Role

* 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., * 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.

## 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., * 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.