Title: PowerBI Consultant
Duration: 1 Year
Location: Salt Lake City, UT (Onsite)
SCOPE OF PERFORMANCE :
The Business Intelligence (BI) Consultant plays a crucial role in leveraging data to drive decisions that improve operational efficiency, security measures, and rehabilitation outcomes. The main responsibilities and contribution of a BI Consultant include:
- Learning and researching current systems and O-track program.
- Create data model in BI dashboards – focusing on Releases and LOS Admissions. Standard Date table with release and LOS data from client system.
- Updates on Executive dashboard and detailed dashboards. Prepare updates to the Executive Team on Power BI work and progress.
- Key Performance Indicator (KPI) – KPI research , data gathering and reviewing scripts. Refine data gathering process for KPI’s. Grievance update metrics with all information provided by the Subject Matter Experts. Create popup for KPI cards.
- Data work and Power BI development, planning out detailed reports. Testing security of the Power BI.
- Work with client's staff and continue coordination on Cognos.
- Client on state server permissions and collaboration of BI appearances and features and implementing suggestions.
- KPI- HR research, troubleshooting, and implementing solutions.
- Create data dictionary, scripting and import scripts.
- Create table scripts and stored procedures.
- Data gathering for Human Resources and Board of Pardons and Parole changes.
- Learning procedures in Informix.
- Coding logic into tables.
- Development on inmate populations report, grievance report, available beds, etc.
- Discuss project requirements with key stakeholders to determine objectives, timeframe, and deliverables within the fields of technology, finance, and education.
- Provide regular oral and written reports and project updates on a consistent basis to client about strategy, adjustments, and progress.
Minimum Mandatory Requirements: 1. must have at least 4 years of consulting experience