ERP Integration Specialist

Company Overview:

Lumber is an all-in-one construction workforce management platform that seamlessly streamlines payroll, time tracking, safety, compliance, field productivity, rewards, and recognition for building contractors. Our platform integrates deeply with multiple ERP systems including Sage 100, Sage 300 CRE (Construction Real Estate), Sage Intacct, Acumatica, NetSuite, and other construction industry ERPs to deliver seamless data synchronization and operational efficiency.

Role Summary:

We are seeking an experienced Sage ERP Integration Specialist to lead customer implementations, configure integration workflows, and provide technical support for LumberFi's Sage ERP integrations across Sage 100, Sage 300 CRE, and Sage Intacct platforms. This role requires deep expertise in Sage's architecture, API capabilities, and construction industry business processes. The ideal candidate will bridge the gap between technical implementation and customer success, ensuring smooth data flows between LumberFi and Sage systems.

Key Responsibilities:

ERP Implementation & Integration:

Execute end-to-end Sage integration implementations for construction industry clients, including requirement gathering, data mapping, configuration, testing, and go-live support.

Design and configure bi-directional data synchronization workflows between LumberFi and Sage ERP systems for timesheets, payroll, employees, projects, cost codes, job costs, and GL journals

Implement Sage modules including General Ledger, Accounts Payable, Accounts Receivable, Payroll, Job Cost, Project Management, and Time & Billing across Sage 100, Sage 300 CRE, and Sage Intacct platforms

Configure Sage's integration frameworks including Sage 100 SDK, Sage 300 CRE Web Services, and Sage Intacct Web Services to support automated integration scenarios

Set up and maintain Sage import/export scenarios, API endpoints, custom integration screens, and data synchronization schedules

Configure Sage-specific job cost structures, WIP tracking, certified payroll requirements, and

construction-specific workflows.

Technical Configuration & Troubleshooting:

Troubleshoot and resolve complex integration issues including API authentication failures, data synchronization errors, GL journal generation problems, and job cost posting failures

Analyze Sage database schemas (Sage 100 Pervasive/SQL Server, Sage 300 CRE SQL Server, Sage Intacct cloud database) and API responses to diagnose integration failures and optimize data flows

Create and maintain entity mapping documentation between LumberFi's data model and Sage's schema across different Sage product lines

Monitor integration performance through CloudWatch logs and other monitoring tools, proactively identifying and resolving issues

Implement error handling and retry mechanisms for robust integration operations

Debug Sage-specific integration challenges including multi-company configurations, cost code mappings, union payroll complexities, and certified payroll reporting.

Customer Support & Documentation:

Provide technical support to customers during and after Sage implementation, serving as the primary point of contact for integration-related questions

Create comprehensive integration playbooks, user guides, and API documentation for customer onboarding specific to each Sage platform

Conduct training sessions for customers on Sage integration workflows, data validation procedures, job cost tracking, and best practices

Collaborate with customers to understand their unique business requirements and configure Sage accordingly

Design and document custom integration workflows tailored to specific customer needs, especially around construction-specific requirements

Data Management & Quality:

Manage data migration from legacy systems to Sage using import scenarios, templates, ETL processes, and Sage-specific data conversion tools

Ensure data integrity across systems by implementing validation rules and conducting thorough testing of critical construction data (cost codes, job assignments, union classifications, etc.)

Perform User Acceptance Testing (UAT), system integration testing, and issue resolution before go-live

Develop SQL queries for data analysis, audit trails, and troubleshooting integration issues across Sage databases

Maintain data synchronization accuracy for critical entities including employees, timesheets, projects, cost codes, job costs, payroll data, and union fringe benefits

Validate GL journal entries, cost code allocations, and job cost postings to ensure accurate financial reporting.

Cross-functional Collaboration:

Work closely with LumberFi's engineering team to enhance integration capabilities and

resolve technical issues

Collaborate with Customer Success and Support teams to triage and resolve customer tickets efficiently

Partner with internal stakeholders to document API requirements and integration specifications

Contribute to the continuous improvement of integration architecture and customer onboarding processes

Participate in technical reviews and provide feedback on integration design and implementation

Coordinate with Sage support teams and Value-Added Resellers (VARs) when necessary to resolve platform-specific issues

Who Can Apply:

Educational Background:

Bachelor's degree in Commerce (B.Com) with MBA/PG in any stream, OR

Bachelor's degree in Computer Science, Information Systems, or related technical field

Minimum 75% aggregate in academics

Technical Skills (Must Have):

5+ years of hands-on experience implementing, configuring, or supporting Sage ERP systems (Sage 100, Sage 300 CRE, or Sage Intacct)

Deep understanding of at least one Sage platform's API architecture: Sage 100 (SDK, Business Object Interface), Sage 300 CRE (Web Services, SOAP APIs), or Sage Intacct (Web Services API, RESTful endpoints)

Experience with Sage modules: General Ledger, Job Cost, Payroll, Accounts Payable/Receivable, Project Management, and Time Management

Proficiency in SQL and database management for data analysis and troubleshooting (Pervasive, SQL Server, or cloud databases)

Experience with API integration tools, authentication mechanisms (API keys, OAuth, Basic Auth), and RESTful/SOAP services

Understanding of ERP data models, entity relationships, and integration patterns specific to construction industry ERPs

Experience with Sage-specific concepts: job numbers, cost codes, cost types, equipment tracking, and WIP accounting

Domain Knowledge:

Strong understanding of construction industry business processes including project accounting, job costing, cost code structures, timesheets, and union payroll

Knowledge of core business processes: financial accounting, GL journal entries, accounts payable/receivable, payroll processing, and cost allocation

Familiarity with construction-specific requirements such as certified payroll, prevailing wage, workers compensation, Davis-Bacon compliance, and union fringe benefits

Understanding of multi-company, multi-entity, and intercompany accounting scenarios

Knowledge of construction job cost accounting including WIP, percent complete, and

revenue recognition

Preferred Qualifications

Experience with multiple Sage platforms (Sage 100, Sage 300 CRE, and Sage Intacct)

Experience with other ERP systems (Acumatica, NetSuite, QuickBooks, or Premier)

Knowledge of SaaS architecture, multi-tenant systems, and cloud-based integrations

Experience with integration monitoring tools (CloudWatch, DataDog, or similar)

Familiarity with version control systems (Git) and documentation tools

Sage certifications in any platform (Sage 100 Certified Consultant, Sage 300 CRE Certified, or Sage Intacct Certified Professional)

Experience with Python, JavaScript, or other scripting languages for automation

Experience with Sage partner ecosystem and Value-Added Resellers (VARs)

Understanding of Sage Construction and Real Estate (CRE) specific functionality

Soft Skills

Excellent analytical and problem-solving abilities with attention to detail

Ability to work independently and collaboratively in a fast-paced startup environment

Customer-focused mindset with commitment to delivering high-quality solutions

Why Join Lumber

Work in a dynamic startup environment and gain hands-on experience in payroll operations.

Learn directly from industry experts in FinTech and SaaS.

Opportunity to grow into advanced roles in payroll architecture, compliance, or customer success.