Junior Data Engineer (SQL)
About The Position
Peregrine Advisors is a growing AI and data innovation hub focused on helping government clients solve complex problems and improve outcomes. They work across the entire data lifecycle, including strategy, governance, architecture, engineering, analytics, AI, visualization, and training. Peregrine is a social enterprise organized as a Benefit Corporation and SBA 8(a) company, emphasizing client value, social value, and opportunity for their people. They are seeking dependable, motivated, and skilled individuals to join their expanding team. The company culture prioritizes people, trust, motivation, ownership, and collaboration, encouraging employees to take initiative and solve problems proactively. This role involves building and maintaining queries, stored procedures, and views for a federal agency's enterprise data platform, with opportunities to evolve into areas with the hardest problems. The position is hybrid, based in the Washington, DC metropolitan area, requires US citizenship, and the ability to obtain a Public Trust determination.
Requirements
- 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 extract, transform, and load (ETL) and extract, load, and transform (ELT) patterns and data integration across Amazon Web Services (AWS) data services.
- Awareness of data security controls, including encryption, access management, and auditing.
- Basic exposure to loading data from S3 into the platform stores and to Open Database Connectivity (ODBC) and Java Database Connectivity (JDBC).
- Introductory familiarity with logical data modeling and the ability to contribute to database-design decisions within an established platform architecture.
- Proficiency in writing, PowerPoint, and Excel.
- United States citizenship.
- Ability to obtain a Public Trust determination.
Nice To Haves
- An entry-level AWS certification, such as Cloud Practitioner, or the interest in earning one.
- Exposure to query blocking, locking, and deadlocks.
- Interest in cloud-native application support in AWS using continuous integration and continuous delivery (CI/CD) and development, security, and operations (DevSecOps) practices.
- Exposure to physical design, including Aurora and DynamoDB schema and index design, or the motivation to grow into it.
- Federal information technology or high-volume transaction experience.
- Interest in artificial intelligence (AI)-assisted developer tooling.
Responsibilities
- Build and maintain Structured Query Language (SQL) queries, stored procedures, and views in Amazon Aurora (PostgreSQL-compatible).
- Work with data from Amazon DynamoDB and Amazon Simple Storage Service (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 protocols.
- Grow towards responsibility for physical design over time.
Benefits
- Medical insurance with employee premium fully paid.
- Dental insurance with employee premium fully paid.
- Vision insurance with employee premium fully paid.
- Half of dependent premiums paid for medical, dental, and vision insurance.
- Employer-paid life insurance.
- Employer-paid accidental death insurance.
- Employer-paid short-term disability insurance.
- Employer-paid long-term disability insurance.
- 401(k) matched 100% up to 4% of salary, vesting immediately.
- Unlimited paid time off.
- Sponsored professional certifications.
- Sponsored continuing education.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
