Senior IT Systems & Integration Engineer

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

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Senior IT Systems & Integration Engineer

IT Department Burlington, NJ, US

Salary Range: $100,000.00 To $120,000.00 Annually

Position Summary

Multi-Housing Depot is seeking a versatile,hands-on Senior IT Systems & Integration Engineer to support,develop,and optimize the critical technology systems underlying our business operations.

This is an advanced individual-contributor technical role - not a people-management or primary help desk position.It combines hands-on work in enterprise integrations,SQL database development,e-commerce middleware,and script automation with high-level technical oversight and escalation support for server,network,and security infrastructure.

The ideal candidate is a analytical problem-solver who excels at diagnosing complex,multi-system failures,working independently across diverse technologies,and effectively triaging competing operational priorities.

Key Responsibilities

Primary Execution (Hands-On Operations & Development)

E-Commerce & Systems Integration: Develop,monitor,and troubleshoot integrations between ERP systems,BigCommerce B2B Edition,and third-party applications using REST APIs,JSON,XML,cXML,and middleware platforms.

Database & Business Intelligence: Write,optimize,and maintain SQL Server queries,stored procedures,views,and custom reporting using Crystal Reports or SAP BusinessObjects.Automate data validation,reconciliation,and reporting alerts.

Software Development & Automation: Build and maintain custom scripts and diagnostic utilities using Python,PHP,PowerShell,or SQL to automate repetitive business processes and streamline operations.

Enterprise ERP Support: Configure and troubleshoot core ERP functions (pricing,purchasing,inventory,order processing,and financials).Investigate application errors and data synchronization issues across systems.

Infrastructure & Security Escalation: Serve as the senior technical escalation resource for complex Windows Server,Linux,network (SonicWall,VPNs,DNS),backup,and endpoint security issues that exceed basic tier-1/tier-2 support.

Vendor & Project Coordination: Coordinate with external software vendors,middleware providers,and consultants to evaluate,implement,and maintain technical solutions and upgrades.

Process Improvement & Documentation: Identify operational bottlenecks,document custom integration logic and standard operating procedures,and design solutions that reduce manual effort and system downtime.

Required Qualifications

Education & Experience: Bachelor’s degree in IT,Computer Science,Information Systems (or equivalent practical experience) with a minimum of 7 years of progressively responsible IT experience supporting business-critical enterprise systems.

Database Expertise: Advanced proficiency with Microsoft SQL Server (complex queries,CTEs,stored procedures,schema design,and query optimization).

Integration & APIs: Practical experience developing and troubleshooting integrations using REST APIs,JSON,XML,and middleware tools.

Scripting & Development: Demonstrated ability to write and maintain clean,functional scripts/tools in at least one language (Python,PHP,PowerShell,etc.).

Systems & ERP Awareness: Solid understanding of core business operations (inventory,order fulfillment,distribution,pricing) and experience with enterprise ERP architectures.

Infrastructure Knowledge: Functional understanding of Windows Server administration,networking fundamentals (TCP/IP,firewalls,VPNs),and security controls.

Problem-Solving & Prioritization: Exceptional diagnostic and analytical skills with a proven track record of triaging high-urgency operational outages alongside long-term project deliverables.

Preferred Qualifications

Direct experience administering or supportingEpicor Prophet 21 (P21) (or comparable wholesale distribution ERP systems such as Infor,Netsuite,or SAP).

Experience with enterprise e-commerce platforms (BigCommerce B2B,Magento) and electronic procurement/EDI/cXML punchout integrations.

Experience creating business reports in Crystal Reports or SAP BusinessObjects.

Hands-on experience configuring SonicWall firewalls,site-to-site VPNs,Active Directory,and Group Policy.

Master’s degree in Information Technology or Computer Science.

Personal & Professional Attributes

Technical Versatility: Rapidly adapts to unfamiliar platforms,legacy tools,or new integration standards without requiring step-by-step guidance.

Diagnostic Rigor: Approaches troubleshooting methodically - isolating root causes across data layers,API payloads,and network environments.

Business-Centric Mindset: Evaluates technical decisions through the lens of business value,user impact,and operational reliability.

Clear Communication: Translates technical root-cause analyses into clear actionable recommendations for business leaders and operational teams.

Effective Triage: Calmly evaluates competing demands (e.g.,an order sync failure vs.a routine feature request) and allocates focus according to actual business impact.

What Makes This Position Different

Rather than siloing you in a single application or managing team logistics, this role gives you direct engineering ownership across custom integrations, databases, automated workflows, and high-level technical troubleshooting. You will solve immediate operational challenges while building cleaner, more maintainable automated systems for the organization.