← Back to jobsJob ID col-cmv8ehopb058ioz017an7wv78

OPENDataJobsPosted 30+ days ago

Data Engineer (SQL)

Full-time
Hybrid
4+ years
$120K – $140K/yr
Posted 30+ days ago

Peregrine Advisors is an AI and data innovation hub helping government solve complex problems and deliver better outcomes. The Data Engineer will design and build database components and data pipelines for a federal enterprise platform, ensuring data accuracy, security, performance, and auditability across AWS services.

Information Technology & Services

Posted
30+ Days Ago
Source
Ethic Leaf recruiter
Sector
Information Technology & AI

No employer link yet — an Ethic Leaf recruiter forwards your application

Responsibilities

  • Design database schemas, and write the views, stored procedures, functions, and Structured Query Language (SQL) queries that run on them
  • Build and maintain data pipelines and extract, transform, and load (ETL) and extract, load, and transform (ELT) processes, including loads from Amazon Simple Storage Service (S3)
  • Make queries and databases fast enough for high-volume workloads
  • Help model data across Amazon Web Services (AWS) stores such as Amazon Aurora (PostgreSQL-compatible), Amazon DynamoDB, and S3
  • Keep data accurate and secure, with governed access and changes that can be audited
  • Work out data access patterns and integrations with developers, architects, and data engineers
  • Where the work allows, use artificial intelligence (AI)-assisted tools for query, pipeline, and troubleshooting work, and review and validate what they produce

Qualifications

  • 4+ years of data engineering, database development, database engineering, software development, or comparable practical experience
  • Bachelor's degree
  • Working expertise in Amazon Aurora (PostgreSQL-compatible), covering schema design, stored procedures and functions, and indexing
  • Experience with Amazon DynamoDB, covering data modeling and Global and Local Secondary Indexes (GSIs and LSIs)
  • SQL skills across complex queries, views, stored procedures, and functions, together with relational design, normalization, and data modeling
  • Performance and query tuning that addresses slow queries through indexing and execution-plan work
  • ETL and ELT development and data integration across AWS data services such as Aurora, DynamoDB, and S3
  • Experience working within data security controls such as encryption, access management, and auditing
  • Experience loading data from S3 into the platform stores and connecting through Open Database Connectivity (ODBC) and Java Database Connectivity (JDBC)
  • Experience making logical data modeling and database-design decisions for assigned components within an established platform architecture
  • Proficiency in writing, PowerPoint, and Excel
  • Solid SQL on a modern relational platform, Amazon Aurora (PostgreSQL-compatible), with stored procedures, functions, and views that hold up in use
  • Practical skill in query tuning against slow queries, indexing, and execution plans, together with data loading, connectivity, version control, and clean delivery
  • Practical experience developing logical data models and database schemas, and making database-design decisions for assigned components within the established platform architecture
  • The ability to own assigned database work from design through maintenance, working within data security controls, with sound judgment where accuracy and auditability are not optional
  • The initial engagement requires United States citizenship and the ability to obtain a Public Trust determination

Preferred

  • An AWS certification at the associate level, such as Developer Associate or Solutions Architect Associate
  • Experience tuning queries that involve locking and deadlocks
  • Familiarity with supporting cloud-native applications in AWS through continuous integration and continuous delivery (CI/CD) and development, security, and operations (DevSecOps) practices
  • Ownership of physical design for Aurora and DynamoDB schemas and indexes, or the drive to grow into it
  • Experience in federal information technology or high-volume transaction environments
  • Familiarity with AI-assisted developer tools

Required skills

SQLAmazon DynamoDBAmazon S3ETL/ELTData modelingDatabase schema designQuery performance tuningData security controlsODBC/JDBCAWS

Full job description

Peregrine Advisors is an AI and data innovation hub helping government solve complex problems and deliver better outcomes. The Data Engineer will design and build database components and data pipelines for a federal enterprise platform, ensuring data accuracy, security, performance, and auditability across AWS services.

Information Technology & Services

Responsibilities

  • Design database schemas, and write the views, stored procedures, functions, and Structured Query Language (SQL) queries that run on them
  • Build and maintain data pipelines and extract, transform, and load (ETL) and extract, load, and transform (ELT) processes, including loads from Amazon Simple Storage Service (S3)
  • Make queries and databases fast enough for high-volume workloads
  • Help model data across Amazon Web Services (AWS) stores such as Amazon Aurora (PostgreSQL-compatible), Amazon DynamoDB, and S3
  • Keep data accurate and secure, with governed access and changes that can be audited
  • Work out data access patterns and integrations with developers, architects, and data engineers
  • Where the work allows, use artificial intelligence (AI)-assisted tools for query, pipeline, and troubleshooting work, and review and validate what they produce

