Federal Reporting SME | SQL & Dashboards Lead

Unison

Rockville (MD)

Hybrid

USD 90,000 - 130,000

Full time

5 days ago
Be an early applicant
Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Technical Consultant: Federal Data Integration & ETL
Technical Consultant: Federal Data Integration & ETL

Unison • McLean (VA)

On-site
USD 110,000 - 145,000
Federal Systems Integration Consultant
Federal Systems Integration Consultant

Unison Inc. • Tysons (VA), Northern (KY)

Hybrid
USD 110,000 - 160,000
Senior Technical Consultant - Reporting SME
Senior Technical Consultant - Reporting SME

Unison • Rockville (MD)

Hybrid
USD 90,000 - 130,000
Senior Federal Solutions Architect – Data & Integrations
Senior Federal Solutions Architect – Data & Integrations

Unison • McLean (VA)

On-site
USD 150,000 - 205,000
Senior Data Visualization Architect for Enterprise Dashboards
Senior Data Visualization Architect for Enterprise Dashboards

Unissant • Washington

On-site
USD 110,000 - 150,000
SAP Design Lead: Secure Federal Finance Reporting
SAP Design Lead: Secure Federal Finance Reporting

NewGen Technologies • Herndon (VA), Northern (KY)

Hybrid
USD 120,000 - 180,000
Senior Reports Developer: Build Interactive Dashboards
Senior Reports Developer: Build Interactive Dashboards

PDS • Phoenix (AZ)

On-site
USD 110,000 - 120,000
SQL Reporting Developer
SQL Reporting Developer

Calculated Hire • Charlotte (NC)

On-site
USD 85,000 - 120,000
Senior SQL & Reporting Architect (ETL, SSRS/Crystal)
Senior SQL & Reporting Architect (ETL, SSRS/Crystal)

MicroHealth LLC • Vienna (VA)

On-site
USD 125,000 - 140,000
Reports Developer - US Citizen w/ Secret clearance
Reports Developer - US Citizen w/ Secret clearance

USM • Fairfax (VA)

On-site
USD 108,000 - 132,000