Senior Integration Developer Sage Intacct ERP and Database Systems

OMNIDEK

United States

5 days ago

Apply on www.indeed.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Compensation

$100,000.0 - $125,000.0

Working hours

Regular working hours

Job source

www.indeed.com

Tech stack

Clean Code Principles Java (Programming Language) .NET Framework Application Programming Interfaces (APIs) Audit Trail User Authentication C Sharp (Programming Language) Software as a Service Databases Data Validation Data Deduplication Data Integrity

+42 more

Extract Transform Load (ETL) Data Mapping Data Transformation Data Sharing Data Synchronization Data Warehousing Relational Databases Payment Systems Middleware Intacct JSON Python (Programming Language) PostgreSQL Microsoft Dynamics Microsoft SQL Server MySQL Netsuite Node.Js Oracle (Applications) Sage Accounting SAP (Applications) Simple Object Access Protocol (SOAP) SQL Stored Procedures SQL Databases Data Streaming Systems Integration TypeScript Web Services Extensible Markup Language (XML) Data Logging Transaction Processing (Computing) File Transfer Protocol (FTP) Cloud Platform System Real Time Systems Backend Git Acumatica Cloud ERP Platform Enterprise Integration Integration Frameworks Restful APIs Integration Monitoring Webhooks

Job description

The right candidate can trace data from a form or source system through validation, transformation, business rules, storage, submission to an ERP, response handling, and monitoring. Direct Sage Intacct experience is strongly preferred; deep integration experience with another ERP can also be relevant.

What you will do

Sage Intacct and ERP integrations

Design, build, maintain, and troubleshoot bidirectional integrations between Sage Intacct and portals, applications, databases, payment systems, and customer platforms.

Work with Intacct Web Services and XML APIs, and REST APIs where applicable; map objects, dimensions, custom fields, and transaction relationships.

Support processes involving vendors, customers, AP bills, purchase orders, expenses, payments, projects, and other financial records.

Translate business requirements into reliable data flows with clear validation, error handling, and reconciliation.

Custom services and backend development

Develop APIs, middleware, and reusable services that transform, validate, enrich, route, and synchronize data.

Integrate using XML, JSON, REST, SOAP or Web Services, webhooks, CSV, flat files, and SFTP as required.

Build scheduled, event-driven, and near real-time processing with appropriate authentication, retries, and exception handling.

Connect external validation and compliance services to workflow decisions, alerts, and alternate paths.

Database architecture and data quality

Design and optimize relational schemas, staging tables, complex SQL, views, functions, stored procedures, and data transformation processes.

Develop mapping, normalization, matching, deduplication, validation, audit logging, and reconciliation processes.

Investigate data integrity and performance issues across high-volume transactional systems, reporting databases, and data warehouses.

Reliability and support

Choose suitable synchronous, asynchronous, queued, or scheduled patterns for each integration; build monitoring and actionable alerts.

Diagnose failures across payloads, APIs, databases, logs, and ERP configuration; resolve root causes and document findings.

Work directly with implementation teams and customers to explain technical issues and deliver maintainable solutions.

Requirements

Strong professional experience in backend development and systems integration, with substantial hands-on SQL and relational database work.

Ability to develop and troubleshoot APIs and data exchanges using XML, JSON, REST, and SOAP or Web Services.

Experience with data mapping, ETL or ELT concepts, data synchronization, authentication, logging, and exception handling.

Working knowledge of accounting, ERP, or other transactional systems and the importance of financial data integrity.

Proficiency in at least one backend language such as C#, .NET, Python, Java, or Node.js or TypeScript; experience with Git.

Ability to read technical documentation independently, design a solution, write maintainable code, and own issues through resolution.

Preferred experience

Five or more years in software or integration development.

Direct Sage Intacct Web Services, XML API, REST API, custom field, custom object, dimension, authentication, or API troubleshooting experience.

Experience integrating NetSuite, Microsoft Dynamics, Oracle, SAP, Acumatica, or another major ERP.

Experience with SQL Server, PostgreSQL, MySQL, or similar platforms; cloud environments; queues; background jobs; and multi-tenant SaaS systems.

Experience with integration platforms, data warehouses, third-party data validation, customer-facing technical work, and high-volume transaction processing.

Representative projects

Vendor and customer synchronization; AP bill and purchase order integrations; vendor onboarding; expense and payment workflows; tax ID and compliance verification; customer-specific APIs; external portals; scheduled database synchronization; flat-file feeds; integration monitoring; and reconciliation services.