

Soho Square Solutions
Senior Data Analyst
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Senior Data Analyst (W2 Contract) in McLean, VA, from 9/14/2026 to 2/5/2027. Requires 5+ years in data roles, financial/banking experience, and proficiency in SQL, Python, Snowflake, and Databricks.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
July 31, 2026
🕒 - Duration
More than 6 months
-
🏝️ - Location
Hybrid
-
📄 - Contract
W2 Contractor
-
🔒 - Security
Unknown
-
📍 - Location detailed
McLean, VA
-
🧠 - Skills detailed
#Complex Queries #Datasets #Databricks #Data Quality #Data Analysis #Python #SQL (Structured Query Language) #Data Extraction #Data Management #Data Engineering #Migration #Cloud #Snowflake #"ETL (Extract #Transform #Load)" #Data Mapping #Data Manipulation #Data Migration #Data Architecture
Role description
Important Note:
This position is only on W2 Contract Role.
Prior expereince in Financial/Banking expereince is Mandatory
(Candidate who dosen't not fit in these criteria will not be eligible for this role)
Role: Sr. Data Analyst (Data Management)
Location: Mclean, VA (Hybrid)
Mode: Contract
Start/End Dates: 9/14/2026 - 2/5/2027
Job Description: Senior Data Analyst - Bank Modernization (BankMod) Migration
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.
Important Note:
This position is only on W2 Contract Role.
Prior expereince in Financial/Banking expereince is Mandatory
(Candidate who dosen't not fit in these criteria will not be eligible for this role)
Role: Sr. Data Analyst (Data Management)
Location: Mclean, VA (Hybrid)
Mode: Contract
Start/End Dates: 9/14/2026 - 2/5/2027
Job Description: Senior Data Analyst - Bank Modernization (BankMod) Migration
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.





