Mid-Level Full-Stack Software Engineer (Data & Migrations) in Remote at Redhorse
Explore Related Opportunities
Job Description
About the Role
Redhorse transforms the way government uses data and technology. We are seeking "Everything Engineers" with a Data Focus to lead the modernization of a mission-critical legacy system managing billions of dollars in international security cooperation.
This role is for the "Agent-native" engineer. On this team, AI-led development isn't a novelty—it’s how we build. You will work through agentic toolkits (Claude Code, Codex, etc.) every day to replace a decades-old Oracle-based platform with a modern, high-integrity PostgreSQL ecosystem. You will own the ground the modernization stands on, ensuring that years of complex production data are migrated with financial-grade proof while building across the full stack (UI, API, and Infrastructure).
- 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.
- 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).