ETL Developer - $190k -$211k
RCT Systems · Herndon, VA · 3 mo ago
Business Development$190k–$211k/yrFull-time
Key Responsibilities
- 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.
Required Qualifications
- Bachelor's degree in Computer Science, Engineering, Information Systems, or equivalent experience.
- TS/SCI with Polygraph
- 6–8 years of:
- 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.
- 4–6 years of ETL experience with large datasets using tools such as:
- Informatica
- Talend
- SSIS
- AWS Glue
- Azure Data Factory
- Strong SQL and query optimization skills.
- Experience with:
- Data warehousing and data modeling
- Python, Bash, or PowerShell scripting
- Relational and NoSQL databases
- Docker, CI/CD, DevSecOps pipelines
- 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.
RCT Systems offers
- Competitive benefits package (medical, dental, vision, life insurance)
- Immediate 401k vesting
- Generous PTO and flexible schedules
- $500.00 annual technology allowance