Back to jobs
New

Senior Data Analyst

Washington, D.C.

Company Overview

K.L. Scott & Associates (KLSA) is a mission-driven management and technology consulting firm that partners with public-sector organizations to modernize operations, strengthen data and AI capabilities, and deliver measurable impact. KLSA combines strategic advisory services with hands-on delivery; bringing product leadership, secure data engineering, systems integration, and user-centered design to help clients translate complex requirements into scalable, high-quality solutions.

Position Overview

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.

Senior Data Analyst

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.

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.

Required Qualifications:  

  • 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.

Preferred Qualifications:  

  • 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.

Benefits: 

  • Competitive salary
  • Health, dental, and vision insurance
  • 401K
  • "Discretionary" PTO
  • Professional development opportunities
  • A dynamic and collaborative work environment

Working Environment: 

This role will support a federal client and requires regular collaboration with client stakeholders, public safety subject matter experts, business analysts, data analysts, dashboard developers, and project leadership. The Senior Data Analyst will play a key role in turning complex data into trusted dashboards, data visuals, reports, and insights that support client leadership decision-making.

If you are a results-driven professional and have the above qualifications, we encourage you to apply for this position.  Join our team and contribute to our continued growth and success.  To apply, please send your resume and a cover letter detailing your relevant experience and why you are the ideal candidate for this role. 

K.L. Scott & Associates is committed to diversity and inclusion and welcomes candidates from all backgrounds and experiences to apply. We thank all applicants for their interest, but only those selected for an interview will be contacted. 

Create a Job Alert

Interested in building your career at K.L. Scott & Associates? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

Phone
Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf


Education

Select...
Select...
Select...

Select...
Select...

DC Location

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in K.L. Scott & Associates’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.