M&A ERP Data Integration Analyst

BKF; California (MO); On-site; USD 115,000 - 150,000; Full time

Benefits offered by this job

Profit sharing

401k

Flexible schedules

Generous PTO

Education reimbursement

Paid holidays

Job summary

BKF is a multi-service infrastructure consulting firm with offices across California and beyond. We seek an M&A Data Integration Analyst to support ERP integrations, data mapping, and validation during acquisitions and ongoing data integrity across platforms.

This role sits at the intersection of accounting, data analysis, and business systems, requiring attention to detail, problem solving, and cross-functional collaboration with accounting, IT, and M&A teams.

Qualifications

• Bachelor’s degree in Accounting, Finance, Information Systems, or related field.
• 3–5 years of experience in data analysis, ERP systems, accounting systems, or related roles.
• Advanced proficiency in Microsoft Excel (pivot tables, lookups, data modeling).
• Working knowledge of SQL for data extraction and analysis.
• Experience with ERP systems and large datasets.

Responsibilities

• ERP Integration & Data Validation: Support ERP integrations during M&A activities by performing data mapping, validation, and reconciliation between source and target systems. Ensure completeness and accuracy of data throughout the integration lifecycle.
• Data Integrity & Reconciliation: Analyze and compare large datasets across systems to identify discrepancies, inconsistencies, and gaps. Resolve data issues in collaboration with accounting, M&A, and IT stakeholders to maintain system integrity.
• Data Extraction & Analysis: Write and maintain SQL queries and scripts to extract, transform, and analyze data from multiple systems. Support repeatable processes for data comparison and validation.
• Excel-Based Analysis & Modeling: Develop advanced Excel models and tools to support reconciliation, validation, and reporting efforts during integrations and ongoing operations.
• Cross-Functional Integration Support: Partner with M&A, Accounting, and IT teams to support integration planning and execution. Act as a bridge between functional and technical teams to ensure alignment on data structures and requirements.
• Documentation & Process Standardization: Document data structures, mapping logic, validation processes, and integration workflows. Contribute to building repeatable, scalable processes for future acquisitions.
• Ongoing Data & Systems Support: Serve as a utility player outside of active M&A efforts by supporting data quality initiatives, system improvements, and ad hoc analysis across ERP and related systems.

Skills

SQL

Excel

ERP systems

Data integrity

Data analysis

Cross-functional collaboration

Education

Bachelor's degree in Accounting, Finance, Information Systems, or related field

Tools

Deltek Vantagepoint

Job description

BKF is a multi-service infrastructure consulting firm with offices across California and beyond. We seek an M&A Data Integration Analyst to support ERP integrations, data mapping, and validation during acquisitions and ongoing data integrity across platforms.

This role sits at the intersection of accounting, data analysis, and business systems, requiring attention to detail, problem solving, and cross-functional collaboration with accounting, IT, and M&A teams.