Senior Full-Stack Software Engineer (Data & Migrations)

About the Organization

Now is a great time to join Redhorse Corporation. We are a solution-driven company delivering data insights and technology solutions to customers with missions critical to U.S. national interests. We’re looking for thoughtful, skilled professionals who thrive as trusted partners building technology-agnostic solutions and want to apply their talents supporting customers with difficult and important mission sets.

Key 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.

Required Experience/Clearance

• Must be a U.S. Citizen and eligible for a U.S. SECRET clearance.
• 7+ 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.

Desired Experience

We encourage all candidates who meet the basic requirements to apply, even if you do not have any of the following experience:

• 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).