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. The Ideal Candidate 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.