Senior Data Engineer & Analytics Specialist

ERM; United States; On-site; USD 105,000 - 145,000; Full time

Benefits offered by this job

Paid time off

Medical insurance

Dental insurance

Vision insurance

401(k) plan

Life & disability insurance

Job summary

ERM seeks a Senior Data Specialist in the San Francisco Bay Area to support data engineering, analytics, and enterprise data management initiatives within our SF Bay Area operations. This full-time, limited-term (one year) role offers collaboration across multidisciplinary teams and opportunities for renewal.

Ideal candidates will have strong SQL, ETL/ELT, data modeling, and cloud platform experience (Azure/AWS/Snowflake) and be proficient with Power BI or Tableau to deliver scalable analytics

Qualifications

• 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.
• Experience with Power BI or Tableau for dashboards and analytics.
• Exposure to cloud data environments (Azure, AWS, Snowflake).
• Ability to design user-focused dashboards and robust semantic data models in Power BI using Power Query and DAX.
• Ability to perform data QA/QC and maintain governance artifacts.

Responsibilities

• Contribute to design, maintenance, and governance of enterprise data models across systems.
• Develop, optimize, and maintain scalable ETL/ELT pipelines from multiple sources.
• Create analytical datasets to support dashboards and data products; address data quality issues.
• Write and optimize complex SQL queries; document and guide junior team members.
• Translate business requirements into technical data solutions with cross-functional teams.
• Conduct data QA/QC and implement process improvements and automation.

Skills

SQL

Python or R

Power BI

ETL/ELT

Data modeling

Tableau

Git/version control

Power Automate/Power Apps

Communication

Team collaboration

Education

Bachelor’s degree in data science/CS/IS

Tools

SQL Server

PostgreSQL

Azure

AWS

Snowflake

Power Automate

Power Apps

Git

Job description

ERM seeks a Senior Data Specialist in the San Francisco Bay Area to support data engineering, analytics, and enterprise data management initiatives within our SF Bay Area operations. This full-time, limited-term (one year) role offers collaboration across multidisciplinary teams and opportunities for renewal.

Ideal candidates will have strong SQL, ETL/ELT, data modeling, and cloud platform experience (Azure/AWS/Snowflake) and be proficient with Power BI or Tableau to deliver scalable analytics