Business Analyst
7 days ago
Austin
Allied Consultants, Inc is a proudly Austin based firm with over 34 years of experience delivering top-tier technical and business professionals within Texas State Agencies. We are currently seeking an experience Business Analyst to play a key role within a high-impact technical services team. Location of job: Remote 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 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%) 1.Requirements Documentation Package – Solicitation Review System (SRS) A comprehensive set of documents capturing the current state, future-state needs, functional specifications, and reporting requirements for the new Jotform based Solicitation Review System. The documentation must be sharing with the Senior Systems Advisor as it is being developed. The Senior Systems Advisor will work on development as the requirements are gathered to ensure timeliness of the project. This package must include the following Deliverables: 1.1 Current-State Documentation, including: • Process maps of existing workflows (from Microsoft Forms to PowerAutomate to Excel to PowerBI)., • Field inventory documenting all data fields used across Forms, Excel files, PowerAutomate flows, email templates, and PDF outputs., • User roles and permissions, including who submits, reviews, approves, and receives communications., • Catalog of notifications, triggers, and automated actions in the current PowerAutomate setup. 1.2 Future-State Requirements • Functional Requirements Document, which must include:, • Step-by-step workflow description for each stage of the Solicitation Review process., • Required form logic, branching, validation, and conditional workflow steps., • Email triggers, recipients, templates, timing, and conditions., • PDF generation requirements (content, formatting, data fields, branding)., • Data capture requirements, including revised field definitions., • Requirements traceability matrix, which must link business needs to functional requirements to test cases. 1.3 Reporting Requirements, which must include a clear definition of: • Required metrics, KPIs, filters, and drill-downs., • Required alignment rules between legacy Excel data and new Jotform submissions., • Data transformation and mapping specifications. 2.Gap Analysis & Recommendation Report A structured analysis comparing current vs. future needs and identifying what must be changed or built. This report includes: 2.1 Gap Identification, which must include: • Workflow discrepancies (e.g., PowerAutomate actions that must be replicated or redesigned in Jotform)., • Data field gaps between old Excel model and new Jotform model., • Reporting gaps between current and desired PowerBI capabilities. 2.2 Recommendations, which must include: • Proposed solutions for each gap., • Required form modifications., • Suggested workflow improvements., • Risks, assumptions, and dependencies. 3.1 Requirements Change Log, which is a running, version-controlled log that mustdocument: • New requirements, • Modified requirements, • Requirements removed or deferred 3.2 Weekly Collaboration Artifacts, which must include: • Meeting summaries, • Action items 2.2 until Contract termination. 3.3 User manual covering the new system for all user roles. Submitted to the Director of Contract Compliance and Senior Systems Advisor 5 Business Days prior to Contract termination. 4.Testing Assets & Validation Deliverables 4.1 Master Test Plan, which must define the approach for validating both systems, including: • Testing scope, • Test methodology, • User acceptance testing (UAT) roles 4.2 Test Cases & Scripts, which must validate all requirements including: • Jotform workflow paths, • Form field validation, • Email triggers and PDF output checks, • Data exports, • PowerBI logic and metrics 4.3 Test Execution Results, which is a documented summary that must contain: • Pass/fail results, • Issues and severity ratings, • Retest outcomes 5.Weekly Status Reporting Package, which is a brief, weekly update delivered to the Director via e-mail, and must include: 5.1 Status Summary, including: • Progress on planned milestones, • Work completed this week, • Open issues, • Risks with mitigation strategies Qualifications Minimum Requirements: 5 years of: 7 years of: • Microsoft PowerBI, • Jotform