Data Engineer & API Automation Architect

The McPherson Companies; Trussville (AL); On-site; USD 85,000 - 125,000; Full time

Job summary

The McPherson Companies seeks a Hands-on Data Engineer / API Integration Developer to build and support modern data pipelines, system integrations, automation workflows, and internal web applications. You will work across business systems, cloud platforms, databases, APIs, and AI-assisted development tools to deliver practical solutions that improve operational visibility and enterprise data flow.

The ideal candidate will move between data engineering, API development, and workflow automation,

Qualifications

• Strong experience with Python for data engineering, API integrations, and backend services.
• Strong SQL skills with data validation and performance troubleshooting.
• Experience developing or consuming REST APIs, webhooks, JSON, XML.
• Experience with PHP or similar backend web development languages.
• Experience building workflows using n8n.
• Experience with Snowflake and AWS.

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 applications, and custom internal tools.
• Build and maintain workflows using n8n and similar automation platforms.
• Develop scripts, services, and lightweight applications using Python, PHP, SQL, and modern web technologies.
• Work with Snowflake to support data ingestion, transformation, modeling, and reporting needs.
• Support integration with cloud AI platforms such as AWS Bedrock and related services.
• Assist in the development of internal AI-enabled tools, workflow automations, and business process applications.
• Use AI-assisted development tools and “vibe coding” practices responsibly to accelerate development while maintaining quality, security, and maintainability.
• Build and support web applications, internal portals, dashboards, and integration interfaces.
• Partner with IT, finance, operations, sales, and business stakeholders to understand requirements and translate them into technical solutions.
• Create reusable integration patterns, documentation, error handling, logging, and monitoring for production workflows.
• Assist with data quality, data profiling, data mapping, and source-to-target validation.
• Work with authentication, authorization, and identity platforms such as WorkOS or similar tools.
• Support integrations involving ERP, CRM, service management, eSignature, document automation, analytics, and AI workflow platforms.
• Troubleshoot production issues related to APIs, ETL jobs, workflows, databases, and application integrations.
• Other duties and responsibilities as assigned by management.

Skills

Python

SQL

REST APIs

PHP

n8n

Snowflake

AWS

AI tools

Data pipelines

ETL

Tools

Docker

GitHub

CI/CD

WorkOS

Job description

The McPherson Companies seeks a Hands-on Data Engineer / API Integration Developer to build and support modern data pipelines, system integrations, automation workflows, and internal web applications. You will work across business systems, cloud platforms, databases, APIs, and AI-assisted development tools to deliver practical solutions that improve operational visibility and enterprise data flow.

The ideal candidate will move between data engineering, API development, and workflow automation,