There's no hard and fast rule, especially when you're working with a small team. When I think of a solution architect, they select the right technology/technologies for the job - usually in an enterprise setting where the tech landscape is vast. This is typically a role one moves into after being a developer - which is helpful because they were hands on with the technology (or at least other technologies) and have the ability to get into the technical details.
Typically, the person that spends time creating tickets, and making sure they are moving along, generally has a title like scrum master, tech lead, product owner, product manager or the like. Each of the aforementioned roles has different additional responsibilities and responsibilities can vary by company, for the same title.
The title consultant typically doesn't refer to a skillset or job function. It's mostly used to describe a person that doesn't work for the company, but can be hired (oftentimes short term) to do anything.