Title: Senior Business Analyst (Power BI & JotForm)
Duration: 6 Months (3 Years Ext)
Location: Austin, Texas 78701. The working position is Telework.
Position will be 5 days remote. Program will only allow candidates who live in the state of Texas.
Summary:
Reviews, analyzes, and evaluates business systems and user needs. Formulates systems to parallel overall business strategies. Experienced with business process reengineering and identifying new applications of technology to business problems to make business more effective. Familiar with industry standard business process mapping, and reengineering. Prepares solution options, risk identification, and financial analyses such as cost/benefit, ROI, buy/build, etc. Writes detailed description of user needs, program functions, and steps required to develop or modify computer programs.
Project Description:
The Compliance and Quality Control (CQC) Division is undertaking a project involving transforming the existing Solicitation Review System from its current architecture built using Microsoft PowerAutomate, Microsoft Forms, Excel-based data storage, and PowerBI visualizations into a redesigned workflow and data management system built on Jotform.
The contractor will serve as the Business Analyst, providing structured requirements gathering, documentation, gap analysis, validation, and testing support. The contractor will be responsible for coordinating and leading any requirements gathering meetings with CQC staff. The project involves collaboration with the Senior Systems Advisor, who will be responsible for system design and development.
The current Solicitation Review System uses:
- Microsoft Forms for data entry
- PowerAutomate for workflow automation, email generation, and PDF creation
- Excel files as the underlying data store
- PowerBI dashboards for data visualization
The system must be migrated to Jotform, which will replace Microsoft Forms and PowerAutomate as the workflow, email, and PDF generation platform. Data structures will change, requiring a strategy for blending historical Excel based data with new Jotform-based data. A redesigned PowerBI dashboard will be built by the Senior Systems Advisor.
The project includes redesigning forms, restructuring workflow logic, supporting reporting redesign, and ensuring legacy and new data can coexist for unified analytics.
Job description:
The Business Analyst (BA) performs business analysis work to support the Compliance and Quality Control Division s Solicitation Review System s re-write project. This role partners with business owners throughout product planning, requirements definition, and delivery cycles. Responsibilities include analyzing complex technical and business processes, identifying efficiencies, and prioritizing needs. The BA coordinates the gathering, development, documentation, and verification (testing) of requirements and works under limited supervision with considerable latitude for initiative and independent judgment.
Essential job functions:
- Elicit and document business requirements for the existing Solicitation Review System, ensuring accuracy and effective communication with stakeholders and the development team. Responsible for coordinating, scheduling, and leading all requirements-gathering meetings. (40%)
- Conduct gap analysis of existing system functionality against desired system functionality for the Solicitation Review System, including workflows and reporting through PowerBI. (20%)
- Collaborate daily with the Senior Systems Advisor to track the development and implementation of requirements and test new and existing system functionality for adherence to business requirements for the Solicitation Review System. Update and maintain requirements documentation throughout the life of the project. (30%)
- Report weekly to the Director of Contract Compliance Unit regarding progress, potential issues, and overall status. (10%)
Required Skills:
- 5 Years of Required Business analysis experience, including requirements elicitation and documentation, gap analysis, and testing.
Preferred Skills:
- 7 Years of Preferred Microsoft Excel
- 3 Years of Preferred Microsoft PowerBI
- 3 Years of Preferred Microsoft PowerAutomate
- 1 Year of Preferred Jotform