Quick Overview
Seniority
Mid Senior
Work mode
Hybrid
Location
United States
Posted
20 hours ago
SQLSQL ServerETLAgileComplianceConfluenceDatabricksHIPAAJiraReconciliationRequirements GatheringStakeholder ManagementUnitydbt
Job Description
Business Analyst with QA to support a healthcare payer client's migration from a legacy SQL Server/SSIS data warehouse to Databricks. The role focuses on requirements gathering, data validation, QA, UAT, and stakeholder management across the migration lifecycle.
Location: Remote EST
Duties:
- Gather, document, and manage business requirements.
- Create BRDs, user stories, and acceptance criteria.
- Define and execute QA strategy, test plans, and defect management.
- Perform source-to-target data validation and reconciliation.
- Validate business rules, mappings, and transformation logic.
- Coordinate UAT and stakeholder sign-offs.
- Track cutover readiness, regression testing, and go-live criteria.
- Maintain data mapping documents, test cases, and defect logs.
- Collaborate with client SMEs, data engineers, security teams, and business stakeholders.
- Support PHI masking, data classification, RBAC, and compliance activities.
Required:
- 8-10 years of Business Analyst and QA experience.
- Strong experience in data warehouse, ETL/ELT, or data migration projects.
- Hands-on SQL for data validation and reconciliation.
- Experience with source-to-target mapping and data quality testing.
- Exposure to Databricks, dbt, or modern cloud data platforms.
- Experience with SQL Server and SSIS environments.
- Knowledge of PHI/PII, data masking, RBAC, and data governance.
- Healthcare payer domain experience (membership, eligibility, claims, provider data).
- Understanding of HIPAA and PHI handling requirements.
- Experience with Agile, Jira, and Confluence.
- Strong stakeholder management and communication skills.
- Experience supporting UAT and migration cutovers.
Desired:
- Experience with Unity Catalog.
- Exposure to data masking/tokenization tools (Presidio or similar).
- Familiarity with Medallion Architecture (Bronze, Silver, Gold).
- Knowledge of healthcare interoperability standards (HL7, FHIR, Epic, Cogito).
- Experience with phased migrations and parallel-run validations.
Similar jobs
- TI
Senior Software Development Engineer, Quality Platform & AI Test Automation
TikTok
San Jose, CA🇺🇸$212.8k - $387.6k/yrHybrid6 days agoExpressLLMTechnology - SI
QA - Spanish & English
NewSerenity Info Tech, Inc.
East Hartford, CT🇺🇸On-site20 hours agoSOAPSQLSalesforce+14 - TD
QA Automation Tester -Remote (Fulltime)
NewThe Dignify Solutions, LLC
Jersey City, NJ🇺🇸Remote20 hours agoNext.jsNode.jsFigma+20Technology - TE
Senior QA Automation Engineer – Playwright - Charlotte, NC, Tampa, FL, Raleigh, NC, Durham, NC, Orlando, FL, Columbia, SC, Atlanta, GA.
NewTechniPros, LLC
Charlotte, NC🇺🇸Hybrid20 hours agoDockerSQLScrum+9Technology - TC
Qa Analyst Consultant W2
NewTEKsystems c/o Allegis Group
Charlotte, NC🇺🇸$45 - $55/hrHybrid20 hours agoSQLScrumPostman+1Technology - AC
Test Automation Engineer
NewAlltech Consulting Services, Inc.
New York, NY🇺🇸On-site20 hours agoOracleRubySQL+13Technology