Senior Financial Systems Integration Analyst

BKF is a multi-service infrastructure consulting firm providing civil engineering, construction management, environmental, planning, and surveying services across California, the Pacific Northwest, and beyond. With offices throughout California and the Portland area, BKF has served transportation, water resources, land development, government, and federal clients for over 110 years. At BKF, you’ll find a unique opportunity to grow your career with intention. Our culture values professional autonomy, innovation, and meaningful collaboration across offices. We are proud to be recognized with the Great Place to Work certification for the second year in a row. The M&A Data Integration Analyst is responsible for supporting mergers and acquisitions with a focus on ERP system integration, data consistency, and accounting data integrity across systems. This role ensures that financial and operational data is accurately mapped, validated, and reconciled between source and target environments during integrations. This position operates at the intersection of accounting, data analysis, and business systems, serving as a key contributor during acquisitions and as an ongoing resource for maintaining data integrity across platforms. The role requires a high degree of attention to detail, analytical rigor, and independent judgment, with responsibility for identifying data discrepancies, developing validation processes, and supporting system alignment efforts with minimal oversight. 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. 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. Strong understanding of data integrity principles, particularly within accounting or ERP environments. Advanced proficiency in Microsoft Excel (e.g., pivot tables, lookups, data modeling). Working knowledge of SQL for data extraction and analysis. Experience working with ERP systems and large datasets. Strong analytical, problem-solving, and attention to detail skills. Ability to work cross-functionally and communicate effectively with both technical and non-technical stakeholders. Experience in the AEC (Architecture, Engineering, Construction) industry is preferred. Familiarity with Deltek Vantagepoint is preferred. Experience supporting ERP implementations, system migrations, or M&A integrations is preferred. Exposure to scripting or automation tools (e.g., Python, PowerShell, or similar) is preferred. Physical Demands: Must be able to regularly talk, hear and operate a computer, keyboard and mouse and occasionally lift, pull/push and carry up to 20 pounds with accommodations. Work Conditions: Exposure to constant or intermittent sounds at a low or moderate level consistent with an office setting. Exposure to high-stress, fast-paced, deadline-oriented environment. Travel to other BKF locations and client sites may be required. The typical base salary range for this position is $115,000.00-$150,000.00 annualized depending upon skills, experience, education, and geographical location. This is a salary position paid biweekly. Competitive salaries, profit sharing, and 401k. Generous paid time off packages. 9 Paid Holidays. Flexible schedules. Education reimbursement, Paid annual dues for professional and societal organizations. BKF offers competitive and award-winning benefits and perks. To learn more click here. BKF provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. BKF does not accept unsolicited resumes from recruiters or employment agencies. In the event a recruiter or agency submits a resume or candidate without a previously signed agreement and a specific solicitation for the position or other approved engagement request for the position with BKF, BKF reserves the right to pursue and hire those candidate(s) without any financial obligation to the recruiter or agency. Any unsolicited submittals are done at the risk of the recruiter. #LI-Hybrid