Preferred

  • An AWS certification at the associate level, such as Developer Associate or Solutions Architect Associate
  • Experience tuning queries that involve locking and deadlocks
  • Familiarity with supporting cloud-native applications in AWS through continuous integration and continuous delivery (CI/CD) and development, security, and operations (DevSecOps) practices
  • Ownership of physical design for Aurora and DynamoDB schemas and indexes, or the drive to grow into it
  • Experience in federal information technology or high-volume transaction environments
  • Familiarity with AI-assisted developer tools

Benefits

  • Hybrid work arrangement based in the Washington, DC metropolitan area, with the commuting cadence varying by assignment.
  • Medical, dental, and vision insurance with the employee premium fully paid and half of dependent premiums.
  • Employer-paid life, accidental death, and short-term and long-term disability insurance.
  • A 401(k) matched 100% up to 4% of salary, vesting immediately.
  • Unlimited paid time off.
  • Sponsored professional certifications and continuing education.
  • Extensive onboarding.
  • Rotation across functions to expand your skills and perspective.

Qualifications

  • 4+ years of data engineering, database development, database engineering, software development, or comparable practical experience
  • Bachelor's degree
  • Working expertise in Amazon Aurora (PostgreSQL-compatible), covering schema design, stored procedures and functions, and indexing
  • Experience with Amazon DynamoDB, covering data modeling and Global and Local Secondary Indexes (GSIs and LSIs)
  • SQL skills across complex queries, views, stored procedures, and functions, together with relational design, normalization, and data modeling
  • Performance and query tuning that addresses slow queries through indexing and execution-plan work
  • ETL and ELT development and data integration across AWS data services such as Aurora, DynamoDB, and S3
  • Experience working within data security controls such as encryption, access management, and auditing
  • Experience loading data from S3 into the platform stores and connecting through Open Database Connectivity (ODBC) and Java Database Connectivity (JDBC)
  • Experience making logical data modeling and database-design decisions for assigned components within an established platform architecture
  • Proficiency in writing, PowerPoint, and Excel
  • Solid SQL on a modern relational platform, Amazon Aurora (PostgreSQL-compatible), with stored procedures, functions, and views that hold up in use
  • Practical skill in query tuning against slow queries, indexing, and execution plans, together with data loading, connectivity, version control, and clean delivery
  • Practical experience developing logical data models and database schemas, and making database-design decisions for assigned components within the established platform architecture
  • The ability to own assigned database work from design through maintenance, working within data security controls, with sound judgment where accuracy and auditability are not optional
  • The initial engagement requires United States citizenship and the ability to obtain a Public Trust determination
  • An AWS certification at the associate level, such as Developer Associate or Solutions Architect Associate
  • Experience tuning queries that involve locking and deadlocks
  • Familiarity with supporting cloud-native applications in AWS through continuous integration and continuous delivery (CI/CD) and development, security, and operations (DevSecOps) practices
  • Ownership of physical design for Aurora and DynamoDB schemas and indexes, or the drive to grow into it
  • Experience in federal information technology or high-volume transaction environments
  • Familiarity with AI-assisted developer tools

Required skills

  • SQL, Amazon Aurora (PostgreSQL-compatible), Amazon DynamoDB, Amazon S3, ETL/ELT, Data modeling, Database schema design, Query performance tuning, Data security controls, ODBC/JDBC, AWS

Preferred skills

  • Experience tuning queries that involve locking and deadlocks, Familiarity with AI-assisted developer tools

Experience

  • 4+ years

Company

  • OPEN Data Job connects high potential data professionals with critical roles in the Federal sector and helps the Federal government and its contractors find the high quality help they need.
  • https://opendatajobs.com

Job details

Employment type

Full-time

Seniority level

4+ years

Date posted

Oct 7, 2026

Work mode

Hybrid

Job source

Ethic Leaf recruiter

Company

OPENDataJobs

Information Technology & AI

OPEN Data Job connects high potential data professionals with critical roles in the Federal sector and helps the Federal government and its contractors find the high quality help they need.

See all 4 jobs from OPENDataJobs →

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in Washington

Dice

1d ago

New

DATA ENGINEER

TemporaryHybridCalifornia City, CA$70K – $80K/yr

AaraTech Inc is seeking a Data Engineer to support healthcare data pipelines, data integration, and analytics platforms.

Why similarSame roleAWSAmazon S3

Capgemini Engineering

1d ago

New

Data Engineer AWS

Full-timeHybridWinter Haven, FLCompetitive

Capgemini Engineering is hiring a Data Engineer (AWS) for an innovative project in the automotive sector.

Why similarSame roleAWSData Modeling

Numerator

1d ago

New

Data Engineer II

Full-timeOn-siteChicago, IL$106K – $146K/yr

Numerator is hiring a Data Engineer II to develop resilient data pipelines and infrastructure for data products, analytics, and data science models.

Why similarSame roleAWSData Modeling

Get new Data Engineer jobs in Washington by email

Create job alert

Data Engineer (SQL)

OPENDataJobs · $120K – $140K/yr

Apply via Ethic Leaf