SharePoint Business Analyst (Data & Automation Focus)

STV is seeking a SharePoint Business Analyst (Data & Automation Focus) to support digital transformation initiatives across transportation and infrastructure programs. The role is preferred to be based in the client office, where close collaboration with the client and project team is part of the day-to-day. For exceptional candidates, hybrid or remote arrangements may be considered.

The Analyst will be responsible for configuring SharePoint, designing Excel templates, and developing Power Automate logic to improve business processes. The role also includes preparing end-user documentation, supporting workflow mapping and process redesign, and providing training materials and QA/QC oversight.

The ideal candidate has strong skills in SharePoint and Microsoft 365 applications, is comfortable leading client-facing sessions, and can translate business needs into clear technical solutions. Experience with Power BI and advanced Power Automate is a plus but not required.

Responsibilities

SharePoint & Microsoft 365 solutions

• Configure SharePoint lists, libraries, views, and permissions.
• Design Excel templates that support data collection, reporting, and integration.
• Develop, test, and optimize Power Automate workflows.
• Perform QA/QC on templates, workflows, and SharePoint configurations.

SharePoint Versions & Migration

• Hands-on experience with SharePoint 2016/2019, including site collection administration.
• Ability to manage and migrate legacy SharePoint content to SharePoint Online (using tools like ShareGate).
• Knowledge of feature differences between on-premises and cloud and governance considerations.

Administration & Configuration

• Deep knowledge of permission models, groups, site templates, and content types across legacy and Online environments.
• Experience with central administration (for older versions).
• Strong understanding of metadata, taxonomy, and search configuration.

Business Process & Workflow Support

• Lead workflow discovery and document current business processes.
• Support process redesign to improve efficiency and alignment with client goals.
• Create workflow diagrams and supporting reference materials.

Training & End-User Support

• Develop training guides, reference documents, and quick-start materials.
• Deliver training sessions and provide hands-on support during UAT and rollout.
• Serve as the primary point of contact for SharePoint and workflow adoption.
• Experience training users transitioning from older versions to SharePoint Online.
• Ability to explain differences in UI, features, and capabilities between environments.

Client engagement

• Facilitate client-facing sessions, including discovery workshops, design reviews, UAT, and training.
• Collaborate with program leadership and technical teams to align solutions with overall program objectives.
• Provide recommendations on best practices for document management and workflow automation.

What You Bring:

• 5+ years of experience in SharePoint configuration, business analysis, data management. AEC industry experience is a plus.
• Bachelor's degree in a related field (e.g., Information Systems, Business, Computer Science, Engineering).

• Comprehensive knowledge of SharePoint Online and prior versions (2016/19), including administration, customization, and migration.
• Proficiency in SharePoint Online and Microsoft 365 tools, including Excel, Power Automate, Teams, Forms, Planner, and OneDrive for Business

• Familiarity with Power BI and data visualization concepts is appreciated but not required.
• Experience with workflow mapping, requirements gathering, and documentation.
• Strong communication skills with the ability to explain technical solutions to non-technical stakeholders.
• Ability to lead client-facing sessions and build trust with diverse teams.
• Comfortable working in dynamic, fast-paced, and client-facing environments.
• Adept at influencing, mentoring, and aligning multidisciplinary teams across geographies to achieve common goals.
• Excellent communication skills with the ability to present ideas clearly and effectively to senior leadership and external stakeholders.
• Willingness to travel as needed for client engagements, projects, workshops, and business development activities.

Why Join Us?

We're relentlessly curious problem-solvers who believe digital transformation is about smarter, more efficient ways of working-not just new tools. Our team is passionate about leveraging technology to drive real impact on the infrastructure that connects our world.

At STV, you'll have the freedom to innovate, lead, and grow while working alongside fun, driven, and collaborative teammates. We move fast, embrace new ideas, and support each other-because that's what makes us successful.

If you love technology, strategy, and problem-solving, and want to help shape the future of digital transformation in AEC, we'd love to hear from you!

Don't meet every single requirement? Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. At STV, we are fully committed to expanding our culture of diversity and inclusion, one that will reflect the clients we serve and the communities we work in, so if you're excited about this role but your past experience doesn't align perfectly with every qualification in the job description we encourage you to apply anyways. You may be just the right candidate for this or other roles.

STV offers the following benefits * Health insurance, including an option with a Health Savings Account * Dental insurance * Vision insurance * Flexible Spending Accounts (Healthcare, Dependent Care and Transit and Parking where applicable) * Disability insurance * Life Insurance and Accidental Death & Dismemberment * 401(k) Plan * Retirement Counseling * Employee Assistance Program * Paid Time Off (16 days) * Paid Holidays (8 days) * Back-Up Dependent Care (up to 10 days per year) * Parental Leave (up to 80 hours) * Continuing Education Program * Professional Licensure and Society Memberships

STV is committed to paying all of its employees in a fair, equitable, and transparent manner. The listed pay range is STV's good-faith salary estimate for this position. Please note that the final salary offered for this position may be outside of this published range based on many factors, including but not limited to geography, education, experience, and/or certifications.