Business Intelligence Consultant

Job Description (Power BI Consultant)

A. Data Quality Issues

1. PR Reassignment Dates – Fix incorrect dates affecting SLA tracking.
2. Missing Item Numbers – Address blanks in Managed Spend reports (retail items).
3. Blank Requisition Numbers – Resolve RFQ In-Progress page discrepancies.
4. Technical Evaluation Status – Correct mismatches in scoring date flags.
5. Textual Data in Item Numbers – Cleanse invalid text in Managed Spend fields.
6. Requisition Details – Fix missing PR Approved Dates/Buyer Names.
7. Catalog Classification – Classify 4% of uncategorized PRs (catalog/non-catalog).
8. Incomplete Requisition Data – Load missing PRs not appearing in reports.
9. PR Amounts – Reconcile inaccuracies in Purchase Cycle Line.
10. RFQ Approval Amounts – Align Fusion and Power BI datasets.

B. Reporting & Dashboard Enhancements

1. Summary Statistics – Collaborate with Tahweel Analytics to validate metrics.
2. SLA Dashboard Performance – Optimize backend/visuals for faster loading.
3. Data Archiving – Archive historical data to improve system efficiency.
4. GS Fabric Capacity Dashboard – Enhance speed and usability.