Junior Data Engineer - AWS SQL & ETL (Hybrid, DC)

Peregrine Advisors; Washington; Hybrid; USD 80,000 - 95,000; Full time

Job summary

Peregrine Advisors is seeking a junior to mid-level database developer to build and maintain SQL queries, stored procedures, and views for a federal data platform. You will work with DynamoDB and S3, contribute to data models, and ensure secure, auditable data flows.

The role offers a hybrid work arrangement based in the Washington, DC area, with initial on-site presence required. 1+ year experience and a Bachelor's degree are expected.

Qualifications

• 1+ years of database development or equivalent experience.
• Bachelor's degree required.
• Working knowledge of SQL, stored procedures, and views on Aurora (PostgreSQL-compatible).
• Familiarity with DynamoDB and S3.
• Query tuning with guidance from a senior developer.
• Exposure to ETL/ELT patterns and AWS data services.
• Awareness of data security controls (encryption, access management, auditing).
• Introductory familiarity with logical data modeling and contributing to database-design decisions.
• Proficiency in PowerPoint and Excel.

Responsibilities

• Build and maintain SQL queries, stored procedures, and views.
• Work with data from DynamoDB and S3.
• Contribute to data models and platform architecture reviews.
• Build reliable data loads from S3 and tune queries.

Skills

SQL

Stored procedures

Views

Database development

Query tuning

Data security concepts

ETL/ELT patterns

ODBC/JDBC

Logical data modeling

Communication

Education

Bachelor's degree

Tools

Amazon Aurora (PostgreSQL-compatible)

Amazon DynamoDB

Amazon S3

PowerPoint

Excel

ODBC

JDBC

Job description

Peregrine Advisors is seeking a junior to mid-level database developer to build and maintain SQL queries, stored procedures, and views for a federal data platform. You will work with DynamoDB and S3, contribute to data models, and ensure secure, auditable data flows.

The role offers a hybrid work arrangement based in the Washington, DC area, with initial on-site presence required. 1+ year experience and a Bachelor's degree are expected.