Data Engineer, SQL

OPENDataJobs

. Design database schemas and write views, stored procedures, functions, and SQL queries .

Posted 10/8/2026full-timeUnited StatesMid-LevelSenior💰 $120,000 - $140,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and optimizing database schemas, writing complex SQL queries, and building scalable data models within AWS environments. Proficient in ETL/ELT processes and data security controls, ensuring accurate and governed data access.

Highest-signal resume keywords

Amazon Aurora ExpertiseSQL Query OptimizationETL/ELT DevelopmentData Security ControlsData Modeling with DynamoDB

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Database Schema DesignSQL QueriesStored ProceduresFunctionsData Pipeline DevelopmentPerformance TuningData IntegrationData ModelingRelational DesignNormalization

Soft Skills

Writing ProficiencyPresentation SkillsAnalytical Thinking

Tools & Technologies

Amazon S3Amazon DynamoDBODBCJDBC

Industry Keywords

Data EngineeringDatabase DevelopmentData SecurityPublic Trust DeterminationFederal Enterprise Platform

Tech Stack

Tools & technologies

AWSDynamoDBETLPostgresSQL

About the role

Key responsibilities & impact

Design database schemas and write views, stored procedures, functions, and SQL queries
Build and maintain data pipelines and ETL/ELT processes, including loads from Amazon S3
Optimize queries and databases for high-volume workloads
Model data across AWS stores including Amazon Aurora, Amazon DynamoDB, and S3
Maintain accurate and secure data with governed, auditable access and changes
Define 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
Own assigned database components from design through maintenance
Automate manual data loads and checks
Build scalable data models for the federal enterprise platform

Requirements

What you’ll need

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), including schema design, stored procedures and functions, and indexing
Experience with Amazon DynamoDB, including 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 addressing 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 platform stores and connecting through ODBC and JDBC
Experience making logical data modeling and database-design decisions within an established platform architecture
Proficiency in writing, PowerPoint, and Excel
Initial engagement requires United States citizenship
Ability to obtain a Public Trust determination

Benefits

Comp & perks

Medical, dental, and vision insurance with the employee premium fully paid and half of dependent premiums
Employer-paid life insurance
Employer-paid accidental death insurance
Employer-paid short-term and long-term disability insurance
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 skills and perspective
Full-time W-2 employment