Job Title: Business Analyst - Project Lead
Location: Admin - 1628 Browning Rd, 2nd Floor, Columbia, SC 29210
Duration: 12 months
Description:
To achieve this objective, the STO is implementing a process to streamline and automate the conversion of vendors from paper checks to Automated Clearing House (ACH) electronic payments. This solicitation requires the engagement of services to build project dashboards within the state's already acquired Microsoft Power BI application. Dashboards will automate the analysis, assignment and tracking of the approximately 40,000 existing Vendors (currently being paid by check) throughout the Check Reduction Vendor ACH enrollment process.
Provide a Business Model for determining detailed requirements, delivering a "proof of concept and final versions of Power BI dashboards
Develop Power BI dashboards accessing data from at least six different sources
Provide an executive view of Interim project milestones depicting status of vendors in the enrollment process
Provide an executive view of Interim development milestones depicting status of vendors in the enrollment process
Power BI Dashboards to provide drill-down capabilities to the individual vendor level to be utilized by the STO team for analysis
Develop Power BI dashboards to analyze the greater than 300k existing vendors that have had activity in the last 5 years but not in the previous fiscal year to assess opportunities to create different strategies for those populations
Provide a template for tracking and easily updating the dashboard(s) as well as a minimum of 16 hours of training/knowledge transfer activities to STO business staff, and a complete set of documentation to ensure internal staff can sustain the dashboard(s) going forward
REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
Provide (3) Samples of actual Power BI dashboards developed for other clients in the last 2 years, with drill down capabilities with the same level of volume of data, number of data sources and complexity. A presentation of actual dashboards may be required.
PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
POWER BI
DEMONSTRABLE FINANCIAL DASHBOARD SKILLS / EXPERIENCE
ABILITY TO INTERFACE WITH FINANCIAL CUSTOMERS AND DEVELOP PLANS TO PROVIDE A SOLUTION
REQUIRED EDUCATION: BACHELORS
Location: Admin - 1628 Browning Rd, 2nd Floor, Columbia, SC 29210
Duration: 12 months
Description:
To achieve this objective, the STO is implementing a process to streamline and automate the conversion of vendors from paper checks to Automated Clearing House (ACH) electronic payments. This solicitation requires the engagement of services to build project dashboards within the state's already acquired Microsoft Power BI application. Dashboards will automate the analysis, assignment and tracking of the approximately 40,000 existing Vendors (currently being paid by check) throughout the Check Reduction Vendor ACH enrollment process.
Provide a Business Model for determining detailed requirements, delivering a "proof of concept and final versions of Power BI dashboards
Develop Power BI dashboards accessing data from at least six different sources
Provide an executive view of Interim project milestones depicting status of vendors in the enrollment process
Provide an executive view of Interim development milestones depicting status of vendors in the enrollment process
Power BI Dashboards to provide drill-down capabilities to the individual vendor level to be utilized by the STO team for analysis
Develop Power BI dashboards to analyze the greater than 300k existing vendors that have had activity in the last 5 years but not in the previous fiscal year to assess opportunities to create different strategies for those populations
Provide a template for tracking and easily updating the dashboard(s) as well as a minimum of 16 hours of training/knowledge transfer activities to STO business staff, and a complete set of documentation to ensure internal staff can sustain the dashboard(s) going forward
REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
Provide (3) Samples of actual Power BI dashboards developed for other clients in the last 2 years, with drill down capabilities with the same level of volume of data, number of data sources and complexity. A presentation of actual dashboards may be required.
PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
POWER BI
DEMONSTRABLE FINANCIAL DASHBOARD SKILLS / EXPERIENCE
ABILITY TO INTERFACE WITH FINANCIAL CUSTOMERS AND DEVELOP PLANS TO PROVIDE A SOLUTION
REQUIRED EDUCATION: BACHELORS