Data Engineer (SQL)

Role Overview

As a Data Engineer at Peregrine Advisors, you will design and build the data layer for a federal enterprise platform. You will work alongside developers, engineers, data scientists, architects, and strategists on work ranging from strategy to implementation.

What You Will Do

Your responsibilities will include designing database schemas, writing SQL queries, building and maintaining data pipelines, and making queries and databases fast enough for high-volume workloads.

Why It Might Be a Fit

You will enjoy building with SQL and taking responsibility for getting data right. You will experiment, fail, learn, and repeat quickly, and you will own an outcome rather than being handed a task.

Requirements

• 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)
• Experience with Amazon DynamoDB
• SQL skills across complex queries, views, stored procedures, and functions
• Performance and query tuning
• ETL and ELT development and data integration across AWS data services
• Experience working within data security controls
• Experience loading data from S3 into the platform stores and connecting through ODBC and JDBC
• Experience making logical data modeling and database-design decisions for assigned components within an established platform architecture
• Proficiency in writing, PowerPoint, and Excel

Benefits

• 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

Tagged as: SQL