SQL Data Engineer

OpenDataJobs•Washington, DC

2h•$120,000 - $140,000•Hybrid

About The Position

Peregrine Advisors is hiring a SQL Data Engineer to design and build the data layer for a federal enterprise platform. The role is based in the Washington, DC metropolitan area with a hybrid work arrangement; commuting cadence varies by assignment. The initial engagement requires U.S. citizenship and the ability to obtain a Public Trust determination. The engineer will take responsibility for the accuracy and performance of assigned database components. Work may include designing database schemas; writing SQL queries, views, stored procedures, and functions; building and maintaining ETL and ELT pipelines, including data loads from Amazon S3; optimizing databases and queries for high-volume workloads; and modeling data across AWS services such as Amazon Aurora (PostgreSQL-compatible), Amazon DynamoDB, and S3. The role also involves maintaining data security, governed access, and auditable changes, and collaborating with developers, architects, and data engineers on data access patterns and integrations. Where appropriate, the engineer may use AI-assisted tools for query, pipeline, and troubleshooting work and validate their output. The successful candidate will deliver database components that analysts and systems can trust, automate data loads and checks, and build models that continue to work as the platform grows. This is a full-time W-2 position with a salary of $120,000 to $140,000 per year.

Requirements

At least 4 years of data engineering, database development, database engineering, software development, or comparable practical experience.
Bachelor's degree.
Strong SQL skills, including complex queries, views, stored procedures, and functions, as well as relational design, normalization, and data modeling.
Working expertise in Amazon Aurora (PostgreSQL-compatible), including schema design, stored procedures and functions, and indexing.
Experience with Amazon DynamoDB data modeling and Global and Local Secondary Indexes (GSIs and LSIs).
Experience tuning performance and queries, including indexing and execution-plan analysis.
Experience making logical data-modeling and database-design decisions for assigned components within an established platform architecture.
Experience developing ETL and ELT processes and integrating data across AWS services such as Aurora, DynamoDB, and S3.
Experience working with data security controls such as encryption, access management, and auditing.
Experience loading data from S3 into platform stores and connecting through ODBC and JDBC.
Proficiency in writing, PowerPoint, and Excel.
Ability to obtain a Public Trust determination and U.S. citizenship for the initial engagement.

Nice To Haves

AWS associate-level certification, such as Developer Associate or Solutions Architect Associate.
Experience tuning queries involving locking and deadlocks.
Familiarity with supporting cloud-native applications in AWS using CI/CD and DevSecOps practices.
Experience owning physical design for Aurora and DynamoDB schemas and indexes, or motivation to grow into that responsibility.
Experience in federal IT or high-volume transaction environments.
Familiarity with AI-assisted developer tools.

Responsibilities

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 performance and high-volume workloads.
Model data across AWS services including Amazon Aurora, Amazon DynamoDB, and S3.
Maintain accurate and secure data, governed access, and auditable changes.
Work with developers, architects, and data engineers to determine data access patterns and integrations.
Use AI-assisted tools for query, pipeline, and troubleshooting work where appropriate, and review and validate their output.
Own assigned database components from design through maintenance and ensure their accuracy and performance.
Automate data loads and checks that were previously performed manually.

Benefits

Medical insurance with the employee premium fully paid and half of dependent premiums covered.
Dental insurance with the employee premium fully paid and half of dependent premiums covered.
Vision insurance with the employee premium fully paid and half of dependent premiums covered.
Employer-paid life insurance.
Employer-paid accidental death insurance.
Employer-paid short-term and long-term disability insurance.
401(k) with an employer match of up to 4% of salary.
Unlimited paid time off.
Sponsored professional certifications and continuing education.
Extensive onboarding and development support across assignments and clients.
Opportunity to rotate across functions to expand skills and perspective.