Data Insights Analyst - Dashboards & Reports

Peregrine Advisors LLC; Washington (District of Columbia); On-site; USD 65,000 - 95,000; Full time

Job summary

Peregrine Advisors LLC is seeking a Data Analyst to turn operational data into actionable insights in Washington, DC. You will define measures, acquire and reconcile data, and build analyses, reports, and dashboards used by stakeholders across the organization.

The role involves working with SQL, spreadsheets, and BI tools to profile, clean, and validate data, ensuring accurate guidance for decision-makers and reviewers across teams.

Qualifications

• Experience querying, cleaning, joining, aggregating, and validating data.

Responsibilities

• Create recurring reports and dashboards with measures, refresh schedules, filters, alerts, and access controls.
• Develop clean analytical datasets and semantic models reconciling source fields, business definitions, relationships, and calculation logic.
• Write queries, scripts, and repeatable workflows that replace manual reporting.
• Perform variance, trend, cohort, performance, financial, program, or operational analyses and document findings.
• Maintain data-quality checks, reconciliation reports, issue logs, and documentation that establish data provenance.

Skills

SQL

Data cleaning

Data validation

Spreadsheets

Scripting

Data visualization

Version control

Tools

BI tools

Job description

Peregrine Advisors LLC is seeking a Data Analyst to turn operational data into actionable insights in Washington, DC. You will define measures, acquire and reconcile data, and build analyses, reports, and dashboards used by stakeholders across the organization.

The role involves working with SQL, spreadsheets, and BI tools to profile, clean, and validate data, ensuring accurate guidance for decision-makers and reviewers across teams.