Data Analyst: SQL/AWS | Build Trusted Federal Dashboards

Peregrine Advisors; Washington; Hybrid; USD 75,000 - 110,000; Full time

Benefits offered by this job

401(k) matched

Paid time off

Professional certifications

Sponsored training

Job summary

Peregrine Advisors is a data and technology firm located in the Washington, DC area, seeking a data analyst who can own analyses from question through delivery. You will turn federal program data into trusted numbers, build clean analytical datasets, and create dashboards that support decision making while ensuring auditability.

The role requires 3+ years of data analysis, strong SQL, and experience with Power BI or Tableau.

Qualifications

• 3+ years of data analysis experience.
• Strong SQL and BI reporting experience.
• Experience with Power BI or Tableau.
• Experience scripting with Python or R.
• Ability to own an analysis from question through delivered answer.
• Excellent writing, PowerPoint and Excel skills.

Responsibilities

• Turn a federal program's operational data into numbers people can trust by defining measures and documenting business rules.
• Write the SQL that turns platform data on AWS data stores into clean, reconciled analytical datasets.
• Build recurring reports and dashboards with 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

Data analysis

SQL

Python

R

PowerPoint

Excel

Education

Bachelor's degree

Master's degree (preferred)

Tools

Power BI

Tableau

AWS

Job description

Peregrine Advisors is a data and technology firm located in the Washington, DC area, seeking a data analyst who can own analyses from question through delivery. You will turn federal program data into trusted numbers, build clean analytical datasets, and create dashboards that support decision making while ensuring auditability.

The role requires 3+ years of data analysis, strong SQL, and experience with Power BI or Tableau.