Real estate and marketing assistant

I am looking for someone who knows marketing, social media, seo, google , linked in, who can create emails on Mailchimp, create campaigns, creates templates, can edit videos, run ads and anything to do with marketing which can possible help a real estate office.