JOB SUMMARY:The Business Automation Integration Engineer is responsible for designing, developing, implementing, testing, and maintaining integrations and automated workflows across enterprise applications, data platforms, and third-party systems. This role translates business and technical requirements into secure, reliable, and scalable solutions that improve system connectivity, data accuracy, and operational efficiency.
The successful candidate combines hands-on engineering expertise with exceptional organizational, communication, and interpersonal skills. The position requires strong problem-solving abilities, sound judgment, and a proactive, can-do approach to resolving application integration needs within reasonable business timeframes.
QUALIFICATIONS:- Bachelor's degree in Computer Science, Information Technology, Information Systems, Software Engineering, or a related field; equivalent relevant education and experience may be considered.
- At least three years of experience in application integration, automation engineering, data engineering, systems development, or a related technical discipline.
- Demonstrated experience delivering and supporting production integrations, automated workflows, and data pipelines.
- Experience working with ERP, CRM, financial, operational, or other enterprise business applications.
- Technical proficiency in system design, system integration, system testing, deployment, troubleshooting, and technical documentation.
- Experience with API integration, including REST, SOAP, authentication methods, JSON, XML, web services, and error handling.
- Experience with SFTP configuration and secure automated file-transfer processes.
- Proficiency in Python-based scripting for automation and data processing.
- Experience with PowerShell and command-line scripting.
- Experience with ERP and CRM integration development, including pipeline creation and data synchronization.
- Experience automating workflows and creating, maintaining, monitoring, and supporting ETL/ELT pipelines.
- Experience with Azure Data Factory and related Azure integration or data services.
- Hands-on experience with Fivetran and DBT preferred.
- Experience with Microsoft Power Automate preferred.
- SQL, relational database, data mapping, transformation, and validation experience.
- Familiarity with CI/CD pipelines, Git-based source control, DevOps practices, and automated testing preferred.
- Exceptional organizational, communication, and interpersonal skills.
- Strong analytical and problem-solving abilities with a proactive, solution-oriented, can-do attitude.
- Ability to manage multiple priorities and find practical solutions to application integration needs within reasonable business timeframes.
- Experience supporting healthcare, pharmacy, revenue-cycle, financial, or other regulated-industry applications preferred.
ESSENTIAL DUTIES AND RESPONSIBILITIES:- Design, develop, deploy, and maintain integrations using APIs, web services, SFTP, scripts, databases, middleware, and data processing systems.
- Build and support REST and SOAP integrations using common formats and standards, including JSON and XML.
- Configure and maintain secure SFTP connections, file-transfer workflows, authentication, scheduling, monitoring, and error handling.
- Develop reusable integration components and technical patterns that support maintainability, scalability, and consistent delivery.
- Troubleshoot complex application and data integration issues, perform root-cause analysis, and implement durable corrective actions.
- Develop Python-based scripts to automate data movement, validation, transformation, reconciliation, reporting, and operational tasks.
- Create and maintain PowerShell and command-line scripts to automate system administration, application support, deployment, and scheduled processes.
- Automate business workflows to reduce manual effort, improve turnaround time, and strengthen process consistency and controls.
- Assess automation opportunities, recommend appropriate solutions, and deliver improvements in partnership with business stakeholders.
- Use Microsoft Power Automate, when appropriate, to support low-code workflow automation and application connectivity.
- Create, maintain, monitor, and optimize ETL and ELT pipelines that move data between source systems, warehouses, analytics platforms, and downstream applications.
- Develop and support pipelines using Azure Data Factory and related Azure services.
- Implement and maintain data integration and transformation solutions using Fivetran and DBT, where applicable.
- Develop and support ERP and CRM integrations, including inbound and outbound interfaces, data synchronization, and pipeline creation.
- Implement data-quality checks, logging, alerting, retry logic, and exception-handling procedures.
- Gather and analyze business, functional, data, security, and technical requirements and translate them into integration designs.
- Prepare system architecture diagrams, data-flow maps, interface specifications, runbooks, test plans, and support documentation.
- Perform unit, integration, system, regression, and performance testing; support user acceptance testing and production deployment.
- Apply source control, code review, release management, and change-control practices throughout the solution lifecycle.
- Monitor production integrations and pipelines, respond to failures, communicate impacts, and coordinate resolution with internal teams and vendors.
- Build integrations that follow organizational security, privacy, access-control, data-retention, and change-management requirements.
- Protect credentials, connection strings, tokens, keys, and sensitive data through approved secrets-management and encryption practices.
- In healthcare environments, support solutions designed to safeguard confidential information and regulated data, including protected health information, in accordance with organizational policies.
- Design solutions for availability, recoverability, auditability, performance, and operational supportability.
- Perform all other essential job functions as assigned by management.
Monday-Friday 8am-5pm
