SQL Data Engineer for Federal Data Platform

Peregrine Advisors; Washington; Hybrid; USD 120,000 - 140,000; Full time

Benefits offered by this job

Medical, dental, vision insurance (em折

Employer-paid life insurance

Disability insurance

401(k) with company match

Unlimited PTO

Sponsoring certifications

Job summary

Peregrine Advisors hires a data engineer to design and build the data layer for a federal enterprise platform. You will develop data pipelines, ETL/ELT processes, and model data across AWS services such as Aurora, DynamoDB, and S3.

You will ensure data accuracy, security, and auditable changes while collaborating with engineers and architects. The role is full-time, hybrid in the Washington, DC metro area, with a salary range of $120,000 to $140,000 per year.

Qualifications

• 4+ years of data engineering, database development, database engineering, software development, or comparable practical experience
• Bachelor's degree
• SQL skills across complex queries, views, stored procedures, and functions, together with relational design, normalization, and data modeling
• Working expertise in Amazon Aurora (PostgreSQL-compatible), covering schema design, stored procedures and functions, and indexing
• Experience with Amazon DynamoDB, covering data modeling and GSIs/LSIs
• Performance and query tuning that addresses slow queries through indexing and execution-plan work
• Experience making logical data modeling and database-design decisions for assigned components within an established platform architecture
• 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 ODBC and JDBC
• Proficiency in writing, PowerPoint, and Excel

Responsibilities

• Take ownership of designing and building the data layer for a federal enterprise platform
• Develop and maintain data pipelines, ETL/ELT processes, including loads from S3
• Ensure data accuracy and performance for high-volume workloads
• Model data across AWS stores like Aurora, DynamoDB, and S3
• Enforce data security with governed access and auditable changes
• Collaborate with developers, architects, and data engineers to optimize data access patterns
• Leverage AI-assisted tools for queries, pipelines, and troubleshooting where appropriate

Skills

SQL

AWS

Data modeling

ETL/ELT

Data warehousing

Data security

Education

Bachelor's degree

Tools

Amazon Aurora

DynamoDB

S3

Job description

Peregrine Advisors hires a data engineer to design and build the data layer for a federal enterprise platform. You will develop data pipelines, ETL/ELT processes, and model data across AWS services such as Aurora, DynamoDB, and S3.

You will ensure data accuracy, security, and auditable changes while collaborating with engineers and architects. The role is full-time, hybrid in the Washington, DC metro area, with a salary range of $120,000 to $140,000 per year.