Senior Data Engineer (SQL)

Postgres
UNITED STATES
October 25, 2026
Full Time
Apply Now

Job Description

Company: Peregrine Advisors
Location: Washington, DC
Workplace Type: Hybrid
Employment Type: Full-time
Pay / Compensation: $150,000 to $170,000 per year

About the Role

Peregrine Advisors is a rapidly growing AI and data innovation hub helping government solve hard problems and deliver better outcomes. As a Senior Data Engineer (SQL), you will own the data pipelines and databases behind a mission-critical federal enterprise data platform: their design, their performance and reliability, and the integrity of the data in them. This is a hybrid work arrangement based in the Washington, DC metropolitan area, requiring United States citizenship and the ability to obtain a Public Trust determination.

What You’ll Do / Key Responsibilities

  • Database Design & Maintenance: Design and maintain databases that scale, working with Amazon Aurora (PostgreSQL-compatible), Amazon DynamoDB, and other platform data stores.
  • Data Modeling & Schemas: Design logical and physical data models, building the schemas, indexes, views, stored procedures, and functions that implement them.
  • SQL Tuning & Performance: Write and tune complex Structured Query Language (SQL) by reading execution plans and adjusting indexes to handle high-volume query loads.
  • ETL/ELT Pipeline Support: Build and support ETL and ELT pipelines and Amazon S3 loads to keep data accurate, complete, and reliable.
  • Troubleshooting & Reliability: Track down performance, locking, replication, and data consistency problems, ensuring database availability through monitoring, capacity planning, backup and recovery, and high availability.
  • Security & Compliance: Secure data systems with least-privilege access, encryption, auditing, and compliance controls.
  • CI/CD & Infrastructure Integration: Work with architects, developers, and data engineers to move database changes through continuous integration/continuous delivery (CI/CD) and infrastructure as code.

Requirements & Qualifications

  • 7+ years of hands-on data engineering, database development, database engineering, software development, or comparable practical experience in support of enterprise applications.
  • Bachelor’s degree in a relevant field.
  • Expertise in Amazon Aurora (PostgreSQL-compatible), covering schema design, stored procedures and functions, indexing, and execution-plan analysis.
  • Experience with Amazon DynamoDB, covering data modeling, partition and key design, and Global and Local Secondary Indexes (GSIs and LSIs).
  • Advanced SQL skills across complex queries, views, stored procedures, and functions, together with relational design, normalization, and data modeling.
  • Performance and query tuning resolving slow queries, locking, and deadlocks through indexing and execution-plan work.
  • ETL and ELT development and data integration across AWS data services, such as Amazon Relational Database Service (RDS), S3, and data migration services.
  • Data security controls including encryption, access management, auditing, and compliance.
  • Cloud-native application support in AWS through CI/CD and DevSecOps practices, including monitoring, backup and recovery, high availability, and disaster recovery.
  • Proficiency in writing, PowerPoint, and Excel.

Preferred / Bonus Qualifications (if applicable)

  • AWS certification at the level of Database Specialty, Developer Associate, or Solutions Architect.
  • Federal information technology experience with systems requiring security controls and compliance frameworks.
  • Experience with high-volume transaction processing, large-scale data platforms, or regulatory reporting.
  • Database observability and monitoring experience using Amazon CloudWatch, Performance Insights, Datadog, or Splunk.
  • Experience with Amazon Redshift, AWS Glue, AWS Database Migration Service (DMS), or AWS Lake Formation.
  • Experience with infrastructure as code, including Terraform, CloudFormation, and the AWS Cloud Development Kit (CDK).
  • Experience with artificial intelligence (AI)-assisted development tooling.

Benefits & Perks (if applicable)

  • Medical, dental, and vision insurance with employee premiums fully paid and half of dependent premiums covered.
  • Employer-paid life, accidental death, and short-term and long-term disability insurance.
  • 401(k) matched 100% up to 4% of salary, vesting immediately.
  • Unlimited paid time off (PTO).
  • Sponsored professional certifications (such as DCAM and AWS technical certifications) and continuing education.

Peregrine Advisors is an equal opportunity employer.

Related Jobs