Data Engineer​/API Integration Developer

Position: Data Engineer / API Integration Developer
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 Enterprise One 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 n8nExperience 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 Enterprise One 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 ELTETL 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 identityaccess management platforms

Experience with Git Hub CICD pipelines Docker containerized applications and Dev Ops practices

Experience with JavaScript Type Script Nodejs 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 hisher 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 MFVetsDisabled