SQL Data Engineer

OpenDataJobs • Washington, DC

4h • 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 position is based in the Washington, DC metropolitan area and follows a hybrid work arrangement, with commuting cadence varying 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 schemas; developing SQL queries, views, stored procedures, and functions; building and maintaining ETL and ELT pipelines, including data loads from Amazon S3; tuning databases and queries for high-volume workloads; and modeling data across AWS services such as Amazon Aurora, DynamoDB, and S3. The role also involves maintaining data security, governed access, and auditable changes, and coordinating data access patterns and integrations with developers, architects, and data engineers. Where appropriate, AI-assisted tools may be used for query, pipeline, and troubleshooting work, with their outputs reviewed and validated.

The role is a full-time W-2 position with an annual salary of $120,000 to $140,000. Peregrine describes a collaborative environment spanning development, engineering, data science, architecture, and strategy, and supports employee development through onboarding, sponsored certifications and continuing education, and rotation across functions and clients.

Requirements

• At least 4 years of data engineering, database development, database engineering, software development, or comparable practical experience.
• Bachelor's degree.
• SQL skills covering complex queries, views, stored procedures, and functions, plus 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 addressing slow queries through indexing and execution-plan analysis.
• 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 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 take ownership of assigned database work from design through maintenance and work with accuracy and auditability in mind.

Nice To Haves

• An 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 through CI/CD and DevSecOps practices.
• Experience owning physical design for Aurora and DynamoDB schemas and indexes, or motivation to develop that capability.
• Experience in federal IT or high-volume transaction environments.
• Familiarity with AI-assisted developer tools.

Responsibilities

• Design database schemas and develop SQL queries, views, stored procedures, and functions.
• Build and maintain ETL and ELT processes and data pipelines, including loads from Amazon S3.
• Tune queries and databases for performance and high-volume workloads, including indexing and execution-plan work.
• Model data across AWS services, including Amazon Aurora, DynamoDB, and S3.
• Maintain accurate and secure data, governed access, and auditable changes.
• Coordinate data access patterns and integrations with developers, architects, and data engineers.
• Use AI-assisted tools for query, pipeline, and troubleshooting work where appropriate, and review and validate their output.
• Take assigned database components from design through delivery and maintenance, and ensure their accuracy and performance.

Benefits

• Medical, dental, and vision insurance, with the employee premium fully paid and half of dependent premiums paid.
• Employer-paid life, accidental death, short-term disability, 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 opportunities to rotate across functions and assignments to develop skills and perspective.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level