SharePoint Solutions Designer

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. The ideal candidate is both analytical and hands-on, capable of conducting discovery work while delivering practical, scalable solutions.

** The annual compensation range for this position is $85,000 to $90,000 (compensation will be prorated to reflect the contract term). 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.

• 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.

Education & Experience

• 3+ years SharePoint design/development experience
• Strong experience with SharePoint Online in a Microsoft 365 environment.
• Proficiency in Power BI development.
• Experience building Power BI reports using SharePoint lists, Microsoft Lists, Excel, Dataverse, or other Microsoft 365 data sources.

**Compensation range listed is for U.S. hires only. Actual compensation may vary dependent upon location of hire.

4.34.3 out of 5 stars United States Remote $85,000 - $90,000 a year - Full-time

Mercy Ships is a global faith-based charity that uses hospital ships to bring life-changing surgeries and transformational medical training to people in some of the most challenging contexts along the African coast. For over 40 years, Mercy Ships has been delivering lasting hope and healing through safe surgical care, while working alongside partners and stakeholders to strengthen local healthcare systems in more than 55 countries. Since the inception of this dream by founders Don and Deyon Stephens in 1978, Mercy Ships has served more than 2.7 million direct beneficiaries without regard for race, gender, or religion. Do you have a heart for the hurting and a desire to invest your talents and experiences into a mission with eternal significance? For every transformative surgery that takes place onboard one of our Mercy Ships, there are dozens of men and women being used of the Lord to prepare the way through their vocational gifts and talents!