Fazendo busca no Django com dicionário

search_dict.py

# Fazendo busca no Django com dicionário
company = Company.objects.get(name='MyCompany')
company_cands = CompanyCandidate.objects.select_related('candidate')\
    .filter(company=company)
company_cand_list = company_cands.values_list('candidate', flat=True)

candidates = Candidate.objects.select_related('job', 'candidate')\
    .filter(candidate__in=company_cand_list)\
    .annotate(Max('apply_date'))

# Cria um dicionário
cand_dict = {}
for cand in candidates:
    cand_dict[cand.candidate.pk] = cand.job.title

for cand in company_cands:
    last_job = None
    # Faz a busca dos candidatos pelo dicionário.
    if cand.candidate.pk in cand_dict:
        last_job = cand_dict[cand.candidate.pk]

    if last_job:
        print(cand.candidate.get_full_name(), last_job)
    else:
        print(cand.candidate.get_full_name(), '---')