Data Specialist (Field Based)

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.


* 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 established timelines and budgets.


* Strong written, verbal, and interpersonal communication skills.


* Ability to learn new technologies quickly, work independently, and produce technical deliverables in a timely mann...