Job Description
Job Title: Junior Data Engineer
Location: Washington, DC (Remote work possible with approval)
Clearance/Compliance: FISMA Compliance Support Required
Job Summary:
We are looking for a motivated Junior Data Engineer to support the design, development, and management of database and data integration solutions in a cloud environment. The ideal candidate will have hands-on experience with SQL development, PostgreSQL, SQL Server, and AWS services, and will work closely with database administrators, developers, and business users to support data-driven solutions and ensure secure, efficient, and scalable data infrastructure.
Key Responsibilities:
Database Design and Development:-
- Assist with database schema design and data modeling
- Develop stored procedures, functions, triggers, and other database objects
- Build data integration solutions, including ETL processes and data pipelines
- Implement automation tools and CI/CD processes for database and pipeline deployments
- Create and optimize database APIs and data access layers
- Maintain accurate technical documentation for all database solutions
Performance and Optimization:-
- Monitor data integration performance and support improvements
- Assist the DBA with query optimization and performance tuning
- Implement indexing strategies and partitioning under supervision
- Contribute to performance testing and analysis efforts
- Help develop dashboards and reporting solutions for monitoring
Data Management:-
- Support database migration and upgrade efforts
- Assist with data quality validation and testing
- Help implement data archiving and retention policies
- Participate in backup and recovery testing
- Contribute to data cataloging and metadata documentation
- Support testing and validation for database features and changes
- Assist in data-related documentation and knowledge sharing activities
Security and Compliance Support:-
- Implement database security controls based on defined policies
- Assist in FISMA compliance documentation and audit preparations
- Support data masking and encryption practices
- Help maintain security monitoring processes and documentation
Platform and Collaboration:-
- Work with cloud databases such as Redshift, SQL Server, and PostgreSQL (RDS/EC2)
- Support automation and CI/CD pipelines for database and ETL
- Collaborate with development teams to enforce database best practices
- Participate in technical reviews, peer learning, and development sessions
- Assist business users with data requirements and solutions
Qualifications:
- 1 3 years of experience in SQL development and database fundamentals
- Hands-on experience with PostgreSQL and SQL Server (required)
- Basic understanding of database design, normalization, and data modeling
- Experience with writing stored procedures, functions, and triggers
- Familiarity with performance tuning, indexing, and query optimization
- Experience building ETL processes or data pipelines using SQL, Python, or ETL tools (e.g., AWS Glue, Lambda, Step Functions)
- Understanding of data integration patterns and data transformation techniques
- Exposure to AWS cloud services - particularly RDS, EC2, Redshift, Glue, and related tools
- Preferred experience with Amazon Redshift for data warehousing
- Basic knowledge of Infrastructure as Code and CI/CD workflows
- Familiarity with data cataloging tools and data governance processes
- Strong collaboration and communication skills to support both technical teams and business stakeholders
Job Tags
Remote work,