The demand for seasoned Business Analysts is soaring as organizations modernize their digital workflows and integrate complex systems. This role in Columbia, SC offers a hands‑on opportunity to drive critical State DOT initiatives and work directly with stakeholders on real‑world integrations. If you’re a US‑based professional with strong API and process‑mapping expertise, this position is a perfect fit.

Job Summary

We are seeking an experienced Business Analyst to support a State Department of Transportation PMO initiative. You will analyze and document business processes, lead system integration and data‑flow analysis, gather detailed functional requirements (BRDs, User Stories, RTMs), and collaborate with stakeholders to ensure successful UAT, testing, and implementation. The position is fully onsite in Columbia, SC and runs for at least 12 months with possible extension.

Top 3 Critical Skills Table

Interview Preparation

1. Question: Describe your approach to mapping a complex business process and translating it into a BPMN diagram using Visio or Lucidchart.
   What the interviewer is looking for: Ability to break down intricate workflows, use visual tools effectively, and communicate the process clearly to technical and non‑technical audiences.
2. Question: How have you handled API integration projects where data consistency and latency were major concerns?
   What the interviewer is looking for: Experience with API design principles, error handling, performance monitoring, and collaboration with development teams.
3. Question: Walk us through a time you authored a BRD and User Stories that were later used for UAT. What challenges did you face?
   What the interviewer is looking for: Skill in requirement articulation, traceability, stakeholder alignment, and ability to anticipate testing needs.
4. Question: Explain how you manage stakeholder expectations when scope changes occur mid‑project.
   What the interviewer is looking for: Communication tactics, change‑control processes, and negotiation skills.
5. Question: What techniques do you use to validate data flows during system integration testing?
   What the interviewer is looking for: Knowledge of data mapping, validation scripts, reconciliation methods, and defect tracking.

Resume Optimization

• Business Analyst
• Business Process Mapping
• API Integration
• Data Flow Analysis
• BRD (Business Requirements Document)
• User Stories
• RTM (Requirements Traceability Matrix)
• Visio
• Lucidchart
• Stakeholder Management

Application Strategy

When reaching out to the recruiter, send a concise email that opens with a friendly greeting, attaches your resume, and clearly highlights your top relevant skills. Make sure to mention related skills you possess, such as API integration, requirements gathering, and process mapping, and reference specific projects where you applied these abilities. Emphasize that you are currently located in South Carolina and meet the citizenship requirements.

Career Roadmap