Business Analyst

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. 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%) KNOWLEDGE, SKILLS and ABILITIES: Knowledge of BABOK Guide principles, including elicitation, requirements analysis, and validation. Knowledge of gap analysis methodologies-comparing current state vs. desired state and identifying missing capabilities. Knowledge of the capabilities and limitations of computer systems or management information systems. Knowledge of process or systems analysis and design work. Knowledge of the Software Development Lifecycle (SDLC) Skill in defining all types of requirements, functional specifications, and other deliverables. Skill in policy interpretation and translating regulations into system requirements. Skill in requirements elicitation techniques such as interviews, workshops, document analysis, observation, and surveys. Skill in working collaboratively and cooperatively with colleagues and in building consensus. Skill in interpersonal relationships, including the ability to work with people under pressure, negotiate among multiple parties, resolve conflicts, and establish and maintain effective working relationships with various levels of personnel in governmental entities. Skill in troubleshooting, performance tuning, and problem-solving. Skill in verbal, written, and presentation communication. Skill in Microsoft Excel. Ability to create clear, complete, and actionable requirements documentation. Ability to build consensus across multiple teams. Ability to ensure accuracy in documenting system functionality and regulatory requirements. Ability to identify compliance gaps and propose feasible solutions. Ability to adapt effectively to evolving regulations and system complexities. Ability to build trust and maintain relationships across technical and business teams. CANDIDATE SKILLS AND QUALIFICATIONS 7 years Required - Business analysis experience, including requirements elicitation and documentation, gap analysis, and testing 7 years Preferred - Microsoft Excel 5 years Preferred - PowerBI 5 years Preferred - PowerAutomate 1 year Preferred - Jotform #DICE #LI-MB Stats for this job Salary comparison: This job National average IT Jobs average Texas average Salaries The number of jobs in each salary range for all: Receive