ETL Developer

RCT is seeking a senior ETL Engineer / Applications Developer to 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.

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
• Git version control

Preferred Qualifications

• 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).
• Docker, CI/CD, DevSecOps pipelines.
• 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

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.