Senior Data Analyst

K.L. Scott & Associates•Washington, DC

5d•Onsite

About The Position

We are seeking a Senior Data Analyst with at least 10 years of experience to support a federal client in designing, developing, and delivering data-driven decision-support products. This role will focus on extracting data from multiple source systems, building trusted datasets, developing SQL queries and ETL logic, and producing complex analysis, dashboards, and visualizations for client leadership. The Senior Data Analyst will serve as a senior technical and analytical contributor, working closely with federal public safety stakeholders, project leadership, business analysts, data analysts, and dashboard developers. The ideal candidate is a strong communicator, an experienced hands-on analyst, and a collaborative team lead who can mentor junior analysts and lead small project teams. The ideal candidate will reside in or within commutable distance to Washington DC.

Requirements

Minimum of 10 years of experience in data analytics, data science, business intelligence, reporting, data engineering, or a related analytical role.
Bachelor of Science or Bachelor of Arts degree in Data Analytics, Data Science, Information Systems, Computer Science, Statistics, Mathematics, Finance, or an equivalent field.
Hands-on experience extracting data from multiple source systems and developing datasets for dashboarding, reporting, and analysis.
Strong experience writing and optimizing SQL queries for data extraction, analysis, transformation, and reporting.
Experience coding or supporting ETL processes, including data cleansing, transformation, validation, and integration.
Experience developing dashboards and visualizations in Tableau and Power BI.
Experience with business intelligence tools, data visualization concepts, dashboard design, and reporting best practices.
Ability to conduct complex data analysis and communicate findings clearly to client leadership and technical teams.
Experience building ad hoc reports and recurring analytical deliverables for decision support.
Experience leading small teams or analytical workstreams.
Strong written and verbal communication skills, including the ability to explain data concepts to non-technical stakeholders.
Strong problem-solving skills, attention to detail, and ability to work in a fast-paced, client-facing environment.

Nice To Haves

Experience supporting federal clients, particularly federal public safety, law enforcement, emergency management, homeland security, or related mission environments.
Experience working in government consulting, federal data modernization, or mission analytics environments.
Experience with additional BI, reporting, or analytics tools beyond Tableau and Power BI.
Experience with dashboard performance optimization, data governance, data quality frameworks, or data management best practices.
Familiarity with Agile, hybrid, or iterative delivery methods.
Experience developing executive-level dashboards, operational performance dashboards, or public safety decision-support products.

Responsibilities

Lead complex data analysis efforts to identify trends, patterns, risks, performance drivers, and actionable insights that support federal client leadership decisions.
Extract, transform, and integrate data from multiple source systems to build reliable datasets for reporting, dashboards, and advanced analysis.
Develop, optimize, and maintain SQL queries, views, scripts, and data logic used to support dashboards, ad hoc reports, and recurring decision-support products.
Code and support ETL processes, including data extraction, cleansing, transformation, validation, and preparation for downstream analysis and visualization.
Design and build curated datasets, data models, and data structures that support accurate, repeatable, and scalable reporting.
Develop dashboards, data visuals, and business intelligence products using Tableau, Power BI, and other BI tools.
Build ad hoc reports and analytical products in response to client leadership, operational, and program management needs.
Partner with federal client stakeholders, public safety subject matter experts, business analysts, and internal data teams to define metrics, KPIs, reporting requirements, and data definitions.
Translate complex data findings into clear narratives, visuals, and recommendations for technical and non-technical audiences.
Perform data quality checks, data profiling, reconciliation, and validation to ensure accuracy and reliability of reporting outputs.
Lead small project teams, coordinate analytical workstreams, assign tasks, monitor progress, and communicate risks, issues, and status to project leadership.
Mentor junior data analysts by reviewing work products, sharing analytical best practices, supporting skill development, and promoting consistent documentation standards.
Support user acceptance testing, dashboard validation, defect resolution, and stakeholder feedback cycles.
Create and maintain documentation, including data dictionaries, business rules, analytical assumptions, data lineage notes, and dashboard user guidance.
Identify opportunities to improve data processes, dashboard usability, automation, reporting consistency, and analytical efficiency.