Data Engineer & API Automation Specialist

The McPherson Companies; Rolling Hills (AL); On-site; USD 80,000 - 110,000; Full time

Job summary

The McPherson Companies is seeking a hands-on Data Engineer / API Integration Developer to design, build, and support modern data pipelines, system integrations, automation workflows, and internal web apps across enterprise systems.

Candidates should be proficient with Python, SQL, PHP, and tools like n8n, Snowflake, and AWS services, and comfortable prototyping, testing, and deploying solutions that improve operational visibility and data flow. JD Edwards EnterpriseOne exposure is a plus.

Qualifications

• Experience with Python for data engineering, API integrations, automation, and backend services.
• Strong SQL skills including joins, data validation, and performance troubleshooting.
• Experience developing or consuming REST APIs, webhooks, JSON, XML, and integration patterns.
• Experience with PHP or similar backend web development languages.
• Experience building workflows or automations using n8n.
• Experience with cloud-based data platforms, preferably Snowflake.
• Experience working with AWS services; AWS Bedrock experience preferred.
• Experience building internal web applications, portals, dashboards, or business process tools.
• Understanding authentication and authorization concepts (OAuth, SAML, JWT, API keys, RBAC).
• Ability to use AI-assisted development tools effectively while validating and securing code.
• Strong troubleshooting across applications, databases, APIs, and workflow tools.

Responsibilities

• Design, build, and maintain data pipelines between enterprise applications, databases, cloud platforms, and internal systems.
• Develop API integrations between ERP, CRM, service platforms, third-party apps, and internal tools.
• Build and maintain workflows using n8n and similar platforms.
• Develop scripts, services, and lightweight apps using Python, PHP, SQL, and modern web technologies.
• Work with Snowflake to support data ingestion, transformation, modeling, and reporting.

Skills

Python

SQL

REST APIs

PHP

n8n

Snowflake

AWS

AI-assisted tools

Data pipelines

Workflow automation

Tools

Snowflake

n8n

AWS Bedrock

WorkOS

Job description

The McPherson Companies is seeking a hands-on Data Engineer / API Integration Developer to design, build, and support modern data pipelines, system integrations, automation workflows, and internal web apps across enterprise systems.

Candidates should be proficient with Python, SQL, PHP, and tools like n8n, Snowflake, and AWS services, and comfortable prototyping, testing, and deploying solutions that improve operational visibility and data flow. JD Edwards EnterpriseOne exposure is a plus.