Data Specialist (Field Based)

ERM • Torrance, CA

23h • $77,383 - $104,752

About The Position

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.

Requirements

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

Nice To Haves

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

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.

Benefits

• We offer a comprehensive package of benefits including paid time off, medical, dental, vision, 401(k), life & disability insurance to benefits eligible employees.
• Benefits Eligibility is limited to Regular employees regularly scheduled to work 20 or more hours per week.
• Fixed-Term employees (including Flexforce) who are regularly scheduled to work 20 hours a week or more are eligible for a limited benefits package.
• Casual employees are NOT benefits eligible.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level