Sign upLog in
Data Analysis Jobs in Washington, DC

Business Data Analyst

Mindlance

Washington, DC

Apply
JOB DETAILS
SKILLS
Acceptance Testing, Agile Programming Methodologies, Amazon Relational Database Service (RDS), Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Analysis Skills, Business Administration, Business Analysis, Certified Scrum Product Owner, Change Management, Cloud Computing, Communication Skills, Computer Science, Continuous Improvement, Cryptography, Customer Retention/Renewal, Data Analysis, Data Migration, Data Profiling, Data Warehousing, Database Extract Transform and Load (ETL), Database Technology, Information Systems/Technology IS/IT Administration, Microsoft Windows Azure, Oracle, Performance Management, Presentation/Verbal Skills, Problem Solving Skills, Purchasing/Procurement, Relational Databases (RDBMS), Risk Management, SQL (Structured Query Language), Scrum Project Management and Software Development, Test Scenario, Writing Skills
LOCATION
Washington, DC
POSTED
1 day ago
Job Title: Business Data Analyst
Duration: 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 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 client 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
Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.

About the Company

M

Mindlance

Resume Resources

Free Resume TemplatesFree Resume Builder

Similar Job Searches

Applications Analyst JobsBusiness Systems Analyst JobsData Scientist JobsProgram Analyst Jobs