DB Project Coordination Specialist

About Milliman:

Independent for over 70 years, Milliman delivers market-leading services and solutions to clients worldwide. Today, we are helping companies take on some of the world's most critical and complex issues, including retirement funding and healthcare financing, risk management and regulatory compliance, data analytics and business transformation. 

Through a team of professionals ranging from actuaries to clinicians, technology specialists to plan administrators, we offer unparalleled expertise in employee benefits, investment consulting, healthcare, life insurance, and financial services, and property and casualty insurance. 

Job Summary:

The Defined Benefit Project Coordination Specialist is responsible for providing overall oversight and project management for defined benefit administration activities, particularly in relation to system implementations and ongoing client system support within the Employee Benefits Administration Practice. Reporting to the Implementation Team Manager, this role requires a high level of initiative and independent judgment in executing assigned tasks and managing projects. It combines both technical expertise and project management capabilities.

Duties/Responsibilities:

• Project Review & Requirement Validation: Review open projects for existing clients, verify business requirements, and ensure corresponding test cases are captured in new tasks.
• Process Coordination: Collaborate with the Systems Team Manager to coordinate and implement processes for both new and ongoing defined benefit plans.
• Project Setup & Resource Allocation: Add new projects to the Open Projects List and coordinate with the Systems Team Manager to assign appropriate resources.
• Folder Structure Management: Create structured folders using proper naming conventions, following standardized implementation procedures.
• Project Communication: Send comprehensive emails to all parties involved outlining:
  • Expected promotion date.
  • List of tickets included.
  • Timeline for each step: Configuration, Peer Review, UAT, Management Review, Promotion Sign-Off, Risk Review, and Promotion Date.
  • Link to the plan design folder.
• Task Assignment & Documentation: Assign MPAD tickets to designated resources and update the relevant checklist documents accordingly.
• Engineer Notification: Notify the Project Engineer via email:
  • Required communications have been sent.
  • Scenario Group cover sheet and Risk Tool have been created
• Project Monitoring & Updates: Monitor project progress as needed, ensuring the Project Engineer is copied on all related emails. Discuss project updates in the weekly resource meeting.
• Client Support & Project Management: Support ongoing work management and project management efforts associated with client technology support and development.
• Quality Improvement Initiatives: Participate in practice-wide quality improvement efforts by identifying opportunities, leading key initiatives, and documenting related procedures.
• Send completed documentation to Risk Reviewers: Email Risk Reviewers as needed, including a link to the appropriate folder and a reminder of the review timing

Required Skills & Attributes:

• 4 + years of defined benefit administration experience, including processing and reviewing pension plan benefit calculations and pension plan implementations
• 4 + years of project management experience.
• Strong understanding of defined benefit (DB) plans, including plan design, calculations, and regulatory requirements.
• Excellent verbal and written communication skills.
• Strong logical, analytical, and problem-solving skills.
• Must possess the ability to accomplish tasks through others in an environment with no reporting relationship.
• Proficient in the use of Microsoft Windows and Office (Word, Excel and Power Point). Experience with Microsoft Access and/or SQL Server a plus.
• Proven ability to manage multiple projects with varying timelines and deliverables.
• Comfortable with analyzing test cases and system requirements.

Required Qualifications:

• Bachelor's degree in business administration and information systems would add a great advantage.
• 4+ years of experience in defined benefit plan administration, project coordination, or systems implementation.