Data Specialist: ETL, SQL & Dashboards (SF)

ERM; United States; On-site; USD 69,000 - 85,000; Full time

Benefits offered by this job

Benefits package

Paid time off

Job summary

ERM is seeking a Data Specialist in the San Francisco Bay Area for data management and analytics. This full-time, limited-term position collaborates with senior staff to deliver data solutions and insights.

You will build data models, support ETL/ELT pipelines, and assist in dashboard development using Power BI or Tableau. The role emphasizes data validation, documentation, and cross-functional teamwork in a sustainability-focused consultancy.

Qualifications

• Bachelor’s degree in data science, computer science, information systems, or a related field.
• 1–3 years of relevant professional experience or internships.
• Experience writing SQL queries and working with relational databases (e.g., SQL Server, PostgreSQL).
• Foundational knowledge of ETL/ELT concepts and support for simple data pipelines.
• Basic 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 and QA/QC; maintain documentation.
• Clear written and verbal communication; strong team player.
• Ability to quickly learn new tools and contribute to deliverables.

Responsibilities

• Develop and maintain enterprise data models.
• Support ETL/ELT workflows across sources.
• Prepare datasets for reporting and dashboards; troubleshoot data quality.
• Write basic to intermediate SQL queries and document data structures.
• Translate business requirements into data tasks and implement solutions.
• Conduct data validation, QA/QC checks, and process improvements.
• Support dashboard development in Power BI or Tableau with basic DAX/Power Query.

Skills

SQL queries

Power BI/Tableau

Python or R

Data modeling concepts

ETL/ELT concepts

Cloud platforms (Azure/AWS/Snowflake)

Documentation & QA/QC

Team collaboration

Education

Bachelor’s degree in data science/CS/IS or related

Tools

SQL Server

PostgreSQL

Power BI

Tableau

Azure/AWS/Snowflake

Git/Version control

Job description

ERM is seeking a Data Specialist in the San Francisco Bay Area for data management and analytics. This full-time, limited-term position collaborates with senior staff to deliver data solutions and insights.

You will build data models, support ETL/ELT pipelines, and assist in dashboard development using Power BI or Tableau. The role emphasizes data validation, documentation, and cross-functional teamwork in a sustainability-focused consultancy.