Required MongoDB,Node.js,NoSQL freelancer for MongoDb Developer needed to create mongoose query in nodejs job

Collection 1: SeriesofMovies

MovieType (Series,Triology,Movie)

Moviecategory (Horror,thriller, action,etc...)

regionlocation (USA,CA, EU, etc...)

Collection 2: Movies

Moviecategories ( id of categories)

Movie_relatedSerie (id of the MovieSerie)

Collection 3: User

Userpreference (which contains, Prefered Movie Types, Preferred MovieCategories, Preferred RegionLocation)
NB: taking into consideration that Movies Types, MovieCategories and RegionLocation are arrays of ids NB: Taking into consideration that user may select either one or more or none of the following: Types, Categories and Region

Problem : i need to query taking into consideration movietype,moviecategory and regionlocation based on the preference of the user to show relevent SeriesMovies to the user.

Solution 1:
provide a route that will do the following:
search the Movies available giving priority to the following combinations: movies is within the preferred movie type, preffered movie category and preffered RegionLocation

if region and type and category then provide a certain score example 7
if type and categories then score 6
if region and categories score 5
if region and type score 4
if categories only then score 3
if type only score 2
if region only score 1
then sort Movies by scorepoint
then group Movies by Movie_relatedserie
then display series base on the relevancy mentioned above

Solution 2: the developer need to provide an optimal solution that meets the requirement taking into consideration perfomance

Skills & Expertise Required

MongoDB Node.js NoSQL