ETL Developer

RCT is seeking a senior ETL Engineer / Applications Developer

Design, build, and optimize large-scale data pipelines and cloud-based analytics solutions supporting mission‑critical environments. The role combines data engineering, cloud architecture, search/discovery systems, and technical leadership within an Agile development environment.

• Design, develop, and maintain scalable ETL/ELT pipelines for structured and unstructured datasets (GB–TB scale).
• Build data ingestion and integration solutions across enterprise systems.
• Develop and optimize search and discovery platforms
  .
• Ensure data quality, validation, performance, and reliability.
• Build secure, cloud‑native solutions in AWS/C2S environments.
• Translate mission requirements into technical architectures and implementation roadmaps.
• Deliver dashboards, visualizations, and executive‑level briefings.
• Lead development efforts through code reviews, mentoring, deployment, accreditation, and sustainment.
• Support data governance, security, and classified environment compliance.

• Bachelor's degree in Computer Science, Engineering, Information Systems, or equivalent experience.
• TS/SCI with Polygraph

• Linux administration and large‑scale data processing.
• Object‑oriented programming (
  Python preferred
  ).
• AWS or C2S cloud environments (other cloud platforms considered with sufficient experience).
• AWS services including EC2
  .

• Informatica
• Talend
• SSIS
• AWS Glue
• Strong SQL and query optimization skills.
• Experience with:
• Data warehousing and data modeling
• Python, Bash, or Power Shell scripting
• Relational and No
  
  SQL databases

• Big data technologies (
  Spark, Hadoop, Databricks
  ).
• NLP and transformer models (e.g.,
  BERT
  ).
• Search technologies (
  Elasticsearch, Solr, Lucene
  ).
• Document exploitation, e‑discovery, and multi‑modal analytics (OCR/image recognition).
• Cloudera or similar big data certifications.
• Experience with anomaly detection, predictive analytics, or risk scoring.

• Immediate 401k vesting
• Generous PTO and flexible schedules
• $500.00 annual technology allowance

RCT Systems is committed and proud to be an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regards to race, color, religion, sex (to include pregnancy and related conditions, sexual orientation and gender identity), national origin, disability, veteran status, or any other federally protected class.