Genesis10 is currently seeking a Data Integration Engineer for a remote position with a leading pharmacy benefit manager. This role is responsible for driving seamless data flow between internal platforms, external vendors, and client partners, leading end-to-end integration processes and ensuring data quality and compliance.
Responsibilities:
- Lead system and data integration efforts for our client's clinical vendor hub, ensuring reliable, secure, and accurate data exchange across internal platforms, external vendors, and client partners
- Manage the full integration lifecycle, including intake, scoping, requirements gathering, technical design, STT (source to target) mapping, configuration, testing, deployment, and transition to operations
- Develop and maintain detailed technical documentation, such as data dictionaries, mapping specifications, interface requirements, workflows, and system configuration artifacts
- Coordinate SFTP setup, file delivery workflows, and automation to support inbound and outbound data exchanges across multiple environments
- Ensure environment and data readiness across dev, test, QA, UAT, and production environments; work closely with internal teams to provision data, validate connectivity, and resolve environment-related issues
- Perform data profiling and analysis to validate data quality, identify anomalies, and support integration, troubleshooting, and continuous improvement
- Support internal data pipelines and data platforms, partnering with engineering and architecture teams to ensure scalability, performance, and data governance compliance
Requirements:
- Advanced SQL skills, including: Design and optimize complex queries involving CTEs, window functions, aggregations, and multi-table joins
- Develop reusable database objects such as views, functions, and stored procedures
- Implement parameterized and dynamic SQL safely and efficiently
- Ability to manage work direction and lead, influence, mentor, and provide feedback to others within the team
- Jira for feature, story, & backlog management
- GitHub for CICD pipeline management
- GCP-BQ or equivalent cloud data platform experience
- SFTP coordination & management of file transfers (internally & externally)
- Test Management (strategy, scenarios, TDM, integration, acceptance)
- Pharmacy Claims/PBM experience (claims & member data, operations & claims adjudication)
- Experience with managing vendors & client data integrations
- Ability to solve complex problems and promote & enable process improvements
- Experience working in an environment with regulatory compliance requirements (HIPAA, PCI, etc.)
- Previous experience in the PBM / health care industry