Data Engineer / API Integration Developer
Back to Jobs
The McPherson CompaniesGet Smart Job AI Coach in the appFree on iOS and Android 






Data Engineer / API Integration Developer
Location
Trussville, AL
Experience
Mid
Posted
Jul 11, 2026
Apply by
August 10, 2026
Applicants
0
Early applicantEasy applyFull-timeWork from Office
Job Description
General Summary:
Hands-on Data Engineer / API Integration Developer to help build and support modern data pipelines, system integrations, automation workflows, and internal web applications. This role will work across business systems, cloud platforms, databases, APIs, and AI-assisted development tools to deliver practical solutions that improve operational visibility, process automation, and enterprise data flow.
The ideal candidate is a builder who can move between data engineering, API development, workflow automation, and application prototyping. This person should be comfortable using Python, SQL, PHP, n8n, Snowflake, AWS services, and AI-assisted development tools to rapidly develop, test, and deploy business solutions. Experience with JD Edwards EnterpriseOne is a strong plus.
Primary Responsibilities and Duties:
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.
Position Requirements:
Strong experience with Python development for data engineering, API integrations, automation, and backend services.
Strong SQL skills, including querying, joins, stored procedures, data validation, and performance troubleshooting.
Experience developing or consuming REST APIs, webhooks, JSON, XML, and other 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 such as OAuth, SAML, JWT, API keys, and role-based access control.
Ability to use AI-assisted development tools effectively while still understanding, validating, and securing the code produced.
Strong troubleshooting skills across applications, databases, APIs, and workflow automation tools.
Ability to document technical designs, integration flows, dependencies, and support procedures.
Preferred Qualifications:
Experience with JD Edwards EnterpriseOne, Orchestrator, AIS, business functions, tables, or JDE integrations.
Experience integrating ERP, CRM, service management, billing, AR, AP, or financial systems.
Experience with Oracle databases, Microsoft SQL Server, or other enterprise relational databases.
Experience with data modeling, data warehousing, ELT/ETL patterns, and analytics enablement.
Experience with AWS Bedrock, AI agents, vector databases, RAG patterns, prompt engineering, or AI workflow automation.
Experience with WorkOS or other identity/access management platforms.
Experience with GitHub, CI/CD pipelines, Docker, containerized applications, and DevOps practices.
Experience with JavaScript, TypeScript, Node.js, React, or similar web application frameworks.
Experience working in a mid-market enterprise environment with a mix of legacy systems and modern cloud platforms.
The above-noted job description is not intended to describe, in detail, the multitude of tasks that may be assigned but rather to give the associate a general sense of the responsibilities and expectations of his/her position. As the nature of business demands change so, too, may the essential functions of this position.
The McPherson Companies, Inc. is an Equal Opportunity Employer � M/F/Vets/Disabled.
Key Responsibilities
- Design, build, and maintain data pipelines between enterprise applications and cloud platforms.
- Develop API integrations between ERP, CRM, and third-party applications.
- Build and maintain workflows using n8n and similar automation platforms.
- Develop scripts and lightweight applications using Python, PHP, and SQL.
- Support data ingestion, transformation, and modeling in Snowflake.
- Assist in developing internal AI-enabled tools and workflow automations.
- Use AI-assisted development tools to accelerate development while maintaining security.
- Build and support internal web applications, portals, and dashboards.
- Partner with stakeholders to translate business requirements into technical solutions.
- Create reusable integration patterns, documentation, and monitoring for production workflows.
- Troubleshoot production issues related to APIs, ETL jobs, and databases.
Skills Required
PythonSQLPHPn8nSnowflakeAWSREST APIsWebhooksJSONXMLOAuthSAMLJWTAI-assisted development toolsTroubleshootingDocumentationCollaborationJD Edwards EnterpriseOneOrchestratorAISOracle databasesMicrosoft SQL ServerData modelingData warehousingELT/ETL patternsAWS BedrockAI agentsVector databasesRAG patternsPrompt engineeringWorkOSGitHubCI/CD pipelinesDockerJavaScriptTypeScriptNode.jsReact
App exclusive · Free
Smart Job AI Coach
Your personal interview coach on every job — readiness tips, profile improvements, and role-specific prep. Available only in the Pulse Job app.
Interview readiness
See how prepared you are and what to improve for each role.
Personalized tips
Actionable suggestions based on your profile and the job.
After you apply
Keep coaching momentum from job detail through application success.
Similar roles for you
Matched using this role's title and skills. Open the job search anytime to see every listing.

Integration Developer
Datamatics Technologies
Full-timeEasy applyWork from Office
RiyadhMid

Integration Developer
Datamatics Technologies
Full-timeEasy applyWork from Office
CairoMid

Integration Developer
Datamatics Technologies
Full-timeEasy applyWork from Office
BengaluruMid

Integration Developer
Datamatics Technologies
Full-timeEasy applyWork from Office
KarachiMid

AWS Cloud & Integration Developer
Eileen Fisher
120,000–135,000 / Year
Full-timeEasy applyWork from Home
RemoteMid

Senior Data Engineer
RBC
Full-timeEasy applyWork from Office
TORONTOSenior