What are the responsibilities and job description for the Business Process Integration position at Apexon?
Role Overview
We are seeking a skilled Logistics Business Process Integrator to develop, maintain, and validate data integration workflows supporting logistics business processes. The ideal candidate will have hands-on experience with Apache NiFi, SQL, Oracle, MongoDB, and PostgreSQL, along with strong expertise in data migration, validation, and data lineage. Experience supporting Department of Defense (DoD) medical logistics or supply chain operations is preferred.
Required Skills
- Experience designing, developing, troubleshooting, deploying, and maintaining Apache NiFi ETL workflows.
- Experience integrating Oracle SQL, MongoDB, and PostgreSQL databases.
- Strong SQL development skills, including stored procedures, complex queries, data transformations, and transaction management.
- Experience with error handling, input validation, and SQL performance tuning across relational database platforms.
- Proficiency in scalar, grouping, and analytical SQL functions, as well as correlated subqueries.
- Ability to identify and process automatic data migration validation business rules.
- Experience documenting and researching data lineage, data authority, and data usage across value streams.
- Experience validating data before and after migrations to verify 100% data accuracy.
Preferred Skills
- Department of Defense (DoD) medical logistics or equivalent supply chain experience.
- Familiarity with LogiCole or comparable medical logistics applications.
- Agile or SAFe delivery experience in a federal environment.
Key Responsibilities
- Design, develop, troubleshoot, deploy, and maintain Apache NiFi ETL workflows integrating Oracle SQL, MongoDB, and PostgreSQL databases.
- Develop, optimize, and maintain SQL stored procedures and complex queries to support data processing and integration requirements.
- Implement data transformations, transaction management, error handling, and input validation.
- Perform SQL performance tuning across relational database platforms.
- Develop and execute SQL queries using scalar, grouping, and analytical functions, including correlated subqueries.
- Identify, document, and process automated data migration validation rules.
- Research and document data lineage, data authority, and data usage across business value streams.
- Perform pre-migration and post-migration data validation to verify data accuracy and completeness.
- Investigate and resolve data discrepancies and integration issues.
- Collaborate with business, technical, and logistics stakeholders to support reliable data migration and integration processes.
Education Requirement
Bachelor’s degree in Computer Science, Information Technology, Engineering, Business Administration, or a related field is preferred.