Senior Data Specialist - ETL, BI & Data Modeling (Bay Area)

ERM; San Jose (CA); On-site; USD 104,572 - 144,560; Full time

Benefits offered by this job

Comprehensive benefits package

Paid time off

401(k)

Job summary

ERM is seeking a Senior Data Specialist in the San Francisco Bay Area to support data engineering and analytics initiatives. This full-time position involves designing enterprise data models, developing scalable ETL/ELT pipelines, and working with a cross-functional team.

The ideal candidate will have extensive experience in SQL, database management, and analytics tools like Power BI. ERM offers a comprehensive benefits package including health and retirement plans.

Qualifications

• 5+ years of relevant professional experience.
• Hands-on experience in ETL/ELT development.
• Ability to design user-focused dashboards using Power BI.

Responsibilities

• Contribute to the design and governance of enterprise data models.
• Develop, enhance, and maintain scalable ETL/ELT pipelines.
• Write and optimize complex SQL queries.

Skills

SQL

Data modeling principles

ETL/ELT workflows

Python or R

Power BI

Tableau

Azure

AWS

Snowflake

DAX

Education

Bachelor’s degree in data science, computer science, information systems or related discipline

Tools

SQL Server

PostgreSQL

Power Automate

Power Apps

Job description

ERM is seeking a Senior Data Specialist in the San Francisco Bay Area to support data engineering and analytics initiatives. This full-time position involves designing enterprise data models, developing scalable ETL/ELT pipelines, and working with a cross-functional team.

The ideal candidate will have extensive experience in SQL, database management, and analytics tools like Power BI. ERM offers a comprehensive benefits package including health and retirement plans.