Federal Data Analyst: SQL, AWS & Dashboards

Peregrine Advisors LLC; Washington (District of Columbia); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical, dental, and vision fully paid

401(k) matched 100% up to 4%

Unlimited paid time off

Sponsored professional certifications

Job summary

Peregrine Advisors is a data and technology innovation hub focused on delivering for the US public and federal programs. You will turn operational data into trusted numbers, build clean datasets on AWS, and create dashboards and reports used by program teams.

You will work in a hybrid Washington, DC area role, turning complex data into repeatable, auditable insights while collaborating with developers, data scientists, and strategists committed to public value.

Qualifications

• 3+ years of data analysis experience.
• Bachelor's degree.
• Strong working command of SQL.
• Experience building reports and dashboards in a BI tool (Power BI, Tableau, or comparable).
• Familiarity with scripting for analysis (Python or R).
• Ability to own an analysis from question through delivered, documented answer.
• Basic proficiency in writing, PowerPoint, and Excel.

Responsibilities

• Turn a federal program's operational data into numbers people can trust by defining measures with the owners and documenting the business rules behind every number.
• Write the SQL that turns platform data on Amazon Aurora and related AWS data stores into clean, reconciled analytical datasets.
• Build recurring reports and dashboards with documented measures, refresh schedules, and access controls.
• Trace discrepancies to their source: definitions, timing, filters, and source systems, until the number is explained.
• Replace manual reporting with repeatable, tested workflows.

Skills

SQL

Python

R

Excel

Power BI

Tableau

Education

Bachelor's degree

Tools

Amazon Aurora

AWS

Power BI

Tableau

Job description

Peregrine Advisors is a data and technology innovation hub focused on delivering for the US public and federal programs. You will turn operational data into trusted numbers, build clean datasets on AWS, and create dashboards and reports used by program teams.

You will work in a hybrid Washington, DC area role, turning complex data into repeatable, auditable insights while collaborating with developers, data scientists, and strategists committed to public value.