Senior IT Systems & Integration Architect

Appliance Replacement, Inc; Deacons (NJ); On-site; USD 100,000 - 120,000; Full time

Job summary

Multi-Housing Depot seeks a Senior IT Systems & Integration Engineer to own enterprise integrations, SQL database development, and automation across ERP, e-commerce, and middleware platforms. You will diagnose complex failures, work independently across technologies, and provide high-level escalation support for security and infrastructure.

The role requires a 7+ year IT background, ERP experience (Prophet 21 or similar), and strong scripting skills.

Qualifications

• Bachelor’s degree in IT, Computer Science, Information Systems (or equivalent practical experience) with 7+ years of IT experience.
• Advanced proficiency with Microsoft SQL Server (complex queries, CTEs, stored procedures, schema design, query optimization).
• Experience developing/troubleshooting integrations using REST APIs, JSON, XML, and middleware tools.
• Ability to write/maintain scripts in Python, PHP, PowerShell, or SQL to automate processes.
• Solid understanding of core business operations and ERP architectures.
• Knowledge of Windows Server admin, networking fundamentals, and security controls.
• Excellent diagnostic skills and ability to triage urgent outages alongside long-term projects.

Responsibilities

• Develop, monitor, and troubleshoot integrations between ERP, BigCommerce B2B Edition, and third-party apps using REST APIs and middleware.
• Write and optimize SQL Server queries, stored procedures, views, and reports using Crystal Reports or SAP BusinessObjects.
• Create and maintain automated scripts to streamline repetitive business processes.
• Configure and troubleshoot ERP functions (pricing, purchasing, inventory, order processing, financials).
• Provide escalation support for server, network, and endpoint security issues beyond level-2 support.
• Coordinate with vendors and consultants to evaluate, implement, and maintain technical solutions.

Skills

SQL

REST APIs

Python

PowerShell

ERP systems

Troubleshooting

Automation

Education

Bachelor’s degree in IT/CS

Tools

Epicor Prophet 21

BigCommerce

Crystal Reports

SAP BusinessObjects

SonicWall

Job description

Multi-Housing Depot seeks a Senior IT Systems & Integration Engineer to own enterprise integrations, SQL database development, and automation across ERP, e-commerce, and middleware platforms. You will diagnose complex failures, work independently across technologies, and provide high-level escalation support for security and infrastructure.

The role requires a 7+ year IT background, ERP experience (Prophet 21 or similar), and strong scripting skills.