Data Analyst, Mergers & Acquisitions

Genesis10 is seeking a Data Analyst, Mergers & Acquisitions. This is a remote 9-month contract position with a client located in Columbus, OH.
This role pays $75.00-85.00/HR W2 based on experience.
Job Description:
We are seeking a detail-oriented Data Analyst to support the client's Merger & Acquisition efforts related to Commercial and Business Banking Loan Origination Systems (LOS). This role is critical in ensuring accurate, compliant, and seamless conversion of LOS data from acquired institutions into the client's environment. The analyst will perform deep data mapping, migration validation, regulatory alignment, and cross-functional coordination to preserve lending workflows, credit risk processes, and operational integrity throughout the acquisition lifecycle.
Responsibilities:

• Perform detailed analysis of source and target banking systems, including core banking platforms, lending systems, credit risk, and Salesforce CRM.
• Develop comprehensive data mapping documentation with transformation logic, field-level mappings, and validation rules for customer, loan, collateral, and transactional data.
• Design and support ETL processes to enable accurate, efficient data migration for M&A conversion events.
• Conduct pre-conversion and post-conversion audits to ensure data integrity, completeness, and compliance with regulatory expectations.
• Partner with business and technical SMEs to understand source-to-target relationships and aid in determining transformation logic where applicable.
• Ensure adherence to the client's data governance standards and internal audit controls throughout conversion activity.
• Use SQL, Excel, and BI tools (Power BI, Tableau) to extract, transform, validate, and analyze large datasets across multiple banking and lending systems.
• Identify data anomalies, gaps, and inconsistencies; provide root-cause insight and recommendations for remediation.
• Create data quality scorecards, conversion progress reports, exception summaries, and compliance-ready reporting for leadership and regulatory stakeholders.
• Present findings, risks, and trends in a clear and actionable manner to senior leaders and M&A program stakeholders.
• Support decision-making by modeling operational impacts and predicting conversion-related data outcomes.
• Act as the primary point of contact for data-related issues during conversion waves.
• Perform root-cause analysis on data discrepancies, implementing corrective steps, and mitigation strategies.
• Document issues, resolutions, and lessons learned to continuously improve future acquisition playbooks.
• Partner with M&A project managers to ensure data conversion activities align with program milestones and regulatory deadlines.
• Work with business analysts, credit/risk teams, and compliance to ensure converted data aligns with functional requirements and regulatory obligations.
• Communicate findings to non-technical audiences in clear and consumable formats.
• Facilitate working sessions to gather requirements, validate assumptions, and share conversion progress.
• Serve as a liaison between lending business units, risk partners, IT integration teams, and vendor partners to ensure data accuracy and system integrity.

Requirements:

• Bachelor's degree in Finance, Business, Data Analytics, Information Systems, or related field.
• Minimum 5 years of experience in data analysis, data mapping, or data validation within financial services.
• Proficiency in Microsoft Excel, SQL, and data visualization tools (Power BI, Tableau).
• Strong understanding of lending workflows, credit risk processes, and regulatory compliance.
• Experience with Credit Spreading, Risk Analysis & Rating, Underwriting Originations, Collateral Management, and Loan Servicing.
• Excellent communication skills to interact with technical and non-technical stakeholders.
• Ability to manage multiple priorities and deliver under tight deadlines.

Preferred Experience:

• Experience with Salesforce Financial Services Cloud (FSC) or LOS platforms.
• Familiarity with Commercial or Business Banking lending products, workflows, and data structures.
• Experience supporting conversions for mergers/acquisitions.
• Knowledge of ETL tools, data governance, or enterprise architecture concepts.
• Experience working in Agile/Scrum environments.

Only candidates available and ready to work directly as Genesis10 employees will be considered for this position.

If you have the described qualifications and are interested in this exciting opportunity, please apply!

About Genesis10:
Ranked a Top Staffing Firm in the U.S. by Staffing Industry Analysts for six consecutive years, Genesis10 puts thousands of consultants and employees to work across the United States every year in contract, contract-for-hire, and permanent placement roles. With more than 300 active clients, Genesis10 provides access to many of the Fortune 100 firms and a variety of mid-market organizations across the full spectrum of industry verticals.
For contract roles, Genesis10 offers the benefits listed below. If this is a perm-placement opportunity, our recruiter can talk you through the unique benefits offered for that particular client .

Benefits of Working with Genesis10:
Access to hundreds of clients, most who have been working with Genesis10 for 5-20+ years.
The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for years.
Access to an experienced, caring recruiting team (more than 7 years of experience, on average.)
Behavioral Health Platform
Medical, Dental, Vision
Health Savings Account
Voluntary Hospital Indemnity (Critical Illness & Accident)
Voluntary Term Life Insurance
401K
Sick Pay (for applicable states/municipalities)
Commuter Benefits (Dallas, NYC, SF)

For multiple years running, Genesis10 has been recognized as a Top Staffing Firm in the U.S., as a Best Company for Work-Life Balance, as a Best Company for Career Growth, for Diversity, and for Leadership, amongst others. To learn more and to view all our available career opportunities, please visit us at our website.

Genesis10 is an Equal Opportunity Employer. Candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.