Integration & Data Performance Engineer

P&A Group, Inc.; Village of Williamsville (NY); On-site; USD 110,000 - 170,000; Full time

Job summary

P&A Group, Inc. is seeking an experienced Integration & Data Performance Engineer to design, develop, and support enterprise interfaces, partner integrations, and data integration solutions.

The role focuses on building secure, scalable integrations between internal systems, external partners, and cloud platforms to enable efficient data exchange and analytics. The candidate will optimize ETL/ELT pipelines and ensure data quality and governance.

Qualifications

• Bachelor’s degree or equivalent in computer science, IT, or engineering.
• 7–10+ years of experience in enterprise application integration, middleware development, or data engineering.
• Strong experience with REST APIs, SOAP, JSON, XML, and web services.
• Experience with integration platforms such as Azure Integration Services, IBM Integration Bus, or similar technologies.
• Experience developing ETL/ELT pipelines and integrating with enterprise data lakes.
• Strong SQL skills and experience with relational and cloud-based databases.

Responsibilities

• Design, develop, and maintain enterprise interfaces using REST APIs, SOAP services, file-based integrations, event-driven messaging, and middleware platforms.
• Build, implement, and support integration with external partners, vendors, customers, and third-party applications.
• Design and maintain integrations between operational systems and enterprise data lakes to support reporting, analytics, AI/ML, and BI.
• Develop and optimize ETL/ELT pipelines for ingesting, transforming, validating, and loading data into cloud and on‑prem data lakes.
• Ensure high data quality, consistency, integrity, and governance across integrated systems and data platforms.
• Monitor interface performance, data pipelines, and integration health; troubleshoot failures and implement corrective actions.
• Collaborate with cross-functional teams to deliver end-to-end integration solutions.
• Implement monitoring, logging, alerting, and automated recovery for critical integrations.
• Perform root cause analysis for interface and data issues and implement preventive solutions.
• Create and maintain technical documentation, interface specifications, data mappings, and operational procedures.
• Support production deployments, upgrades, and ongoing operational support.
• Ensure compliance with enterprise security, data governance, privacy, and regulatory standards.

Skills

REST APIs

SOAP

JSON

XML

Web services

Azure Integration Services

IBM Integration Bus

ETL/ELT pipelines

SQL

Cloud data platforms

Git

CI/CD

DevOps

Agile/Scrum

Education

Bachelor’s degree in computer science, Information Technology, Engineering, or a related field

Tools

Azure Integration Services

IBM Integration Bus

Git

CI/CD pipelines

Docker

Kubernetes

Job description

We are seeking an experienced Integration & Data Performance Engineer to design, develop, and support enterprise interfaces, partner integrations, and data integration solutions. This role is responsible for building secure, scalable, and high-performing integrations between internal systems, external partners, cloud platforms, and enterprise data lakes to enable efficient data exchange, analytics, and business operations.

ESSENTIAL FUNCTIONS

Key Responsibilities

• Design, develop, and maintain enterprise interfaces using REST APIs, SOAP services, file-based integrations, event-driven messaging, and middleware platforms.
• Build, implement, and support integration with external partners, vendors, customers, and third-party applications.
• Design and maintain integrations between operational systems and enterprise data lakes to support reporting, analytics, AI/ML, and business intelligence initiatives.
• Develop and optimize ETL/ELT pipelines for ingesting, transforming, validating, and loading data into cloud and on-premises data lakes.
• Ensure high data quality, consistency, integrity, and governance across integrated systems and data platforms.
• Monitor interface performance, data pipelines, and integration health; troubleshoot failures and implement corrective actions.
• Optimize data processing, database performance, and integration throughput to improve scalability and reliability.
• Collaborate with application development, data engineering, infrastructure, security, and business teams to deliver end-to-end integration solutions.
• Implement monitoring, logging, alerting, and automated recovery for critical integrations.
• Perform root cause analysis for interface and data issues and implement preventive solutions.
• Create and maintain technical documentation, interface specifications, data mappings, and operational procedures.
• Support production deployments, upgrades, and ongoing operational support.
• Ensure compliance with enterprise security, data governance, privacy, and regulatory standards.

QUALIFICATIONS

EDUCATION / EXPERIENCE

• Bachelor’s degree in computer science, Information Technology, Engineering, or a related field.
• 7–10+ years of experience in enterprise application integration, middleware development, or data engineering.
• Strong experience with REST APIs, SOAP, JSON, XML, and web services.
• Experience with integration platforms such as Azure Integration Services, IBM Integration Bus, or similar technologies.
• Experience developing ETL/ELT pipelines and integrating with enterprise data lakes.
• Strong SQL skills and experience with relational and cloud-based databases. Experience with cloud data platforms such as Azure Data Lake, Amazon S3, Snowflake, Databricks, or similar technologies.
• Experience with Git, CI/CD pipelines, and DevOps practices.
• Strong analytical, troubleshooting, and problem-solving skills.

Preferred Qualifications

• Experience with AWS, Databricks, and Microsoft Azure.
• Knowledge of containerization (Docker), and Kubernetes.
• Experience with data governance, metadata management, and data quality frameworks.
• Familiarity with performance monitoring and observability tools.
• Experience working in Agile/Scrum development environments.

Key Skills

• Partner & Third-Party Integration
• Data Lake Integration
• API Development & Management
• Data Quality & Governance
• Interface Monitoring & Support
• Performance Optimization
• Technical Documentation
• Agile Delivery & Collaboration

COMPETENCIES

• Professionalism and Executive Presence
• Confidentiality and Discretion
• Organization and Attention to Detail
• Communication and Relationship Building
• Problem Solving and Critical Thinking
• Adaptability and Flexibility
• Initiative and Accountability
• Time and Priority Management

WORKING CONDITIONS

Fast-paced work environment; flexibility to work schedules as required due to changing business demands. The work environment is moderately sedentary and typical of general office conditions with regard to standing, sitting, walking and lifting; no adverse conditions.

An equal opportunity employer and a smoke, drug and alcohol-free workplace.