Data Management - Data Analyst - Sr

Spectraforce Technologies; McLean (VA); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Spectraforce Technologies seeks a Senior Data Analyst for Bank Modernization migration in McLean, VA. Hybrid onsite/remote work with heavy data discovery, mapping, and migration planning.

Responsibilities include backbook data analysis, data quality validation, and collaboration with technical and business teams to ensure accurate legacy-to-target data transformation.

Qualifications

• 5+ years of real-world experience in data analytics, data engineering, or equivalent technical data role.
• Hands-on proficiency with Snowflake, Databricks, SQL and Python.
• Experience with data migration, data mapping and data quality.

Responsibilities

• Lead backbook data analysis and discovery to identify legacy data schemas, tables, and columns for migration.
• Support high-priority migration timelines for bank data (Bankruptcy, Deceased/Estates, Levies & Garnishments, Charge-Offs).
• Map legacy attributes to destination systems like Customer Core and AccountsCBP.
• Resolve data discrepancies across legacy systems to establish a true source of truth for migration.
• Define migration logic in collaboration with stakeholders for active/ended restrictions across accounts.
• Write complex queries and validate post-migration data quality using SQL, Python, Snowflake, and Databricks.
• Collaborate with Tech Leads, Data Stewards, and Business teams to maintain a standard backbook analysis framework.

Skills

Snowflake

SQL

Python

Databricks

Google Suite

Job description

Job title:Senior Data Analyst - Bank Modernization (BankMod) Migration

Location: Mclean, VA (3 days onsite, 2 Remote)

Duartion: Until feb 2027

Key Responsibilities

• 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.

Required Qualifications

• 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.

Preferred Qualifications

• 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.