ERP Data Integration Analyst

ERP Data Integration Analyst Location: Remote (PST Preferred) Type: Contract (12 Months) Pay: $70-$90/hour About the Role We are seeking a detail-oriented, execution-focused ERP Data Integration Analyst to support enterprise data integration and migration initiatives. This role is part of a high-visibility transformation program involving the implementation of Microsoft Dynamics 365 Finance & Operations (D365 F&O), Dynamics 365 Project Operations, and Procore. You will play a critical role in ensuring data accuracy, integrity, and consistency across a complex ecosystem. This is a hands-on position ideal for someone who enjoys working with large datasets, defining data mappings, validating transformations, and driving high-quality integration outcomes. Role Summary The ERP Data Integration Analyst will support data integration and migration activities across multiple enterprise systems. This includes defining and documenting data mappings, validating transformation rules, supporting testing cycles, and ensuring data integrity throughout the lifecycle. You will collaborate closely with business stakeholders, technical teams, and implementation partners to translate business requirements into clear, actionable specifications. Key Responsibilities Data Mapping, Transformation & Integration • Create and maintain detailed data mapping documents (field definitions, transformation rules, data flow logic) • Define and validate transformation rules for accurate data movement • Analyze source and target system structures to establish mapping logic • Document integration requirements for development teams • Collaborate with integration teams using APIs and middleware platforms Data Validation & Quality Assurance • Perform end-to-end data validation, including: • Transformation logic validation • Source-to-target reconciliation • Business/report validation • Post-integration validation • Analyze large datasets (primarily Excel) to identify discrepancies and data quality issues • Execute reconciliation and data quality checks • Trace data requirements across documentation and reporting outputs Testing & Defect Resolution • Support data migration and downstream system updates • Lead testing efforts (unit, integration, migration, UAT) • Develop detailed test cases aligned with mappings and transformations • Identify and resolve data-related defects • Partner with technical teams to troubleshoot and validate fixes Data Migration Support • Support ERP data migration activities, including mapping updates and validation • Ensure alignment of migrated data across downstream systems • Contribute to overall migration and integration execution Business & Technical Collaboration • Act as a liaison between business and technical teams • Gather and clarify data requirements • Lead discussions on mappings and design documentation • Translate business needs into structured documentation • Collaborate across multiple workstreams and stakeholders Documentation & Governance • Develop and maintain Functional Design Documents (FDDs) • Document integration processes, mappings, and configurations • Create user guides for data definitions and flows • Manage tasks and stories in DevOps tools • Ensure alignment across requirements, design, and delivery artifacts Required Qualifications • 8+ years of experience in ERP data integration, data mapping, or data analysis • Strong experience with data mapping, transformation rules, and validation • Experience working with large datasets (Excel-heavy analysis) • Background in ERP financial systems and business processes • Experience supporting complex system integrations • Hands-on experience with testing cycles (unit, integration, UAT) • Ability to troubleshoot and resolve data-related issues • Experience creating Functional Design Documents and technical documentation • Strong communication skills across business and technical teams • Ability to lead discussions and influence stakeholders Preferred Qualifications • Experience with modern ERP platforms (e.g., Dynamics 365 or similar) • Experience in construction, project-based, or job cost environments • Familiarity with CRM and project management system integrations • SQL knowledge • Experience in Agile environments (2-week sprints) • Familiarity with DevOps tools (e.g., Azure DevOps) • Experience with integration platforms and APIs (e.g., MuleSoft or similar) • Experience with large-scale ERP data migration programs What Makes You Successful • Highly detail-oriented with a focus on data accuracy • Comfortable working with large datasets and solving complex data issues • Strong ability to manage multiple priorities in a fast-paced environment • Effective at bridging business and technical teams • Proactive, self-driven, and able to work with minimal oversight • Comfortable working in ambiguity and driving outcomes