Data Integration Engineer

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