Key skills
Amazon RedshiftApacheAWSCloudETLJenkinsKafkaOraclePostgresPythonSparkSQLTableauELTData EngineeringData WarehousingData LakeAnalyticsRedshiftDatabricksApache SparkLambdaS3RDSGluePostgreSQLGitAgileCI/CDCollaboration
About this role
Role Overview
- Design, develop, and maintain scalable data pipelines and ETL/ELT processes
- Build and optimize data solutions within cloud environments using AWS services and Databricks
- Ingest, transform, and integrate structured and unstructured data from multiple sources
- Develop and maintain data models, data marts, and database structures to support analytics and reporting
- Ensure data quality, integrity, and availability through validation, cleansing, and monitoring processes
- Collaborate with architects, analysts, and developers to translate business requirements into technical solutions
- Support CI/CD processes and automated deployments in collaboration with DevSecOps teams
- Participate in Agile development processes, including sprint planning, backlog grooming, and daily stand-ups
- Troubleshoot data issues, perform root cause analysis, and implement solutions in development and production environments
- Create and maintain technical documentation for data pipelines, transformations, and workflows
Requirements
- U.S. Citizenship required due to federal contract requirements
- Ability to obtain and maintain a Public Trust
- Candidate must reside in the U.S. and be able to support onsite work in the Reston, VA area as needed
- Candidate must have lived in the U.S. for three (3) full years out of the last five (5) years
- 3–5 years of experience in data engineering, data integration, or related technical roles
- 3+ years of strong proficiency in Python and SQL for data processing and transformation
- Bachelor’s degree in computer science, Engineering, or a related field (preferred)
- 2+ years of hands-on experience with AWS data services (e.g., S3, Glue, Lambda, Redshift, RDS or similar)
- 2+ years of experience working with Databricks and Apache Spark or similar distributed data processing platforms
- 3+ years of experience with ETL/ELT frameworks, data pipeline development, and data ingestion patterns
- 3+ years of experience working with relational databases such as Oracle or PostgreSQL
- Familiarity with data integration techniques using APIs, JSON, or streaming tools such as Kafka
- Understanding of data modeling concepts and data warehousing principles
- Familiarity with CI/CD tools (e.g., Git, Jenkins or similar)
- Experience working in Agile development environments
- Experience with cloud-based data lake or Lakehouse architecture
- Familiarity with data visualization or reporting tools (e.g., Tableau or similar)
- Exposure to DevSecOps practices, including infrastructure as code and automated deployments
- Experience supporting secure and compliant data environments
- AWS Certifications (e.g. AWS or Databricks certifications)
Tech Stack
- Amazon Redshift
- Apache
- AWS
- Cloud
- ETL
- Jenkins
- Kafka
- Oracle
- Postgres
- Python
- Spark
- SQL
- Tableau
Benefits
- Health insurance
- Retirement plans
- Paid time off
- Flexible work arrangements
- Professional development opportunities