Do we have a tutorial available that walks through role based logins using SA and MySQLi? If not, I will need help setting it up.

I'm not sure if there is a valid tutorial, they are probably older but still relevant if you check the tutorial library. MySQLi wouldn't change the concept, but the screenshots might be out of date.

Anyway it is a pretty simple concept. If you take it step by step it all makes sense.

1) User role is saved in the users table
2) Save the role in the session by adding it in the Authentication Server Behavior
3) Create rules in Security Assist based on the role session variable saved in step 2
4) Apply restrictions on the page based on the created rule

If you get stuck on a step, describe what you tried, maybe add screenshots, and post back and I can try to help you through it.