Senior Data Engineer, SQL

OPENDataJobs

. Own the data pipelines and databases behind a mission-critical federal enterprise data platform .

Posted 10/8/2026full-timeUnited StatesSenior💰 $150,000 - $170,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

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

Demonstrates expertise in database design, performance tuning, and data integrity within AWS environments, particularly with Amazon Aurora and DynamoDB. Proficient in ETL and ELT development, data security controls, and CI/CD practices to support enterprise applications.

Highest-signal resume keywords

Amazon Aurora ExpertiseAdvanced SQL SkillsETL and ELT DevelopmentData Security ControlsCI/CD and DevSecOps Practices

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 DesignPerformance TuningData ModelingSQL Query OptimizationSchema DesignStored ProceduresIndexingData IntegrationBackup and RecoveryDisaster Recovery

Soft Skills

CollaborationCommunicationProblem-Solving

Tools & Technologies

Amazon DynamoDBAmazon RedshiftAWS GlueAWS DMSAWS Lake FormationTerraformCloudFormationAWS CDKAmazon CloudWatchDatadog

Certifications & Qualifications

AWS Database SpecialtyAWS Developer AssociateAWS Solutions Architect

Industry Keywords

Federal Information TechnologySecurity ControlsCompliance FrameworksHigh-Volume Transaction ProcessingRegulatory Reporting

Tech Stack

Tools & technologies

Amazon RedshiftAWSCloudDynamoDBETLPostgresSplunkSQLTerraform

About the role

Key responsibilities & impact

Own the data pipelines and databases behind a mission-critical federal enterprise data platform
Own database design, performance, reliability, and data integrity
Design and maintain scalable databases in Amazon Aurora, Amazon DynamoDB, and other platform data stores
Design logical and physical data models and build schemas, indexes, views, stored procedures, and functions
Write and tune complex SQL using execution plans and indexing
Build and support ETL and ELT pipelines and S3 loads
Troubleshoot performance, locking, replication, and data consistency issues
Maintain availability and recoverability through monitoring, capacity planning, backup and recovery, high availability, and disaster recovery
Secure databases with least-privilege access and maintain auditability
Collaborate with architects, developers, and data engineers
Move database changes through CI/CD and infrastructure as code
Automate data-integration and load patterns and build governed access controls

Requirements

What you’ll need

7+ years of hands-on data engineering, database development, database engineering, software development, or comparable practical experience in support of enterprise applications
Bachelor's degree
Expertise in Amazon Aurora (PostgreSQL-compatible), including schema design, stored procedures and functions, indexing, and execution-plan analysis
Experience with Amazon DynamoDB, including data modeling, partition and key design, and Global and Local Secondary Indexes (GSIs and LSIs)
Advanced SQL skills across complex queries, views, stored procedures, and functions, together with relational design, normalization, and data modeling
Performance and query tuning for slow queries, locking, and deadlocks through indexing and execution-plan work
ETL and ELT development and data integration across AWS data services such as RDS, S3, and data migration services
Data security controls including encryption, access management, auditing, and compliance
Support for cloud-native applications in AWS through CI/CD and DevSecOps practices, including monitoring, backup and recovery, high availability, and disaster recovery
Proficiency in writing, PowerPoint, and Excel
United States citizenship and ability to obtain a Public Trust determination
Preferred: AWS certification at Database Specialty, Developer Associate, or Solutions Architect level
Preferred: Federal information technology experience with security controls and compliance frameworks
Preferred: Experience with high-volume transaction processing, large-scale data platforms, or regulatory reporting
Preferred: Experience with database observability and monitoring tools such as Amazon CloudWatch, Performance Insights, Datadog, or Splunk
Preferred: Experience with Amazon Redshift, AWS Glue, AWS DMS, or AWS Lake Formation
Preferred: Experience with infrastructure as code, including Terraform, CloudFormation, and AWS CDK
Preferred: Experience with AI-assisted development tooling

Benefits

Comp & perks

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
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