Business Analyst

Posted: 26 June 2026 Location: Washington, DC Reference: 1009248 Business Analyst Background and Context The BA in this role will support programs involving one or more of the following: Acting as the critical bridge between procurement stakeholders and the data engineering squad to ensure that business rules, active vs. archived data delineations, and migration mappings are accurately translated into technical specifications. Evaluation, governance, and continuous improvement of system performance. Scope of Work Requirements Elicitation and Analysis Conduct data discovery and profiling on legacy source databases (Oracle, Dynamics/Dataverse). Collaborate with business stakeholders to define criteria for categorizing "active" data (to be migrated) versus "historical" data (to be archived) per WBG retention policies. Document business rules governing procurement domains (Contracts, Suppliers, Risks). Solution Design Support Author detailed Source-to-Target Mapping (STTM) documents to translate legacy schemas to AWS/Azure target schemas. Define cleansing logic to handle missing fields, standardize formats, and resolve duplicate records prior to extraction. Translate business logic into technical specs for the engineering team. Stakeholder Engagement and Change Management Coordinate User Acceptance Testing (UAT) cycles and test scenarios for migration sign-off. Communicate status, scope, and technical constraints to non-technical business users. Governance, Ethics, and Risk: Risk Mitigation: Document rollback protocols and on-demand data refresh workflows to mitigate operational downtime. Data Privacy: Proactively identify Personally Identifiable Information (PII) to ensure appropriate encryption in transit and at rest. Auditability: Ensure end-to-end data lineage is documented for compliance. Documentation and Reporting Maintain the Data Quality Rulebook, STTM documents, and UAT test scripts. Document business requirements for the cutover phase and ongoing reporting. Required Qualifications and Experience Education Bachelor's or Master's in Information Systems, Business Administration, or related field. Certifications (Preferred) Certified Business Analysis Professional (CBAP) or equivalent. PMI Professional in Business Analysis (PMI-PBA). Agile certifications (SAFe BA, Certified Scrum Product Owner) are an asset. Mandatory Experience Bachelor's or master's degree in computer science, Information Systems, Business Administration, or a related field. 5+ years of BA experience with a proven track record leading large-scale legacy-to-cloud data migration workstreams. Expert proficiency in SQL for independent data profiling. Deep understanding of ETL/ELT concepts, relational databases, and data warehousing. Conceptual familiarity with core cloud data services across AWS (S3, RDS) and Azure (ADLS, Databricks). Experience working in Agile/Scrum delivery environments. Demonstrated ability to elicit and document complex, ambiguous requirements in rapidly evolving domains. Technical Knowledge SQL proficiency for independent data profiling. Conceptual understanding of AWS (S3, RDS) and Azure (ADLS Gen2) data architecture and ETL/ELT processes. Core Competencies Systems thinking and ability to reason about emergent, non-deterministic behavior. Excellent verbal and written communication skills. Strong analytical, critical thinking, and problem-solving skills. Comfort operating in ambiguous, fast-moving environments with iterative delivery cycles. Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status. #J-18808-Ljbffr