Mid-Level Everything Engineer (Data & Migrations)

Redhorse Corporation is a solution-driven company delivering data insights and technology solutions critical to U.S. national interests. They are seeking a Mid-Level Everything Engineer with a focus on data to lead the modernization of a mission-critical legacy system managing billions of dollars in international security cooperation.

Responsibilities:

• You’ll decompose problems into specs precise enough that an agent can implement them directly and concretely, and you’ll own everything you merge, because agent output is your output
• You’ll review rigorously. The bar is production software for a regulated federal financial system: test-driven development, human review on every merge, and a rigorous CI scans
• You’ll ship constantly. Small reviewable changes, an always-green main branch, an always-on beta environment stakeholders can touch
• You get to play with all the latest cool tech as part of your job
• You’ll own the ground the whole modernization stands on
• The migration pipeline as a product. Repeatable extract, transform, load, and validate machinery that consolidates three mirrored Oracle schemas into one modern PostgreSQL schema (service discriminator plus row-level security replacing physical schema isolation), slice by slice, with per-slice mapping specs reviewed like code
• Proof, not vibes. Row counts, checksums, financial control totals reconciled per country and case, and golden-master behavioral checks (does the migrated case still price identically?). Your reconciliation reports are literally the government’s acceptance evidence
• Legacy archaeology. Reading PL/SQL packages, triggers, and view definitions to determine which of them hide business rules that must survive, and turning what you find into an evidence-cited knowledge base other engineers build from
• The modern data platform. Transactional PostgreSQL schema design (Prisma), CDC into a dedicated analytics store, dimensional models replacing a 300-plus report Cognos estate, and outbound analytical feeds to enterprise data platforms

Requirements:

• US citizenship and eligibility for a US SECRET clearance
• 3+ years of work experience with upward trajectory
• Strong track record with production relational data systems (schema design, migration, performance) plus real web-stack breadth
• Ability to read and reason about PL/SQL (you don't need to love it, you need to interrogate it)
• Hands-on experience with agentic AI development tools (Codex and/or Claude Code, or equivalent) on real codebases
• Travel no more than once per quarter
• Heterogeneous migration experience, ideally Oracle to Postgres, with validation and reconciliation rigor
• Data modeling for analytics
• Data-quality tooling
• Prior work in a regulated or government environment
• Financial data and audit exposure
• Synthetic data generation
• Cognos experience