Get the newest active profile for an employee by returning the first row of a sub-query which will grab all employee profiles for provided employee_id.