Integration Engineer: API & ETL Data Pipelines

Paycom - ATS; Lakeland (FL); Hybrid; USD 85,000 - 110,000; Full time

Job summary

Paycom - ATS in Lakeland, Florida is seeking an Integration Analyst to design, develop, test, and maintain cross-system integrations using Python, MSSQL, APIs, and SFTP. The role emphasizes data validation, ETL best practices, and ensuring data accuracy during transfers across platforms.

You will collaborate with product and IT teams to gather requirements, troubleshoot issues, and document integration architectures and procedures.

Qualifications

• Bachelor's degree in Computer Science or related field, or Associate’s degree with equivalent experience.
• 3–5 years of experience with integrations or similar technologies.
• Proven experience in Python and MSSQL.
• Experience with data validation and ETL methodologies.

Responsibilities

• Develop, test, and maintain integration solutions between systems.
• Work with APIs, SFTP, SQL, CSV, and JSON to connect and transfer data between systems.
• Utilize Python and MSSQL to develop and manage data integration processes.
• Implement and manage ETL methodologies to ensure data accuracy and consistency.
• Conduct data validation to ensure data integrity and quality.
• Collaborate with cross-functional teams to gather integration requirements and deliver solutions.
• Troubleshoot and resolve integration issues in a timely manner.
• Document integration processes, procedures, and solutions.

Skills

Python

MSSQL

APIs

ETL

Data validation

Analytical thinking

Detail-oriented

Team collaboration

Independent work

Education

Bachelor's degree in Computer Science or related field

Associate’s degree with equivalent experience

Master's degree in Computer Science or related field

Preferred certifications (e.g., PCPP, PCAP, Azure DBA, AWS Developer)

Tools

HTML

CSS

JavaScript

PowerShell

GraphQL

JSON

SFTP

APIs

Job description

Paycom - ATS in Lakeland, Florida is seeking an Integration Analyst to design, develop, test, and maintain cross-system integrations using Python, MSSQL, APIs, and SFTP. The role emphasizes data validation, ETL best practices, and ensuring data accuracy during transfers across platforms.

You will collaborate with product and IT teams to gather requirements, troubleshoot issues, and document integration architectures and procedures.