Data Engineer (SQL)

Job overview

The Data Engineer (SQL) role follows a hybrid work arrangement in the Washington, DC metropolitan area. The stated salary is $120,000–$140,000 per year. Peregrine Advisors supports government clients with AI and data innovation. The engineer designs and builds database components for a federal enterprise platform, helping ensure data is accurate, secure, performant, and dependable for analysts and systems. The work spans database design, data pipelines, integrations, and maintenance within an established platform architecture.

What you'll do

• Design database schemas and write SQL queries, views, stored procedures, and functions. Build and maintain ETL and ELT processes, including loads from Amazon S3. Tune queries and databases for high-volume workloads
• model data across Amazon Aurora, DynamoDB, and S3
• and work within security controls for governed access and auditable changes. Coordinate data access patterns and integrations with developers, architects, and data engineers. AI-assisted tools may be used where the work allows, with outputs reviewed and validated.

What we're looking for

Skills & competencies

data engineer

sql

database engineering

etl

elt

amazon aurora

dynamodb

aws

hybrid

washington dc metro

$120k–$140k/year

federal technology

peregrine advisors

Work arrangement

• Weekend coverage required

Benefits & perks

• Medical, dental, and vision insurance with employee premiums fully paid and half of dependent premiums
• employer-paid life, accidental death, and short- and long-term disability insurance
• 401(k) match up to 4%, immediately vested
• unlimited paid time off
• sponsored certifications and continuing education.

Why this role

Hybrid federal-platform work; initial engagement requires U.S. citizenship and ability to obtain a Public Trust determination. Benefits include fully paid employee medical, dental, and vision premiums, matched 401(k), unlimited paid time off, and sponsored certifications and continuing education.

About the employer

OpenDataJobs is hiring for this role. Industry: Computer Systems Design Services. Sector: 54.