Data Management - Data Analyst - Sr

Job title:

Senior Data Analyst - Bank Modernization (Bank Mod) Migration

Location:

Mclean, VA (3 days onsite, 2 Remote)

Duartion:
Until feb 2027

• Backbook Data Analysis
  :
  Lead the data discovery process to identify where legacy data resides today, detailing schemas, tables, and columns required for migration.
• Drive Priority Migrations
  :
  Support high-priority and medium-priority migration timelines, including Bankruptcy, Deceased/Estates, Levies & Garnishments, and Charge-Offs.
• Data Mapping & Translation
  :
  Map legacy attributes from systems like Profile and CST to destination systems, such as Customer Core and AccountsCBP.
• Discrepancy Resolution
  :
  Evaluate and resolve data discrepancies between multiple legacy systems (e.g., Profile vs. CST) to establish the true source of truth for the Bank.
• Define Migration Logic
  :
  Collaborate with stakeholders to determine business logic for handling active and ended restrictions across both open and closed accounts.
• Technical Execution
  :
  Leverage SQL, Python, Snowflake, and Databricks to write complex queries, perform large-scale data extractions, and validate post-migration data quality.
• Cross-Functional Collaboration
  :
  Work closely with Tech Leads, Data Stewards, and Business teams to ensure a standard backbook analysis checklist and framework are established and followed.

• Experience:
  
  5+ years of real-world experience working as a Data Analyst, Data Engineer, or in a highly technical data-focused role.
• Core
  
  Skills:
  
  Extensive hands-on proficiency in Snowflake,Google Suite, Databricks, SQL, and Python
• Data Fluency:
  Deep understanding of complex data architecture, data quality frameworks, and data manipulation.
• Problem-Solving:
  Proven ability to dive deep into legacy datasets, understand undocumented schemas, and confidently drive analytical outcomes.

• Migration
  
  Experience:
  
  Prior experience in large-scale data migrations, specifically migrating legacy infrastructure to modern cloud architectures, is a major bonus.
• Domain Knowledge:
  Familiarity with retail banking data, customer restriction statuses (e.g., Fraud, KYC, Bankruptcy), and case management workflows.