Assistant Vice President, Senior Analyst

WSP is initiating a search for an Assistant Vice President, Senior Analyst to join our Procurement team. The ideal candidate may be located anywhere in the United States, with a preference for candidates based on the East Coast. Responsible for automation, workflow development, reporting, and operational efficiency initiatives across Procurement, Strategic Sourcing, Subcontracting, Vendor Management, Fleet, and Asset Management. Leverages Microsoft Power Platform, Smartsheet, and related technologies to streamline processes, improve data visibility, and reduce manual effort across the organization.

The role provides independent delivery capacity and backup for critical business solutions, supports billable project work, and builds capability across platforms. The objective is 100% billable utilization over time, with assignments and utilization tracked alongside operational responsibilities.

• Develop and maintain Power Apps solutions to support procurement and operational processes.
• Design, build, and support Power Automate workflows and integrations.
• Assist with integration of business systems and data sources through APIs and connectors.
• Support development and maintenance of Power BI dashboards and operational reporting.
• Partner with business stakeholders to identify and implement automation opportunities.
• Support CLM and procurement system enhancements.
• Create and maintain workflow documentation, training materials, and process maps.
• Assist with supplier performance reporting and vendor management analytics.
• Support subcontracting and procurement process optimization initiatives.
• Develop departmental and business-line reporting to improve visibility and benchmarking.
• Work with internal reporting and IT teams to improve data accessibility and consistency.
• Troubleshoot and enhance existing automation solutions.
• Collaborate regularly with the Lead Business Intelligence Analyst to align automation, analytics, and reporting priorities.
• Own the assigned project pipeline, maintain documented progress updates for Procurement Leadership, and track delivered impact through defined KPIs.
• Assume responsibility for Fleet and Asset Management Smartsheet applications and daily data operations; document workflows and train designated team members to take over routine administration.
• Deliver billable business and project solutions, provide backup for critical integration and HR compensation work streams, and support evaluation or migration to alternative platforms as business needs evolve.

• Required:
  
  hands-on Smartsheet experience, including application administration, forms, automated workflows, and data operations.
• Intermediate experience with Microsoft Power Apps and Power Automate.
• Experience building business workflows and process automation solutions.
• Intermediate experience with Power BI, reporting, and data visualization.
• Experience working with APIs, data connectors, or system integrations.
• Strong Microsoft 365 skills, including SharePoint and Teams.
• Understanding of relational data concepts and reporting structures.
• Experience with Microsoft Dataverse or similar platforms is preferred.
• Project management and requirements-gathering experience, including pipeline tracking and delivery reporting.
• Demonstrated ability to independently build, support, and troubleshoot production solutions from the outset, without foundational technical training.
• Experience delivering solutions across multiple platforms and assessing alternatives to existing tools.

• Process improvement mindset.
• Strong analytical and problem-solving skills.
• Attention to detail.
• Customer-focused approach.
• Cross-functional collaboration.
• Results-oriented with a focus on measurable outcomes.
• Translates complex technical concepts into clear, practical business solutions understood by technical and non-technical stakeholders.
• Creates clear documentation, presentations, and communications that simplify complex processes, technologies, and implementation strategies.
• Uses strong listening and questioning skills to understand business needs and translate them into actionable technical solutions.
• Facilitates productive discussions that balance technical considerations with operational, financial, and strategic business objectives.

• Reduced manual work through automation.
• Improved process consistency and compliance.
• Faster access to operational and procurement data.
• Increased reporting accuracy and…