SharePoint Solutions Designer

Commencement

The SharePoint Solutions Designer will serve in a 6-month full-time limited term role supporting the Volunteer Experience teams. This role will assess current SharePoint sites, lists, libraries, reports, and workflows; improve data structure and integrity; develop reporting solutions; and optimize workflow automation to improve efficiency, visibility, and user experience.

Qualifications

• The ideal candidate is both analytical and hands-on, capable of conducting discovery work while delivering practical, scalable solutions.

Compensation

The annual compensation range for this position is $85,000 to $90,000 (compensation will be prorated to reflect the contract term).

Work Location

This is a 6-month limited term contract and full time, REMOTE position.

How You’ll Contribute

Discovery & Assessment

• Conduct current-state assessment of existing SharePoint sites, lists, libraries, reports, and workflows used by the Volunteer Experience teams.
• Gather requirements from Volunteer Experience, P&C Operations, IT, and other key stakeholders.
• Document data architecture, permissions, and process dependencies.
• Identify data integrity issues, duplication, and structural gaps.
• Provide recommendations for improved information architecture and governance.

Data Structure & Cleanup

• Redesign and standardize SharePoint lists and libraries.
• Support data cleanup, standardization, and migration activities in partnership with business owners.
• Establish naming conventions and metadata standards.
• Recommend and implement approved permission improvements in coordination with IT and business owners.

Reporting & Analytics

• Design and develop Power BI dashboards to support: global volunteer recruiting metrics, onboarding pipeline tracking, and operational reporting for Ship P&C Operations.
• Ensure clean data connections and sustainable reporting models.
• Define sustainable data refresh and ownership processes.
• Train stakeholders on report usage and interpretation.

Workflow Automation & Optimization

• Assess and improve existing Power Automate workflows.
• Develop new automated workflows to streamline volunteer intake, approvals, status changes, and cross-team handoffs.
• Reduce manual processes and improve process visibility.
• Ensure workflows are documented, supportable, and aligned with Microsoft 365 governance standards.
• Provide knowledge transfer for internal teams.

Key Deliverables (End of Term)

• Documented current-state assessment and improvement roadmap.
• Cleaned and standardized SharePoint data structures.
• Functional Power BI dashboards for core Volunteer Experience metrics.
• Optimized and documented automated workflows.
• Knowledge transfer materials for internal teams.

Additional Responsibilities

• Maintains alignment and upholds Mercy Ships Core Values, Code of Conduct, and follows the policies and procedures published on Compass.
• Follows the model of Jesus and aligns with our core values by Loving God; Loving and Serving Others; Being a Person of Integrity; and a Person of Excellence in all you say and do.
• Other duties may be assigned that are not included in the information provided in this job description.

Requirements

• Experience with Power Automate workflow design.
• Experience with data structure design and cleanup initiatives.
• Experience with Microsoft Lists and SharePoint list architecture.
• Experience with Power Query and basic data modeling concepts.
• Ability to conduct business process discovery and translate findings into technical solutions.
• Ability to document technical solutions for non-technical stakeholders.
• Experience creating user-friendly forms, views, and process dashboards.
• Experience supporting HR, recruiting, or volunteer programs.
• Understanding of data governance best practices.
• Familiarity with SharePoint permissions, Microsoft 365 groups, and role-based access.
• Experience improving user experience within SharePoint environments.
• Strong communication skills with business stakeholders.
• Experience with JSON column/view formatting, Power Apps, or Dataverse is a plus.
• Familiarity with Microsoft 365 governance, retention, sensitivity, or compliance concepts is a plus.