How can we implement SQL-based data security in a BI Publisher Data Model to restrict PII columns?

We have a custom BI report which contain 5 columns of data and out of these 3 columns are related to PII(Personal Identifiable Information). These 3 fields are secured on the front end screen using "Data security Job Roles".

As a result, users without the appropriate role cannot see these fields on the screen. However, when the same set of users run the custom BI report those PII fields are visible. We need to implement the same level of data security through BI Publisher Data Model behind the custom BI report.

Reaching out to the community to get some suggestions on how any SQL code line can be implemented in the data model to check the job profile assignment of the user running the report and invoke the same level of data security.