Data Analyst (SQL)

OpenDataJobs•Washington, DC

6d•Hybrid

About The Position

Peregrine Advisors is hiring a Data Analyst to turn a federal program’s operational data into reliable figures, reports, dashboards, and analytical datasets. The role is hybrid in the Washington, DC metropolitan area, with commuting cadence varying by assignment. The initial engagement requires United States citizenship and the ability to obtain a Public Trust determination. The first project will likely involve building the reporting a federal program relies on. The analyst will work with process owners to define measures and document business rules; use SQL to create clean, reconciled datasets from Amazon Aurora and related AWS data stores; and build reports, dashboards, and visualizations with documented measures, refresh schedules, and access controls. The analyst will trace discrepancies to their sources, produce validation and reconciliation evidence and issue logs suitable for audit, and replace manual reporting with repeatable, tested workflows. AI-assisted analysis using coding assistants and language models is part of the work, alongside the analyst’s own judgment. Assignments may evolve as program needs and priorities change. This is a full-time W-2 position with an annual salary of $67,000 to $123,000. Peregrine supports employee development through onboarding, sponsored certifications and continuing education, and rotation across functions and clients. The company describes its commitments as delivering value for clients, helping government work better for the public, and developing its team.

Requirements

At least 4 years of data analysis experience using SQL.
Bachelor’s degree.
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.
Ability to own an analysis from the first question through a delivered, documented answer.
Proficiency in writing, PowerPoint, and Excel.
United States citizenship for the initial engagement.
Ability to obtain a Public Trust determination for the initial engagement.

Nice To Haves

Master’s degree in a relevant field.
Experience with cloud data platforms on AWS.
Experience with federal program, financial, or performance data.
Familiarity with AI-assisted development and analysis tools.

Responsibilities

Work with process owners to define measures and document the business rules behind reported figures.
Write SQL to transform platform data on Amazon Aurora and related AWS data stores into clean, reconciled analytical datasets.
Build recurring reports, dashboards, and data visualizations with documented measures, refresh schedules, and access controls.
Design visualizations to answer the intended question clearly and avoid misleading scales or labels.
Investigate discrepancies and trace them to definitions, timing, filters, or source systems until the figures are explained.
Produce reporting quality evidence, including validation checks, reconciliation reports, and issue logs suitable for audit.
Replace manual reporting with repeatable, tested workflows.
Use coding assistants and language models for AI-assisted analysis, applying independent judgment.
Deliver figures with provenance and clean datasets that support subsequent analysis.
Own analyses from the initial question through a delivered, documented answer.

Benefits

Medical insurance with the employee premium fully paid and half of dependent premiums covered.
Dental insurance with the employee premium fully paid and half of dependent premiums covered.
Vision insurance with the employee premium fully paid and half of dependent premiums covered.
Employer-paid life insurance.
Employer-paid accidental death insurance.
Employer-paid short-term and long-term disability insurance.
401(k) with an employer match of up to 4% of salary.
Unlimited paid time off.
Sponsored professional certifications and continuing education.
Extensive onboarding.
Rotation across functions to expand skills and perspective.