Senior Consultant Data Analysis & Engineering, WSP

Senior Consultant Data Analysis & Engineering, WSP

Company WSP
Job title Senior Consultant, Data Analysis & Engineering
Job location United States
Type Full Time

Responsibilities:

  • 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 the 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 training and internal education resources to support the 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
  • Gathering business requirements for data use and business case

Requirements & Skills:

  • Bachelor’s Degree with a concentration in Computer Science or Data Science. , Engineering, Energy, Sustainability, Public Policy, Environmental Studies or related
  • Minimum of 6 years of related professional experience in data engineering, analysis, business intelligence, and/or dashboard development with a recent  focus on sustainability, energy, engineering, and 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 and functionality such as Power Query
  • 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
  • Master’s Degree in Computer Science or Data Science, Engineering, Energy, Sustainability, Public Policy, or Environmental Studies.
  • 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

apply for job button