- Salary
- $125k – $155k/yr
- Location
- Williamsville, NY
- Department
- Engineering
- Experience
- 7+ years
- Source
- Paylocity
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.
Requirements
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.