For more information or to apply: https://www.governmentjobs.com/careers/washington/jobs/5282006/sql-report-analyst-it-data-management-journey-permanent-2026-02481
Closes: April 1, 2026
Embrace this role to serve as the primary data expert for the Licensing Division, shaping reporting strategy, improving data governance, and influencing agency-level decision-making.
This is an opportunity to collaborate with business and product owners to define and validate data requirements.
In this dynamic role, you will manage and analyze licensing data that supports over one million customers annually!
We are seeking a candidate to ensure the organization can reliably access, understand, and use high-quality licensing data to meet operational, regulatory, and public-facing needs.
WHAT TO EXPECT –
Among the varied range of responsibilities held within this role, this position will:
Data Analysis and Reporting.
- Develops and executes ad hoc SQL queries to support business needs, decision-making, and responses to public records requests requiring complex data extraction.
- Designs and maintains stored procedures for efficient data retrieval and transformation.
- Builds and supports canned reports and self-service reporting tools for internal and external stakeholders.
- Translates complex data into actionable insights through visualizations and dashboards.
- Ensures data accuracy, consistency, and reliability of licensing data across both commercial and recreational licensing systems.
Data Strategy and Governance.
- Contributes to the development and implementation of a long-term data management strategy for the Licensing Division.
- Assists in defining and maintaining data standards, policies, and procedures to promote consistency and compliance.
- Supports metadata infrastructure by documenting data sources, definitions, and lineage.
- Participates in data quality assurance and validation efforts across replicated databases to ensure reliable reporting.
Technical Expertise.
- Demonstrates proficiency in SQL Server, SSRS, and other reporting platforms.
- Optimizes queries for performance within vendor-hosted, read-only database constraints.
- Applies data warehousing principles to support historical analysis and trend reporting.
- Evaluates emerging tools and technologies that could improve data access, reporting, or visualization.
Business and Stakeholder Engagement.
- Serves as a subject matter expert (SME) on licensing data, policies, and business processes.
- Collaborates with product owners, program managers, and policy analysts to elicit and validate data requirements.
- Provides consultation and training on data access, interpretation, and reporting tools.
- Bridges the gap between technical data resources and business needs, ensuring solutions are aligned with operational goals.