Data Analyst (SQL)

OpenDataJobs • Washington, DC

15h • $67,000 - $123,000 • Hybrid

About The Position

Peregrine Advisors is hiring a Data Analyst for a full-time W-2 position based in the Washington, DC metropolitan area with a hybrid work arrangement. The initial engagement requires U.S. citizenship and the ability to obtain a Public Trust determination. The commuting cadence varies by assignment.

The analyst will turn federal program operational data into reliable, documented figures and analytical datasets. The initial project will likely involve building reporting for a federal program, including defining measures with process owners, documenting business rules, querying data in Amazon Aurora and related AWS data stores, and developing recurring reports, dashboards, and visualizations. The work emphasizes clear definitions, reconciliation, performance, appropriate access controls, and auditability.

The analyst will investigate discrepancies, produce validation checks and reconciliation reports, maintain issue logs, replace manual reporting with repeatable and tested workflows, and use AI-assisted analysis tools alongside sound professional judgment. As assignments and priorities change, the analyst may move to other challenging problems across the company’s work. The role involves collaboration with developers, engineers, data scientists, architects, strategists, and client stakeholders.

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.
• U.S. citizenship and ability to obtain a Public Trust determination for the initial engagement.
• Practical command of SQL and spreadsheets, with Python or R scripting where it makes work faster or safer.
• Care for accuracy and auditability, and the ability to explain anomalies and data figures.

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 from Amazon Aurora and related AWS data stores into clean, reconciled analytical datasets.
• Build recurring reports, dashboards, and visualizations with documented measures, refresh schedules, and access controls.
• Ensure reports answer the intended questions, load efficiently, and present figures clearly and accurately.
• Investigate discrepancies and trace them to definitions, timing, filters, or source systems until explained.
• Produce validation checks, reconciliation reports, and issue logs to support auditability.
• Replace manual reporting with repeatable, tested workflows.
• Use coding assistants and language models as part of analysis work, applying independent judgment.
• Own analyses from the initial question through delivery of a documented answer.

Benefits

• Medical, dental, and vision insurance; employee premiums are fully paid and half of dependent premiums are paid.
• Employer-paid life, accidental death, short-term disability, 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 and development support across assignments and clients.
• Opportunities to rotate across functions to expand skills and perspective.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level