Business Analyst 2

Ampcus, Inc; Austin (TX); On-site; USD 80,000 - 100,000; Full time

Job summary

Ampcus, Inc is seeking a Business Analyst 2 in Austin, TX. This role requires 7+ years of business analysis experience to support the Compliance and Quality Control Division’s Solicitation Review System project. The successful candidate will document requirements, conduct gap analyses, and collaborate with the Senior Systems Advisor for system development. Candidates must be skilled in Microsoft Excel and PowerBI, with additional experience in Jotform preferred. Ampcus is an Equal Opportunity Employer and values diversity in the workplace.

Qualifications

• 7+ years of business analysis experience, including requirements elicitation, documentation, gap analysis, and testing.
• Experience with Microsoft Excel, PowerBI, and PowerAutomate.
• Preferred experience with Jotform.

Responsibilities

• Elicit and document business requirements for the Solicitation Review System.
• Conduct gap analysis of existing system functionality.
• Collaborate with the Senior Systems Advisor to track development.

Skills

Business analysis

Requirements elicitation

Gap analysis

Microsoft Excel

PowerBI

PowerAutomate

Jotform

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: Business Analyst 2. Location: Austin, TX.

I. Description of services

• Client requires the services of Business Analyst 2, hereafter referred to as Candidate(s), who meets the general qualifications of Business Analyst 2, Applications/Software Development and the specifications outlined in this document for the Client.
• All work products resulting from the project shall be considered "works made for hire" and are the property of the Client and may include pre-selection requirements that potential Vendors (and their Candidates) submit to and satisfy criminal background checks as authorized by Texas law. Client will pay no fees for interviews or discussions, which occur during the process of selecting a Candidate(s).
• 4-7 years of experience in the field or in a related area as a senior Business Analyst (Technical). Familiar with standard concepts, practices, and procedures within a particular field. Relies on limited experience and judgment to plan and accomplish goals.
• A certain degree of creativity and latitude is required. Works under limited supervision with considerable latitude for the use of initiative and independent judgment. 2 years of experience as a data analyst analyzing raw data using Excel, Tableau, etc.
• 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.

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%)

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.

Deliverable requirements

• 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 shared 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:
  • 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.
    • E‑mail Templates used for automated system e‑mails.
  • 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.
    • Updated e‑mail templates for automated system e‑mails.
  • 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.
    • Data quality rules and business logic.
• Gap Analysis & Recommendation Report
  • A structured analysis comparing current vs. future needs and identifying what must be changed or built. This report includes:
  • Gap Identification, which must include:
    • Workflow discrepancies (e.g., PowerAutomate actions that must be replicated in Jotform).
    • Data field gaps between old Excel model and new Jotform model.
    • Reporting gaps between current and desired PowerBI capabilities.
    • Process pain points identified during interviews.
  • Recommendations, which must include:
    • Proposed solutions for each gap.
    • Required form modifications.
    • Suggested workflow improvements.
    • Risks, assumptions, and dependencies.
    • Recommended approach for combining legacy and new data in PowerBI.
• Implementation Support & Collaboration Deliverables
  • These deliverables support the Senior Systems Advisor during development:
  • Requirements Change Log, which documents:
    • New requirements
    • Modified requirements
    • Requirements removed or deferred
    • Stakeholder approvals
  • Weekly Collaboration Artifacts:
    • Meeting summaries
    • Action items
    • Clarifications to technical requirements
  • User manual covering the new system for all user roles.
• Testing Assets & Validation Deliverables
  • Master Test Plan, which defines the approach for validating both systems, including:
    • Testing scope
    • Test methodology
    • User acceptance testing (UAT) roles
    • Environments and prerequisites
  • 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
    • Integration of legacy and new data
  • Test Execution Results, a documented summary that must contain:
    • Pass/fail results
    • Issues and severity ratings
    • Retest outcomes
    • Verified alignment to requirements
• Weekly Status Reporting Package, which is a brief, weekly update delivered to the Director via e‑mail, and must include:
  • Status Summary, including:
    • Progress on planned milestones
    • Work completed this week
    • Work planned for next week
  • Issues & Risks Log, including:
    • Open issues
    • Risks with mitigation strategies
    • Dependencies blocking progress

II. Candidate skills and qualifications

Minimum Requirements:

• 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 Years Preferred: Jotform

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.