The Family Service Counselor position at SCI involves providing personalized service to families making cemetery arrangements, both at need and pre-need. The role emphasizes building relationships, generating leads, and collaborating with team members to ensure high-quality service.