Business Analyst IT I

Location: Kansas City, Missouri (Fully Remote)

Duration: 2 years (Extension/FTE possible based on business needs)

Start Date: September 8th, 2026

About the Role

Sun Life is undergoing a large-scale SharePoint retention and migration initiative driven by OSFI findings related to improper retention practices. Globally, thousands of SharePoint sites require remediation; the U.S. alone has ~1,200 sites. All U.S. sites are being migrated to AvePoint, a SharePoint-based platform. The project was originally estimated at 4.5–5 years for the U.S., but the Board has accelerated the timeline to end of 2027 (possibly mid-2028), creating an intensive 12–18 month execution window with 17,000+ hours of work required.

This Business Analyst IT I role supports the SharePoint Migration Program as the reporting and coordination arm of a Tiger Team responsible for coordinating with Information Stewards, executing migration tasks, and ensuring retention compliance. The role is heavily focused on reporting, tracking, follow-ups, issue triage, and SharePoint support.

Responsibilities

• Manage and coordinate BG SharePoint project activities in line with the approved schedule (to be provided).
• Investigate and triage issues impacting deliverables (e.g., site access problems, orphan site ownership assessment).
• Track BG deliverables, execute SharePoint migration tasks, and report status and escalations.
• Prepare and submit SP Migration project KRIs on a scheduled basis.
• Monitor and report progress weekly to the Record Steward and Tiger Team Project Coordinator.

Role Complexity & Volume:

• Approximately 600 Information Stewards globally (56 active for September).
• High volume of follow-ups due to sabbaticals, departures, and bounce-backs.
• Competing Outlook retention project launching September 14 (global 7-year deletion policy), increasing urgency for SharePoint remediation.
• Significant reporting workload across migration schedules, KRIs, and compliance tracking.

Requirements

• Minimum 1 year of relevant experience.
• Advanced Excel skills — pivot tables, automated reporting, workbook validation.
• SharePoint knowledge — basic administration, user management, understanding of parent/child site structures.
• Strong communication skills — high volume of follow-ups and stakeholder coordination.
• Attention to detail — accuracy in reporting, tracking, and documentation.
• Ability to self-manage — work independently within a fast-moving project.
• Ability to take direction — follow guidance from Record Steward and Tiger Team leadership.

Tier 1 background check required.

Schedule

• Monday–Friday, 37.5 hours/week (Flexible hours available).

Pay

$29-33/hour

Benefits

• Medical, dental, vision, life, and disability insurance plans.
• Employee Stock Purchase Program (ESPP).
• 401K program with company match after 12 months of tenure.
• Health Savings Account (HSA) on the HDHP plan.
• SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions.
• Corporate discount savings program and other discounts.
• On-demand training program and access to certification prep, technical/leadership courses, books, and seminars after 6+ months of tenure.
• Certification discounts and perks for associations including CompTIA and IIBA.
• Dedicated customer service team for consultants and a certified Career Coach.