Data Analyst (SQL, AWS) – Hybrid DC, Public Trust

Uncover; Washington, Northern (District of Columbia, KY); Hybrid; USD 90,000 - 140,000; Full time

Benefits offered by this job

Hybrid work model

Professional development and extensive

Job summary

Peregrine Advisors is seeking a data-focused professional to turn federal program data into trusted numbers and actionable insights. You will define measures, write SQL against AWS data stores, and build dashboards with documented rules and access controls.

The role emphasizes accuracy, auditability, and scalable, repeatable workflows. The position is hybrid and based in the Washington, DC metropolitan area, requiring regular commuting into DC.

Qualifications

• Sole United States citizenship and ability to obtain a Public Trust determination.
• Hybrid role based in the Washington, DC metropolitan area with regular commuting into DC.

Responsibilities

• Turn operational program data into trusted numbers by defining measures with process owners and documenting business rules.
• Write SQL to transform platform data on AWS into clean, reconciled analytical datasets.
• Build recurring reports and dashboards with documented measures, schedules, and access controls.
• Trace discrepancies to definitions, timing, and source systems until the number is explained.
• Replace manual reporting with repeatable, tested workflows.

Skills

SQL

Python

R

Data visualization

Data wrangling

Excel

Education

Bachelor's degree or equivalent in a relevant field

Tools

AWS

Amazon Aurora

BI dashboards

Job description

Peregrine Advisors is seeking a data-focused professional to turn federal program data into trusted numbers and actionable insights. You will define measures, write SQL against AWS data stores, and build dashboards with documented rules and access controls.

The role emphasizes accuracy, auditability, and scalable, repeatable workflows. The position is hybrid and based in the Washington, DC metropolitan area, requiring regular commuting into DC.