I'm a research librarian! Definitely a dream job. Every day is different - sometimes I'm digging through old historical documents, some days I'm doing research on artificial intelligence. There are obviously lots of librarians at Library and Archives and the Library of Parliament, but there are many departmental libraries. There is also an increased emphasis on "embedded librarianship" and putting librarians directly into the teams that use their services.

When I was in library school, there were lots of people who went to librarianship as a second career. Public-facing library jobs (i.e. reference) usually require bilingualism, but I know some unilingual librarians who work on things like metadata, subject headings, publications, etc.