Senior Consultant, Sustainability Data Analysis & Engineering

Key Skills

Microsoft-Excel, Java Programming, Design, Python Programming, Database, SQL, PowerBI, SQL Server, Tableau, R Programming, Data Engineering, Powerpoint

Job Description

At WSP, we are driven by inspiring future-ready pioneers to innovate. We’re looking to grow our teams with people who are ready to collaborate in building communities and expanding our skylines. To do this, we hire candidates of all backgrounds. That’s why here at WSP, inclusion, diversity, equity and belonging are core principles. Anything is within our reach and yours as a WSP employee. Come join us and help shape the future!

This Opportunity

WSP USA's Climate Resiliency and Sustainability practice has an immediate opening for a Senior Consultant, Sustainability Data Analysis & Engineering to support the company's growing Sustainability, Energy and Climate Change offering. See WSP - Advancing Sustainability for a description of our team and capabilities. This position can be based in Arlington, VA, Portland, OR, San Diego, CA, Boulder, CO, San Francisco, CA, Chicago, IL, New York, NY, or other WSP USA office locations across the U.S..

The individual will support a client-facing team to solve next-generation sustainability challenges through data intelligence and strategic program development, design, and implementation. The ideal candidate will have the flexibility and capacity to work on a wide variety of projects and the demonstrated ability to work well with cross-functional teams. Candidates should be passionate about sustainability and data, self-motivated and self-directed, collaborative, and able to produce high-quality work products.

Your Impact

• Developing and maintaining business intelligence dashboards (e.g., Power BI, Tableau), visualizations, and analytical tools
• Designing, implementing, maintaining, and upgrading sustainability databases and platforms
• Establishing ETL processes to collect, clean, and transform sustainability data across a variety of data systems and structures
• Performing advanced data analysis such as scenario analysis, predictive modeling, and machine learning
• Support development of scopes and budgets for data-focused projects and tasks
• Preparing inventories, performance metrics, and reports for energy, GHG, water, waste, and other resource data
• Developing trainings and internal education resources to support growth of internal analytics capabilities
• Supporting the identification and evaluation of opportunities to achieve energy, GHG, and resource reductions
• Researching leading sustainability programs and initiatives
• Producing sustainability reports, disclosures, and other communications
• Managing projects and project teams
• Supporting business development activities with existing and prospective clients

Who You Are

Required Qualifications

• Bachelor's Degree in in Computer Science, Data Science, Engineering, Energy, Sustainability, Public Policy, Environmental Studies or related
• 5-7 years of related professional experience in data engineering, analysis, business intelligence, and/or dashboard development with a preferred focus on sustainability, energy, engineering, management consulting topics
• Ability to design, implement, and maintain dashboards in Microsoft Power BI, Tableau, or comparable programs
• Ability to implement advanced analytical techniques such as data cleansing, statistical analysis, machine learning, and/or predictive modeling
• Ability to engage directly with clients to document and translate client business requirements into tangible project tasks, milestones, and/or other deliverables
• Ability to develop and present analyses using programs including Microsoft Excel, Power Point, and Power BI
• Ability to derive accurate, clear, and meaningful insights from large and complex datasets
• Ability to work independently, multitask, and manage time efficiently
• Ability to collaborate remotely across geographies and platforms
• Well-developed interpersonal skills, maturity, credibility, confidence, and integrity
• Strong oral and written communication skills and use of programs including Microsoft Word and PowerPoint
• Exercise responsible and ethical decision-making regarding company funds, resources and conduct and adhere to WSP's Code of Conduct and related policies and procedures
• Proven track record of upholding workplace safety and ability to abide by WSP's health, safety and drug/alcohol and harassment policies

Preferred Qualifications:

• Master's Degree in one of the above-referenced disciplines
• Expertise in data engineering, database design, and database administration in different environments, such as SQL Server
• Competence in programming for data analysis (e.g., SQL, R, Python, DAX, M) and ability to learn new software systems and tools
• Knowledge of GHG, energy, water, waste, and other sustainability resource metrics and KPIs
• Experience scoping and budgeting data services and products with an understanding of team capabilities
• Familiarity with sustainability issues and frameworks such as CDP, GRI, DJSI, SASB, and the GHG Protocol preferred
• Experience working in virtual environments