Integration & Data Performance Engineer

P & A Administrative Services, Inc; Village of Williamsville (NY); On-site; USD 120,000 - 190,000; Full time

Job summary

P & A Administrative Services, Inc is seeking an experienced Integration & Data Performance Engineer to design, develop, and support enterprise interfaces and data integration solutions. You will enable secure, scalable data exchange across internal systems, cloud platforms, and partner ecosystems.

You will design and optimize ETL/ELT pipelines, ensure data quality and governance, and collaborate with cross-functional teams to deliver end-to-end integration solutions while supporting security

Qualifications

• Bachelor's degree in computer science, information technology, engineering, or a related field.
• 7–10+ years of enterprise integration, middleware, or data engineering experience.
• Strong experience with REST APIs, SOAP, JSON, XML, and web services.

Responsibilities

• Design, develop, and maintain enterprise interfaces using REST APIs, SOAP services, file-based integrations, and middleware.
• Build, implement, and support integrations with external partners, vendors, and third-party apps.
• Develop ETL/ELT pipelines for ingesting, transforming, and loading data into data lakes.

Skills

REST APIs

SOAP

JSON/XML

Analytical skills

CI/CD

Problem solving

Communication

Agile

Education

Bachelor's degree in Computer Science or related field

Tools

Azure Integration Services

IBM Integration Bus

Azure Data Lake

Amazon S3

Snowflake

Databricks

Git

Docker

Kubernetes

Job description

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.

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

• Enterprise Application Integration
• Partner & Third-Party Integration
• Data Lake Integration
• ETL/ELT Pipeline Development
• API Development & Management
• Cloud Data Platforms
• Data Quality & Governance
• Interface Monitoring & Support
• Performance Optimization
• Root Cause Analysis
• 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.