This is a contract role with an immediate start date. The contract duration is 9 months and may be extended.
Position Title: Senior Data Migration and Integration Developer
Location: Remote
Employment Type: Full-Time
Reports To: Technical Project Manager / Data Solutions Lead
About PS2G:
At Public Sector Solutions Group (PS2G), we deliver innovative, mission-driven solutions to our government and public sector clients. We specialize in modernizing legacy systems, improving data management, and enabling organizations to make impactful, data-informed decisions. Were seeking a highly skilled Senior Data Migration and Integration Developer to join our team and lead end-to-end data transformation initiatives as part of a large-scale system modernization effort.
Position Overview:
The Senior Data Migration and Integration Developer will serve as a technical lead responsible for designing and executing secure, efficient, and accurate data migration and system integration strategies. This individual will play a critical role in modernizing legacy environments by enabling data interoperability across platforms and ensuring compliance with health data governance policies.
Key Responsibilities:
- Legacy System Data Migration:
Lead the design, development, and execution of Extract, Transform, Load (ETL) strategies to migrate data from complex legacy systems to modern platforms, ensuring data integrity, accuracy, and completeness.
- Data Mapping & Transformation:
Analyze legacy data structures and schemas; define and implement transformation rules and mappings to align data with updated business logic and the target systems architecture.
- System Integration Development:
Develop and maintain scalable, secure APIs, web services, and middleware components to enable real-time and batch data exchange with external systems such as Medicaid, provider databases, and federal/state registries.
- Data Quality Assurance:
Conduct thorough data validation, cleansing, deduplication, and reconciliation activities to ensure high-quality datasets throughout the migration lifecycle.
- ETL Development & Optimization:
Build and fine-tune performant ETL pipelines capable of handling large, complex datasets with minimal disruption during migration cutovers.
- Security, Privacy & Compliance:
Implement and maintain data migration and integration solutions in compliance with HIPAA, CMS regulations, and Wyoming-specific healthcare data privacy policies.
- Testing & Validation:
Collaborate with QA teams, business analysts, and stakeholders to validate migration outcomes, support User Acceptance Testing (UAT), and resolve any data-related anomalies.
- Cutover & Transition Planning:
Support go-live readiness activities including mock runs, rollback procedures, cutover strategy, and final synchronization processes to ensure a seamless transition.
- Documentation & Knowledge Transfer:
Create and maintain comprehensive documentation including technical specifications, data mapping sheets, ETL design, and operational procedures. Facilitate knowledge transfer to client teams and internal support staff.
Preferred Qualifications:
- Bachelors degree in computer science, Information Systems, Data Engineering, or a related field
- 7+ years of experience in data migration and integration within public sector or healthcare environments
- Expertise in ETL tools (e.g., Informatica, Talend, SSIS) and database technologies (e.g., Oracle, SQL Server, PostgreSQL)
- Strong knowledge of data governance, privacy laws, and compliance frameworks (HIPAA, CMS, etc.)
- Proficiency in developing RESTful APIs, XML/JSON data handling, and secure data transmission protocols
- Experience with Agile methodologies and DevOps practices
- Excellent analytical, documentation, and communication skills
Join Us:
If youre passionate about delivering impact through clean, secure, and reliable data and want to contribute to public sector innovation, we invite you to be a part of PS2Gs data modernization team.