SQL Data Analyst for Federal Analytics & Dashboards

Peregrine Advisors LLC; Vermont; Hybrid; USD 67,000 - 123,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

401(k) with employer match

Unlimited paid time off

Certifications and continuingeducation

Job summary

Peregrine Advisors LLC is seeking a data analyst to turn federal program data into reliable figures. You will define measures, write SQL on AWS, and build dashboards with strong data governance. You will replace manual reporting with scalable, auditable workflows and apply AI-assisted analysis under leadership guidance.

The role emphasizes ownership of analyses from question to delivered answer, with growth opportunities across assignments and clients in a hybrid Washington, DC area setting.

Qualifications

• 4+ years of data analysis experience using SQL.
• Bachelor's degree in a relevant field.
• Strong working command of SQL.
• Experience building reports and dashboards in a business intelligence tool, such as Power BI, Tableau, or a comparable tool
• Familiarity with Python or R for analysis scripting.
• The ability to own an analysis from the first question to a delivered, documented answer
• Proficiency in writing, PowerPoint, and Excel

Responsibilities

• Define measures with process owners and document business rules.
• Write SQL on AWS data stores to create clean, reconciled analytic datasets.
• Build recurring reports, dashboards, and visualizations with documented measures, refresh schedules, and access controls.
• Trace discrepancies to their source and explain figures.
• Produce validation checks, reconciliation reports, and audit logs.
• Replace manual reporting with repeatable, tested workflows.
• Apply AI-assisted analysis with coding assistants and your own judgment.

Skills

SQL

Data analysis

Power BI

Tableau

Python/R

PowerPoint

Excel

Education

Bachelor's degree

Master's degree in a relevant field

Tools

Power BI

Tableau

AWS

SQL

Python

R

Job description

Peregrine Advisors LLC is seeking a data analyst to turn federal program data into reliable figures. You will define measures, write SQL on AWS, and build dashboards with strong data governance. You will replace manual reporting with scalable, auditable workflows and apply AI-assisted analysis under leadership guidance.

The role emphasizes ownership of analyses from question to delivered answer, with growth opportunities across assignments and clients in a hybrid Washington, DC area setting.