Erm
Managing Technical Consultant, Data Analytics & Visualization - San Francisco Bay Area
Walnut Creek, California
Sponsorship not specified$95k-$121kDetected 27 days ago
PythonGitSQLPostgreSQLSnowflakeAWSAzureCI/CDDevOpsData AnalysisData EngineeringData ScienceData VisualizationComplianceTest AutomationCommunicationMentoring
About the role
- Shape the future of data-driven sustainability solutions.
- 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.
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
- Design and develop user-focused dashboards and reporting solutions that improve visibility, support decision-making, and align with business workflows
- Write, review, and optimize complex SQL queries and transformation logic; maintain technical documentation and provide guidance to junior team members
- Conduct data validation and QA/QC activities; identify and implement process improvements and automation opportunities to increase operational efficiency
- Design and improve structured workflows that increase standardization, efficiency, and traceability across teams and processes
- Develop and support workflow-driven automation solutions using Microsoft Power Platform tools, including Power Apps and Power Automate
- Support delivery execution by helping define tasks, prioritize work, coordinate across teams, and contribute to solution design and implementation
- Translate business and functional requirements into technical data solutions and collaborate with cross-functional teams to deliver effective analytics outputs
Requirements
- Bachelor's degree in data science, computer science, information systems, or a related discipline or equivalent experience
- Proficiency in SQL, relational databases (e.g., SQL Server, PostgreSQL ), and foundational data modeling principles
- Experience with cloud data environments (e.g., Azure, AWS, Snowflake) related to storage, pipelines, or analytics workloads
Compensation
- For the Managing Technical Consultant, Data Analytics & Visualization position, the anticipated annual base pay is $94,800-$121,312 (USD).
Benefits
- Experience working with environmental data or environmental information systems, including environmental permitting, regulatory compliance workflows, sustainability (ESG) reporting, and health and safety data management
Company info
- As the largest global pure play sustainability consultancy, we partner with the world's leading organizations, creating innovative solutions to sustainability challenges and unlocking commercial opportunities that meet the needs of today while preserving opportunity for future generations.
- At ERM we know that creating a diverse, equitable and inclusive work environment is an essential part of making our company a great place to build a career. We also see our diversity as a strength that helps us create better solutions for our clients. Our diverse team of world-class experts supports clients across the breadth of their organizations to operationalize sustainability, underpinned by our deep technical expertise in addressing their environmental, health, safety, risk and social issues. We call this capability our "boots to boardroom" approach for its comprehensive service model that allows ERM to develop strategic and technical solutions that advance objectives on the ground or at the executive level.
- Please submit your resume and brief cover letter.
- ERM does not accept recruiting agency resumes. Please do not forward resumes to our jobs alias, ERM employees or any other company location. ERM is not responsible for any fees related to unsolicited resumes.
- ERM is proud to be an Equal Employment Opportunity employer.
- We do not discriminate based upon race, religion, color, national origin, gender, sexual orientation, gender identity, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.
- Thank you for your interest in ERM!
- At ERM we know that creating a diverse, equitable and inclusive work environment is an essential part of making our company a great place to build a career.
- We also see our diversity as a strength that helps us create better solutions for our clients.
- Our diverse team of world-class experts supports clients across the breadth of their organizations to operationalize sustainability, underpinned by our deep technical expertise in addressing their environmental, health, safety, risk and social issues.
- We call this capability our "boots to boardroom" approach for its comprehensive service model that allows ERM to develop strategic and technical solutions that advance objectives on the ground or at the executive level.
- ERM does not accept recruiting agency resumes.
- Please do not forward resumes to our jobs alias, ERM employees or any other company location.
- ERM is not responsible for any fees related to unsolicited resumes.
Visa & Work Authorization
- This position is not eligible for immigration sponsorship
This listing is sourced directly from Erm's careers page and normalized into a canonical job model.