Senior Data Engineer (SQL)

Postgres
UNITED STATES
October 25, 2026
Full Time
Apply Now

Job Description

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

About the Role

Peregrine Advisors is seeking a Senior Data Engineer (SQL) to own the data pipelines and databases behind a mission-critical federal enterprise data platform. You will own their design, performance and reliability, and the integrity of the data within 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 and Architecture: Design and maintain databases that scale in Amazon Aurora (PostgreSQL-compatible), Amazon DynamoDB, and other platform data stores.
  • Data Modeling and Schemas: Design logical and physical data models, building the schemas, indexes, views, stored procedures, and functions that implement them.
  • Query Performance and Tuning: Write and tune complex Structured Query Language (SQL), reading execution plans and adjusting indexes to support high-volume query loads.
  • ETL/ELT Pipeline Support: Build and support extract, transform, and load (ETL) and extract, load, and transform (ELT) pipelines and Amazon Simple Storage Service (S3) loads for accurate data.
  • Troubleshooting and Maintenance: Track down performance, locking, replication, and data consistency problems while keeping databases available through monitoring, capacity planning, backup and recovery, high availability, and disaster recovery.
  • Security and Compliance: Secure databases with least-privilege access, encryption, auditing, and compliance controls.
  • CI/CD and Collaboration: Work with architects, developers, and data engineers to move database changes through continuous integration and 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 of study.
  • 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/key design, and Global/Local Secondary Indexes (GSIs and LSIs).
  • Advanced SQL skills across complex queries, views, stored procedures, functions, relational design, normalization, and data modeling.
  • Proven capability in performance and query tuning that resolves slow queries, locking, and deadlocks through indexing and execution-plan work.
  • ETL and ELT development experience across AWS data services such as Amazon Relational Database Service (RDS), S3, and data migration services.
  • Familiarity with data security controls such as encryption, access management, auditing, and compliance.
  • Support experience for cloud-native applications in AWS through CI/CD and DevSecOps practices, including monitoring, backup/recovery, high availability, and disaster recovery.
  • Proficiency in writing, PowerPoint, and Excel.

Preferred / Bonus Qualifications (if applicable)

  • An 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.
  • Experience with database observability and monitoring tools such as 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/long-term disability insurance.
  • 401(k) matched 100% up to 4% of salary, vesting immediately.
  • Unlimited paid time off (PTO).
  • Sponsored professional certifications and continuing education (e.g., DCAM and AWS technical certifications).

Peregrine Advisors is an equal opportunity employer.

Related Jobs