US Citizen or GC only that represents yourself
Seeking a hands-on Developer Sr to support the Claimscore modernization project. This contractor will maintain legacy claims data integrations while building new Claimscore feeds that run in parallel. The role will transform, reconcile, and consolidate data from both platforms into existing enterprise data models, preserving continuity for downstream applications and reporting. Work will follow established architecture and guidance from technical leads.
Key Responsibilities
- Maintain and troubleshoot legacy ETL jobs, batch processes, files, and data interfaces.
- Develop, test, and deploy new Claimscore data feeds using SQL, ETL tools, Python, APIs, and file-based integration methods.
- Support parallel operation of legacy and Claimscore feeds without disrupting downstream systems.
- Map and transform claims, provider, beneficiary, and related data into existing enterprise models.
- Implement reconciliation, duplicate detection, data quality checks, logging, error handling, and monitoring.
- Analyze source files, schemas, and existing transformation logic to address mapping gaps and data discrepancies.
- Build or maintain REST API integrations, including authentication, JSON/XML processing, pagination, and retries.
- Write SQL queries, stored procedures, and scripts to automate data extraction and transformation.
- Perform unit and integration testing, validate source-to-target results, and resolve defects.
- Document mappings, technical designs, job dependencies, and support procedures; assist with deployment and production support.
- Collaborate with Developer Advisors, architects, business teams, and vendors to deliver assigned integrations.
Required Qualifications
- 3–5+ years of hands-on ETL, data engineering, or enterprise integration experience.
- Strong SQL skills, including joins, stored procedures, transformations, and performance troubleshooting.
- Experience with Python or a comparable scripting/programming language.
- Experience consuming REST APIs and working with JSON/XML, relational databases, and flat files.
- Experience with Informatica, SSIS, DataStage, Talend, or similar ETL technology.
- Experience maintaining production batch/data pipelines, testing data quality, and reconciling multiple sources.
- Understanding of data warehousing, source-to-target mappings, and relational data models.
- Ability to complete assigned development work independently within established designs and standards.
Preferred Qualifications
- Healthcare or Medicare claims data experience.
Exposure to mainframe/legacy modernization and parallel-system transitions.
Familiarity with enterprise job scheduling, SFTP, Git, CI/CD, and cloud data platforms.
Expected Outcome
- Keep legacy integrations stable while delivering accurate, supportable Claimscore feeds and consolidated data in existing enterprise models, with minimal impact to downstream consumers.
Standard business hours and for those working within EST/CST time zones Monday through Friday. Typically 7am-6pm time range to ensure good working relationships and coordination of deliverables within a team setting