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

Similar Jobs