New Feature for NodeJS Website with Sequelize

We're looking for a developer with 2+ years of experience to add features to an existing NodeJS application that uses Sequelize to interact with a PostgreSQL database. The application currently allows users to post links to videos and arbitrarily tag them ("funny", "interesting", etc.). Other users can then view videos by tags, and "react" to them with reactions such as "hilarious", "terrible", etc. We'd like for the following functionality to be added:

1. A reactions leaderboard: For each reaction type, show the top videos for that category (funniest, worst, most mind-blowing, etc.).

2. Below each video, show "Submitted By: {username}"

3. User profiles. They should contain the following:

3a. The videos that a user has put on the site.

3b. The total accumulated reaction score at the top of each user's profile.

3c. The reaction totals for each video below each video on each user's profile.

(user profiles picture attached for reference)

There is an existing GitHub repository. The above features would be done on a separate branch and merged into master via a pull request that will be reviewed by another developer. We expect clean code. We're not too bothered about the frontend, as the design will change soon anyway. We mainly care that the backend functionality is in place, and an example frontend page has been made that makes use of the data. We have created a guide to get the application running locally, and will provide you with a copy of the production database.

Dear Hiring Manager,
I’ve carefully gone through your job posting . I've more than two years of experience in developing web applications using state of the art technologies. I can give my best to the MEAN stack andMás