Data Engineer

Redhorsecorp; Winchester (VA); On-site; USD 120,000 - 180,000; Full time

Job summary

Redhorse Corporation seeks a Data Engineer to migrate legacy datasets (>10TB) from Oracle and SCOP to AWS S3 and Amazon EKS, building visual analytic applications for bulk analysis. You will manage SQL Server and Oracle data, participate in Tier 1-3 support, and help modernize data architecture for faster, secure mission-critical delivery.

The role requires an active Top Secret clearance with SCI eligibility and 5+ years in data engineering, with experience across cloud and HPC environments.

Qualifications

• Must have active U.S. Government Top Secret clearance with SCI eligibility.
• 5+ years of professional experience in data engineering or a related field.
• Proven experience migrating large-scale datasets (Terabyte-scale) across enclaves, platforms, or cloud environments.
• Experience developing data analytics for visual analytic software (desktop and web-based).
• High proficiency in database management using SQL Server and Oracle.
• Experience with cloud-native storage and orchestration tools, specifically AWS S3 and Amazon EKS.
• Experience with HPC environments and large-scale data processing.
• Familiarity with open-source visualization tools and libraries.
• Knowledge of FBI, NARA data guidelines and compliance standards.
• Experience in a tiered support environment providing technical troubleshooting for data-heavy applications.
• Advanced certifications in AWS or database administration.

Responsibilities

• Lead the migration of legacy datasets exceeding 10TB from Oracle and SCOP environments into AWS S3 and Amazon EKS.
• Design and deliver advanced visual analytic applications that enable stakeholders to perform complex bulk analysis of relational information.
• Develop data analytics for both desktop and web-based visual analytic software to support diverse user needs.
• Manage and optimize relational data within SQL Server and Oracle database management systems.
• Rotate periodically into the Help Desk (Tiers 1-3) to provide high-level technical troubleshooting and data support for end-users.
• Facilitate the modernization of data architecture to improve the speed and accuracy of mission-critical information delivery.

Skills

Data engineering

Large-scale data migration

SQL Server & Oracle

AWS S3 & Amazon EKS

Visualization tools

HPC environments

Tiered support

Top Secret clearance

Open-source visualization libraries

AWS or DB certifications

Tools

SQL Server

Oracle

AWS S3

Amazon EKS

Job description

About the Role

Redhorse transforms the way government uses data and technology. To support this mission, we are seeking a Data Engineer to play a critical role in the FBI’s "Pinnacle" modernization effort. This high-impact initiative involves the large-scale migration of over 10TB of legacy data from Oracle and SCOP systems into modern cloud environments, including AWS S3 and Amazon EKS. In this role, you will be the bridge between legacy information and future-ready intelligence, developing advanced visual analytic applications and ensuring that bulk relational data is accessible, secure, and ready for analysis.

Responsibilities

• Lead the migration of legacy datasets exceeding 10TB from Oracle and SCOP environments into AWS S3 and Amazon EKS.
• Design and deliver advanced visual analytic applications that enable stakeholders to perform complex bulk analysis of relational information.
• Develop data analytics for both desktop and web-based visual analytic software to support diverse user needs.
• Manage and optimize relational data within SQL Server and Oracle database management systems.
• Rotate periodically into the Help Desk (Tiers 1-3) to provide high-level technical troubleshooting and data support for end-users.
• Facilitate the modernization of data architecture to improve the speed and accuracy of mission‑critical information delivery.

Qualifications

• Active U.S. Government Top Secret security clearance with SCI eligibility.
• 5+ years of professional experience in data engineering or a related field.
• Proven experience migrating large-scale datasets (Terabyte‑scale) across different enclaves, platforms, or cloud environments.
• Demonstrated experience developing data analytics for visual analytic software (desktop and web-based).
• High proficiency in database management using SQL Server and Oracle.
• Experience working with cloud-native storage and orchestration tools, specifically AWS S3 and Amazon EKS.
• Experience with high-performance computing (HPC) environments and large-scale data processing.
• Familiarity with open-source visualization tools and libraries.
• Knowledge of FBI, National Archives, and Records Administration (NARA) data guidelines and compliance standards.
• Experience in a tiered support environment providing technical troubleshooting for data-heavy applications.
• Advanced certifications in AWS or database administration.

Accommodations

If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to access job openings or apply for a job on this site as a result of your disability. You can request reasonable accommodations by contacting Talent Acquisition at [e-mail]

Redhorse Corporation is an equal opportunity employer. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, disability, or any other protected class.