Junior Data Engineer - AWS SQL & Cloud Data

re-zoo-me; Washington, Northern (District of Columbia, KY); Hybrid; USD 80,000 - 95,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision coverage

401(k) match

Job summary

Peregrine Advisors is seeking a junior to mid-level database developer to join our Washington, DC team. You will build and maintain SQL queries, stored procedures, and views in Amazon Aurora PostgreSQL, work with DynamoDB and S3, and contribute to data models within an established federal-facing platform.

You will grow toward physical design responsibilities while collaborating with a senior developer on varied assignments. This is a full-time W-2 role with a hybrid schedule in the DC metro area.

Qualifications

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

Responsibilities

• Build and maintain SQL queries, stored procedures, and views in Aurora PostgreSQL.
• Work with data from DynamoDB and S3.
• Contribute to data models and platform architecture decisions.
• Plan and execute reliable data loads from S3 and tune queries with guidance.
• Move toward responsibility for physical design over time.

Skills

SQL & stored procedures

Views on Aurora PostgreSQL

Data modeling

Query tuning

AWS data services

Education

Bachelor's degree

Tools

Amazon Aurora

DynamoDB

S3

Open Database Connectivity (ODBC)

Job description

Peregrine Advisors is seeking a junior to mid-level database developer to join our Washington, DC team. You will build and maintain SQL queries, stored procedures, and views in Amazon Aurora PostgreSQL, work with DynamoDB and S3, and contribute to data models within an established federal-facing platform.

You will grow toward physical design responsibilities while collaborating with a senior developer on varied assignments. This is a full-time W-2 role with a hybrid schedule in the DC metro area.