Data Engineer: Fast SQL Pipelines for Government Data

Peregrine Advisors LLC; Washington (District of Columbia); Ibrido; USD 90.000 - 130.000; Tempo pieno

Descrizione del lavoro

Peregrine Advisors LLC is seeking developers to design database schemas and build scalable data pipelines using AWS data services. You will work on a federal enterprise platform with diverse data workloads and collaboration across engineering teams.

The role is based in the Washington, DC metropolitan area with a hybrid work arrangement. The work involves ensuring data accuracy, security, and performance across complex datasets.

Competenze

• Ability to design database schemas and optimize queries.
• Experience building ETL/ELT pipelines and data integration.
• Familiarity with AWS data services (S3, Aurora, DynamoDB).

Mansioni

• Design database schemas and create views, procedures, and SQL queries.
• Build and maintain data pipelines and ETL/ELT processes, including loads from S3.
• Model data across AWS stores and ensure data accuracy and security.
• Collaborate with data engineers, architects, and developers on data access patterns.

Conoscenze

Database design

Data pipelines

SQL

AWS data stores

Strumenti

Amazon S3

Amazon Aurora

Amazon DynamoDB

Descrizione del lavoro

Peregrine Advisors LLC is seeking developers to design database schemas and build scalable data pipelines using AWS data services. You will work on a federal enterprise platform with diverse data workloads and collaboration across engineering teams.

The role is based in the Washington, DC metropolitan area with a hybrid work arrangement. The work involves ensuring data accuracy, security, and performance across complex datasets.