Lead Business Systems Analyst (Data Conversion & Reconciliation)
Job Location:
Richmond, VA - USA
Monthly Salary:
Posted:
Application Deadline:
Vacancies:
Job Summary
Lead Business Systems Analyst (Data Conversion & Reconciliation)
Location: Richmond VA - Hybrid
Duration: 6-12 Months with possible extension/conversions.
Interview: Virtual round
Note:
Local with proper location on LinkedIn
Ex Capital One or someone with Pure Financial
Job Overview:
We are seeking an experienced Lead Business Systems Analyst with strong expertise in data analysis SQL development source-to-target mapping and data reconciliation. This role will support large-scale data conversion and system integration initiatives by analyzing complex datasets validating data integrity and collaborating with cross-functional stakeholders.
The ideal candidate should have hands-on experience working with enterprise data migration projects creating detailed mapping documentation troubleshooting data issues and supporting conversion verification activities.
Required Skill:
Technical Skills
- Advanced SQL expertise
- Joins
- Subqueries
- CTEs
- Window Functions
- Data Auditing Queries
- Strong experience with:
- Source-to-Target Mapping (STTM)
- Data Lineage
- Data Reconciliation
- Data Conversion / Migration Projects
- Hands-on experience with:
- Snowflake
- Google Sheets
- Experience creating automated reconciliation reports
- Strong analytical and troubleshooting skills
Prefered:
Enterprise data migration or ERP conversion projects
Financial operational or transactional data environments
Agile or large-scale transformation programs
Experience supporting UAT and verification phases
