Federal Reporting SME | SQL & Dashboards Lead

Unison; Rockville (MD); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Unison is seeking a Reporting Subject Matter Expert to own design, development, and delivery of client-facing reports, extracts, and dashboards for federal civilian, defense, and intelligence customers.

This hands-on role requires strong SQL skills, solid knowledge of relational databases, and the ability to troubleshoot reporting issues independently while working with clients and delivery teams.

Qualifications

• Professional experience building, maintaining, or troubleshooting reports, extracts, or dashboards against relational databases.
• Experience gathering and tracking reporting requirements directly from business or client stakeholders.
• Experience supporting enterprise software, ERP, or large-scale system implementations.
• Experience working in structured delivery environments (Agile, Waterfall, or hybrid).
• Experience supporting software implementations for federal government agencies or government contractors is preferred.

Responsibilities

• Gather, document, and maintain a clear inventory of client reporting requirements, translating business needs into reportable data specifications.
• Design, build, and deliver ad hoc and recurring reports, extracts, and dashboards that meet client operational, financial, and compliance reporting needs.
• Write and optimize complex SQL queries against relational databases to retrieve, join, and validate data across multiple tables and sources.
• Maintain a working knowledge of underlying database structures, table relationships, and data dictionaries sufficient to independently trace and resolve reporting discrepancies.
• Troubleshoot reporting issues end to end, including data accuracy, performance, and formatting problems, and implement durable fixes.
• Prioritize and track a queue of reporting requests, communicating status, timelines, and tradeoffs to clients and delivery leadership.
• Partner with functional and technical consultants to understand upstream data sources and confirm report logic against business rules.
• Create and maintain documentation for report specifications, data sources, calculation logic, and refresh schedules.
• Validate report accuracy through peer review, test data, and client sign-off prior to release.
• Identify opportunities to standardize, automate, or template recurring report requests to reduce turnaround time.
• Operate with minimal day-to-day oversight, escalating genuinely ambiguous requirements or cross-program issues as needed.

Skills

SQL

Data analysis

Reporting dashboards

Stakeholder communication

Education

Bachelor's degree in Computer Science/IS/Data Analytics

Tools

Power BI

Oracle BI

JasperReports

Crystal Reports

ETL tools

Job description

Unison is seeking a Reporting Subject Matter Expert to own design, development, and delivery of client-facing reports, extracts, and dashboards for federal civilian, defense, and intelligence customers.

This hands-on role requires strong SQL skills, solid knowledge of relational databases, and the ability to troubleshoot reporting issues independently while working with clients and delivery teams.