Junior Data Engineer

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