Senior 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.

• 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.

• 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 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 manner.

• Experience working with environmental data or environmental information systems.
• Advanced SQL expertise, including performance tuning, stored procedures, complex transformations, and optimization of large datasets.
• Advanced proficiency in DAX and Power BI optimization (e.g., incremental refresh, composite models, deployment pipelines).
• Experience with data cataloging and governance tools.
• Familiarity with Dev Ops and CI/CD workflows, Git branching strategies, and automated testing frameworks.
• Experience contributing to or leading technical solution design and mentoring junior staff.
• Knowledge of data security, privacy standards, and protection controls.

Pay Transparency:
For the Senior Data Specialist position, we anticipate the annual base pay of $104,572 - $144,560, $50.28 -$69.50/hr USD, limited-term, non‑exempt. An employee’s pay position within this range will be…