Data Specialist (Field Based)
ERM, San Jose, CA, United States
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. This position may be eligible for bonus pay.
Benefits Eligibility
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.
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.
#J-18808-Ljbffr
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. This position may be eligible for bonus pay.
Benefits Eligibility
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.
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.
#J-18808-Ljbffr