ERM is seeking a Senior Data Specialist in the San Francisco Bay Area to support data engineering, analytics, and enterprise data management initiatives within our San Francisco Bay Area operations. This is a full‑time (40 hours/week), limited‑term (one‑year) position with the potential for renewal. The ideal candidate will possess strong technical capabilities in data engineering, cloud platforms, and database administration, and will operate effectively within a collaborative, multidisciplinary team environment.
Responsibilities
- Contribute to the design, maintenance, and governance of enterprise data models to ensure accuracy, integrity, and consistency across systems.
- Develop, enhance, and maintain scalable ETL/ELT pipelines that integrate data from multiple sources while ensuring performance and reliability.
- Create and sustain analytical datasets that support dashboards, reporting tools, and data products, and resolve associated data quality issues.
- Write, review, and optimize complex SQL queries and transformation logic; maintain technical documentation and provide guidance to junior team members.
- Translate business and functional requirements into technical data solutions and collaborate with cross‑functional teams to deliver effective analytics outputs.
- Conduct data validation and QA/QC activities; identify and implement process improvements and automation opportunities to increase operational efficiency.
Required 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.
- Working knowledge of Power Automate and Power Apps.
- Experience preparing datasets for reporting and dashboards using Power BI or Tableau.
- Exposure to cloud data environments (e.g., Azure, AWS, Snowflake) related to storage, pipelines, or analytics workloads.
- Ability to perform data QA/QC activities and maintain documentation, metadata, and related governance artifacts.
- Ability to design user‑focused dashboards and develop robust semantic data models in Power BI using Power Query and DAX.
- Experience optimizing Power BI performance, managing workspace publishing and refresh schedules, and implementing role‑based security.
- Demonstrated ability to work collaboratively within multidisciplinary teams and deliver high‑quality work within