Note: The job is a remote job and is open to candidates in USA. Redhorse Corporation is a solution-driven company delivering data insights and technology solutions to customers with missions critical to U.S. national interests. They are seeking a Mid-Level Full-Stack Software Engineer to lead the modernization of a mission-critical legacy system, focusing on data migration and ensuring the integrity of complex production data through innovative engineering practices.
Responsibilities
- Decompose complex data and business problems into specifications precise enough for AI agents to implement directly and concretely
- Design and maintain a repeatable migration pipeline that consolidates legacy mirrored Oracle schemas into a modern, single-schema PostgreSQL environment
- Implement rigorous automated reconciliation machinery (checksums, financial control totals, and row counts) to provide government acceptance evidence
- Conduct "legacy archaeology" by interrogating hundreds of thousands of lines of PL/SQL packages and triggers to extract and document load-bearing business rules
- Develop transactional schemas using Prisma and design Change Data Capture (CDC) workflows into dedicated analytics stores
- Build complete vertical slices of capability, including React-based admin UIs for data quality reports and Node.js API endpoints
- Set the technical bar for data integrity, utilizing golden-master behavioral checks to prove migrated cases still price and process identically to legacy systems
- Maintain a rigorous human-review process for all agent-generated code to ensure compliance with federal financial standards
Skills
- Must be a U.S. Citizen and eligible for a U.S. SECRET clearance
- 3+ years of experience building and operating production data systems
- Hands-on experience with agentic AI development tools (Claude Code, Codex, or equivalent) on real-world codebases
- Strong track record with relational data systems, including schema design, migration, and performance tuning
- Ability to read and reason about PL/SQL and legacy database logic
- Professional fluency in the modern web stack: TypeScript, Node.js, and React
- Demonstrated experience with cloud infrastructure (AWS) and CI/CD fundamentals
- Experience with heterogeneous migrations, specifically moving from Oracle to PostgreSQL
- Familiarity with data modeling for analytics and replacing legacy reporting estates like Cognos
- Background in financial data systems or environments subject to strict federal audit standards
- Experience with AWS GovCloud, CDK, and containerized deployments (EKS/ECS)
- Experience with data-quality tooling and synthetic data generation
- Prior work in a regulated government environment (FedRAMP, RMF, or IL-specific programs)
Benefits
- Eligible employees may participate in Redhorse's comprehensive benefits programs
- May be eligible for performance-based or other incentive compensation, where applicable
- You can request reasonable accommodations by contacting Talent Acquisition at [email protected]
Company Overview