Data Migration Specialist

Modigent

Phoenix (AZ)

Hybrid

USD 90,000 - 140,000

Full time

13 days ago

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Medical, Dental & Vision

401(k) with company contribution

Paid time off

Hybrid work options

Job summary

Modigent is seeking a Data Migration Analyst – Finance & ERP Systems to own accounting accuracy during ERP deployments across Procore, Sage Intacct, and BuildOps. You will ensure clean, validated, audit-ready data and collaborate with finance, operations, and implementation teams.

The role focuses on data migration for finance modules, detailed mapping, validation, and month-end readiness, with a strong preference for construction accounting and job-cost experience.

Qualifications

5+ years of accounting or financial operations experience.
4+ years of hands-on ERP data migration execution (not just project management).
Strong construction accounting or job-cost background preferred.
Experience with Sage Intacct and mapping to new ERP platforms.

Responsibilities

Lead and execute data migration activities for finance/accounting modules during ERP deployment.
Perform data mapping, transformation, extraction, and validation between source and target systems.
Review and reconcile trial balances and sub-ledgers for integrity in the new environment.
Validate migrated data against source reports and resolve job costing, WIP, and revenue issues.
Collaborate with finance, operations, and implementation teams to define migration requirements and cutover plans.
Develop Excel-based validation tools and templates to support accuracy.
Document migration processes and controls for audit readiness.

Skills

Construction accounting

Sage Intacct

Excel

Data migration

Job costing

WIP accounting

Revenue recognition

GL reconciliation

Project accounting

Analytical skills

Education

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

Tools

Sage Intacct

Procore

BuildOps

QuickBooks Desktop

MS Excel (advanced)

Job description

Position Overview

As a Data Migration Analyst – Finance & ERP Systems, you'll play a critical role in Modigent’s Horizons Program, our multi-OpCo ERP transformation initiative. You will own the accounting accuracy and financial integrity of data migration workstreams as we deploy Procore, Sage Intacct, and BuildOps across acquired operating companies. This role serves as the essential bridge between legacy source ERP systems and our target platforms, ensuring clean, validated, and audit-ready data loads. Ideal for someone with deep construction accounting or job-cost experience who has personally executed ERP data migrations.

Data Migration Analyst

Duties And Responsibilities

Lead and execute data migration activities for finance and accounting modules, ensuring accuracy and completeness during the transition to Sage Intacct, Procore, and BuildOps.

Perform detailed data mapping, transformation, extraction, and validation between source systems and target ERP platforms.

Review and reconcile trial balances, sub‑ledgers, and financial data from legacy systems to ensure integrity in the new environment.

Validate migrated data against source system reports, identify discrepancies, and resolve issues related to job costing, WIP, revenue recognition, over/under billings, retainage, change orders, and other construction accounting elements.

Collaborate closely with finance, operations, shared services, and implementation partners to define migration requirements, sequencing, and cutover plans.

Develop and maintain advanced Excel workbooks, reconciliation templates, and validation tools to support migration accuracy.

Document migration processes, mapping rules, transformation logic, and issue resolution for audit and knowledge transfer purposes.

Support month‑end close readiness and post‑migration financial reporting validation.

Contribute to continuous improvement of migration methodologies, templates, and controls to support scalable rollouts across multiple operating companies.

Supervisory Responsibilities

None (individual contributor role with significant cross‑functional collaboration; may provide functional guidance to junior analysts or data resources as needed).

Requirements/Qualifications

Experience: 5+ years of accounting or financial operations experience, with at least 4+ years of hands‑on ERP data migration execution (not just project management). Strong construction accounting or job‑cost accounting background is highly preferred.

Education: Bachelor’s degree in Accounting, Finance, Information Systems, or a related field required.

Physical Demands: Primarily office‑based with occasional travel for project meetings or go‑live support; standard office mobility.

Work Environment/Safety: Professional office setting with hybrid options; adherence to corporate safety standards.

Required Skills

Deep knowledge of construction accounting concepts (job costing, WIP, Schedule of Values, AIA billing, over/under billing, retainage, change order accounting, revenue recognition).

Hands‑on experience with Sage Intacct (or similar ERP) including sub‑ledger management, journal entries, and GL reconciliation.

Advanced Excel proficiency (pivot tables, XLOOKUP, data validation, complex reconciliation workbooks).

Ability to read, interpret, and reconcile trial balances independently.

Experience with source systems such as Sage 100, Sage 50, QuickBooks Desktop, Microsoft Dynamics GP, or eCMS.

Understanding of data migration sequencing and transformation logic.

Strong analytical, problem‑solving, and attention‑to‑detail skills.

Excellent communication and collaboration skills to work effectively with finance, operations, and implementation teams.

Modigent Overview

Modigent is a national leader delivering next‑generation infrastructure, technology, and energy solutions through our family of specialized brands in HVAC, plumbing, and controls systems. With a strong coast‑to‑coast presence and extensive service capabilities, we empower customers, communities, and our over 1,500 team members to thrive with sustainable, efficient commercial building services. As part of our team, you’ll contribute to thoughtful innovation and our people‑first culture rooted in service, collaboration, and integrity.

Why Work at Modigent

Competitive compensation based on experience and level, with opportunities for performance incentives.

Comprehensive benefits including medical, dental, and vision coverage, plus HSA options with employer contributions in select plans, and company‑paid basic life and accidental death & dismemberment insurance.

Paid time off, holiday pay, and a 401(k) retirement savings plan to support your long‑term financial well‑being.

Inclusive, supportive culture that values diversity, dignity, respect, collaboration, integrity, and personal fulfillment—empowering you to build a rewarding, long‑term career.

Equal Opportunity Statement

Modigent is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, sex, national origin, age, disability, veteran status, genetic information, or any other protected characteristic.

Third-Party Recruitment Policy

Modigent and its wholly‑owned operating companies will not pay any fees for candidate introductions, resumes, or placements from recruiters, employment agencies, or staffing firms without a prior, signed recruitment agreement specifically authorizing submission for a designated position. Unsolicited resumes or candidate submissions will not obligate Modigent to any payment, and we reserve the right to pursue and hire such candidates without liability. Agencies are requested to refrain from contacting hiring managers directly; all inquiries and submissions must go through our Talent Acquisition team.

Get your free, confidential resume review.

or drag and drop your file here.