Junior Data Engineer, SQL

OPENDataJobs

. Build and maintain SQL queries, stored procedures, and views in Amazon Aurora (PostgreSQL-compatible) .

Posted 10/8/2026full-timeUnited StatesJunior💰 $80,000 - $95,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

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

Proficient in SQL query development and data integration using Amazon Aurora, DynamoDB, and S3, with a foundational understanding of data modeling and security controls. Capable of collaborating effectively with cross-functional teams to enhance database design and data load processes.

Highest-signal resume keywords

SQL Query DevelopmentAmazon Aurora (PostgreSQL-Compatible)Data Integration with AWSETL and ELT PatternsData Security Controls

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

SQLStored ProceduresViewsQuery TuningData ModelingData LoadingETLELTODBCJDBC

Soft Skills

CollaborationCommunicationWriting

Tools & Technologies

Amazon DynamoDBAmazon S3PowerPointExcel

Certifications & Qualifications

Bachelor's DegreePublic Trust Determination

Industry Keywords

Data EngineeringDatabase DevelopmentData SecurityAccess ManagementAuditing

Tech Stack

Tools & technologies

AWSDynamoDBETLPostgresSQL

About the role

Key responsibilities & impact

Build and maintain SQL queries, stored procedures, and views in Amazon Aurora (PostgreSQL-compatible)
Work with data from Amazon DynamoDB and Amazon S3
Contribute to logical data models and database-design decisions within the established platform architecture
Build reliable data loads from S3
Tune queries with guidance from a senior developer
Work within governed access
Grow toward responsibility for physical design
Collaborate with developers, engineers, data scientists, architects, and strategists across assignments

Requirements

What you’ll need

1+ years of data engineering, database development, software development, or comparable practical experience
Bachelor's degree
Working knowledge of SQL, stored procedures, and views on Amazon Aurora (PostgreSQL-compatible)
Familiarity with Amazon DynamoDB and Amazon Simple Storage Service (S3)
Query tuning with guidance from a senior developer
Exposure to ETL and ELT patterns and data integration across AWS data services
Awareness of data security controls, including encryption, access management, and auditing
Basic exposure to loading data from S3 into platform stores and to ODBC and JDBC
Introductory familiarity with logical data modeling and database-design decisions within an established platform architecture
Proficiency in writing, PowerPoint, and Excel
Initial engagement requires United States citizenship and 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, 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
Onboarding, sponsored training, and professional development
Full-time W-2 employment