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 ERMs 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 Bachelors 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 data management Advanced SQL expertise, including performance tuning, stored procedures, and optimization of large datasets Advanced Power BI expertise, including performance optimization and large dataset strategies (e.g., incremental refresh, composite models, deployment pipelines) Experience with data cataloging or enterprise data 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 Key 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 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 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 For the Managing Technical Consultant, Data Analytics & Visualization position, the anticipated annual base pay is $94,800$121,312 (USD). Actual pay will depend on factors such as education, experience, skills, location, performance, and business needs. In some cases, pay may fall outside this range. This role may be eligible for bonus pay (casual and fixed term/flex force employees are not bonus eligible). We offer a comprehensive benefits package, including paid time off, parental leave, medical, dental, vision, life, disability, AD&D insurance, 401(k) or RRSP/DPSP, and other applicable benefits to eligible employees. Note: Bonuses, commissions, and other forms of additional compensation are not guaranteed and subject to the sole discretion of ERM and its policies and procedures. Who We Are: As the largest global pure play sustainability consultancy, we partner with the worlds 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! #LI-CVC #LI-Hybrid At ERM, sustainability is our business. We are the worlds largest advisory firm focused solely on sustainability, offering unparalleled expertise across business and finance. ERM partners with clients to operationalize sustainability at pace and scale, through our unique combination of strategic transformation and technical delivery capabilities. Our diverse global team of experts works with the worlds leading organizations to help them set clear sustainability targets, measure progress and operationalize strategy through deep implementation and business transformation. With more than 50 years of experience, our ability to integrate sustainability solutions and our depth and breadth of technical knowledge are why organizations choose to partner with us as their trusted advisor. Every one of us firmly believes in the potential to create value for our clients through an integrated approach to sustainability (because we have personally seen it and professionally achieved it). Our team members are passionate about client service. We work closely with our clients to help them operationalize their sustainability goals and meet their environmental, health and safety objectives while advancing ERMs purpose through delivering tangible progress in what the United Nations coined The Decade of Action. Organizing our people across globally integrated communities of technical and strategic talent positions ERM to be a boots to boardroom leader in bringing that value creation to our clients, partners, and the world. We recruit exceptional professionals with a personal and professional passion for sustainability and nurture them to even greater success as specialists. We prepare our consultants to bring integrated, innovative and sustainable solutions to our clients and provide opportunities for ongoing development across a variety of subject areas related to technical, business, and personal growth. At ERM, effort pays off and becomes career defining work that leaves a positive imprint on our planet. ERM Homepage Explore All Open Roles Explore Early Careers Roles Explore Experienced Professional Roles Explore Partnership Roles