Managing Technical Consultant, Data Analytics & Visualization - San Francisco Bay Area

Shape the future of data-driven sustainability solutions.

ERM is seeking a Managing Technical Consultant, Data Analytics & Visualization in the San Francisco Bay Area to support data engineering, analytics, reporting, and workflow automation initiatives.

Why This Role Matters?

This role plays a critical part in delivering scalable data solutions, improving data quality and governance, and enabling smarter, faster decision-making across teams.

You will work collaboratively with multidisciplinary stakeholders while contributing to solution delivery and mentoring junior staff.

What Your Impact Is:

his position is central to advancing ERM’s data capabilities by ensuring high-quality, reliable, and actionable data across systems.

The Senior Data Specialist supports both technical delivery and operational efficiency, helping teams transform data into insights that drive business and sustainability outcomes.

What You'll Bring:

Required


* Bachelor’s degree in data science, computer science, information systems, or a related discipline or equivalent experience


* 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 leveraging Microsoft Power Platform to support workflow-driven solutions and process automation (e.g., Power Apps, Power Automate)


* Experience preparing datasets for reporting and dashboards using Power BI or Tableau


* Experience with 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 semantic data models in Power BI using Power Query and DAX


* Experience managing Power BI publishing, refresh schedules, and role-based security


* Experience designing and implementing workflows or process improvements that support operational efficiency and consistency


* Demonstrated ability to work collaboratively within multidisciplinary teams and deliver high-quality work within established timelines and budgets


* Demonstrated ability to coordinate work, define priorities, and support delivery execution


* Strong written, verbal, and interpersonal communication skills


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


* This position is not eligible for immigration sponsorship

Preferred


* Experience working with environmental data or environmental information systems, including environmental permitting, regulatory compliance workflows, sustainability (ESG) reporting, and health and safety...