Data Specialist (Field Based)

ERM • Walnut Creek, CA

20h • $69,075 - $84,533

About The Position

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.

Requirements

• 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.

Nice To Haves

• 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.

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.

Benefits

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level