Business Data Analyst

Business Data AnalystDuration: 6 Months – Long Term Location: Washington, DC 20433 Hybrid Onsite: 4 days per week from Day 1, with a full transition to 100% onsite anticipated soon.Background and ContextThe 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 specificationsEvaluation, governance, and continuous improvement of system performanceScope of WorkRequirements Elicitation and AnalysisConduct 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 client retention policies.Document business rules governing procurement domains (Contracts, Suppliers, Risks).Solution Design SupportAuthor 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 ManagementCoordinate 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 RiskRisk 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 ReportingMaintain the Data Quality Rulebook, STTM documents, and UAT test scripts.Document business requirements for the cutover phase and ongoing reporting.Required Qualifications and ExperienceEducationBachelor's or Master's in Information Systems, Business Administration, or related field.Certifications (Preferred)Certified Business Analysis Professional (CBAP) or equivalentPMI Professional in Business Analysis (PMI-PBA)Agile certifications (SAFe BA, Certified Scrum Product Owner) are an assetMandatory ExperienceBachelor'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 environmentsDemonstrated ability to elicit and document complex, ambiguous requirements in rapidly evolving domainsTechnical KnowledgeSQL proficiency for independent data profiling.Conceptual understanding of AWS (S3, RDS) and Azure (ADLS Gen2) data architecture and ETL/ELT processes.Core CompetenciesSystems thinking and ability to reason about emergent, non-deterministic behaviorExcellent verbal and written communication skills.Strong analytical, critical thinking, and problem-solving skillsComfort operating in ambiguous, fast-moving environments with iterative delivery cyclesMindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.