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 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
Skills
- 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
Company Overview