Data Integration Analyst - 177590

Piper Companies; McLean (VA); Hybrid; USD 140,000 - 170,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

401(k) matching

Paid time off

Paid holidays

Job summary

Piper Companies in McLean, VA is seeking a Senior Business Analyst, Merger Card Integration & Data Mapping to support credit card replatforming, card member data integrations, and portfolio conversions. The role is hybrid in McLean, VA.

You will analyze, map, validate and reconcile card data across platforms, collaborate with Card Operations, Technology & Risk teams, and drive successful conversions and testing activities.

Qualifications

• 5+ years of experience in data analysis, data integration, payment processing, or related field.
• Credit Card Migration experience required and familiarity with card processing platforms.

Responsibilities

• Support end-to-end card and card member data integration efforts for large-scale replatforming.
• Analyze portfolio data, account structures, servicing environments, and workflows to identify integration requirements.
• Perform data mapping, transformation, validation, reconciliation, and portfolio balancing.
• Collaborate with technical teams to understand source/target data structures and data conversion needs.
• Support migration of large customer portfolios between card processing and servicing platforms.
• Participate in system integration testing, UAT, parallel testing, and production validation.
• Investigate and resolve data quality, mapping, and conversion issues.
• Develop data mapping documentation, conversion requirements, validation procedures, and reconciliation reports.
• Partner with Card Operations, Technology, PMO, Risk, Compliance, Digital, Fraud and other teams.
• Support production cutover activities and post-conversion stabilization.
• Assist with due diligence and integration planning for potential portfolio acquisitions.

Skills

Data analysis

Data integration

SQL

Data mapping

Data validation

Data reconciliation

Data transformation

Payment processing

Card operations

Analytical skills

Stakeholder communication

Tools

SQL

Job description

Piper Companies is seeking a Senior Business Analyst, Merger Card Integration & Data Mapping to support complex credit card replatforming, card member data integrations, and portfolio conversion initiatives in McLean, VA. The Senior Business Analyst, Merger Card Integration & Data Mapping will take a hands-on role in analyzing, mapping, validating, and reconciling card and card member data throughout large-scale platform integration and conversion efforts. This position is hybrid in McLean, VA.

Responsibilities of the Senior Business Analyst, Merger Card Integration & Data Mapping:

• Support end-to-end card and card member data integration efforts for large-scale replatforming and conversion initiatives
• Analyze card portfolio data, account structures, servicing environments, and operational workflows to identify integration requirements
• Perform data mapping, transformation, validation, reconciliation, and portfolio balancing activities
• Work with technical teams to understand source and target data structures and identify data conversion requirements
• Support migration of large customer account portfolios between card processing and servicing platforms
• Participate in system integration testing, user acceptance testing, parallel testing, conversion testing, and production validation
• Investigate and resolve data quality, mapping, integration, and conversion issues throughout implementation
• Develop and maintain data mapping documentation, conversion requirements, validation procedures, and reconciliation reports
• Partner with Card Operations, Technology, PMO, Risk, Compliance, Digital, Fraud, and other business teams throughout conversion initiatives
• Support production cutover activities and post-conversion stabilization
• Analyze data and operational processes to identify gaps, risks, and opportunities for improvement
• Support due diligence and integration planning related to potential portfolio acquisitions, mergers, and other strategic initiatives
• Collaborate with third-party processors, technology vendors, and implementation partners
• Help ensure card servicing functions including billing, rewards, disputes, fraud, collections, and digital servicing are properly represented throughout conversion activities
• Provide clear communication of data findings, issues, dependencies, and risks to both technical and business stakeholders

Qualifications for the Senior Business Analyst, Merger Card Integration & Data Mapping:

• 5+ years of experience in data analysis, data integration, payment processing, card operations, financial services technology, or a related discipline
• Credit Card Migration Experience Required
• Experience with Fiserv, First Data, TSYS/FIS, Jack Henry, Hogan, or similar card processing platforms
• Hands-on experience supporting large-scale data integration, platform migration, replatforming, or conversion initiatives
• Experience working with large customer or account datasets and complex data structures
• Strong experience with data mapping, data validation, data reconciliation, and data transformation
• Understanding of credit card processing, card servicing, payment processing, or financial services data
• Experience working with technical teams to investigate and resolve data and integration issues
• Strong analytical and problem-solving skills with exceptional attention to detail
• Ability to work across business and technical teams to gather requirements and translate data requirements into actionable solutions

Preferred Qualifications:

• Direct experience supporting a major credit card replatforming or portfolio conversion
• Experience with credit card portfolio integrations, processor migrations, or card platform consolidations
• Experience supporting large-scale credit card mergers, acquisitions, or portfolio transfers
• Experience supporting Visa, Mastercard, or American Express processing environments
• Strong SQL experience and experience working with large relational datasets
• Experience with data quality, ETL, data migration, or reconciliation tools
• Experience working in banking, credit unions, payments, or other financial services environments

Compensation for the Senior Business Analyst, Merger Card Integration & Data Mapping includes:

• Salary: $140,000 - $170,000 depending on experience
• Comprehensive Benefits Package including Medical, Dental, Vision, 401(k), PTO, and Paid Holidays

#LI-MM1 #LI-HYBRID

Keywords: Data Integration Analyst, Card Operations, Card Data, Card Member Data, Credit Card Operations, Card Replatforming, Credit Card Replatforming, Card Conversion, Credit Card Conversion, Data Integration, Data Mapping, Data Validation, Data Reconciliation, Data Transformation, Data Migration, Portfolio Conversion, Portfolio Integration, Card Platform Integration, Card Platform Migration, Payment Processing, Card Servicing, Credit Card Servicing, Fiserv, First Data, TSYS, FIS, Jack Henry, Hogan, Visa, Mastercard, American Express, Processor Migration, Portfolio Migration, Conversion Testing, SIT, UAT, Parallel Testing, Production Cutover, Operational Readiness, Data Quality, ETL, SQL, Financial Services, Banking Operations, Platform Modernization, McLean VA, Hybrid