Senior Data Analyst

K.L. Scott & Associates

Washington (Washington County)

On-site

USD 120,000 - 150,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

K.L. Scott & Associates is seeking a Senior Data Analyst to design, build, and deliver data-driven decision-support products for a federal client. The role focuses on extracting data from multiple sources, building trusted datasets, and delivering complex analyses and dashboards.

The ideal candidate has 7+ years of data analytics experience, strong communications, and hands-on leadership to mentor junior analysts and guide small project teams. Hybrid work options near Washington DC are possible.

Qualifications

  • 7+ years of data analytics, BI, or related role.
  • Experience with Python libraries (pandas, numpy, etc.) and SQL.
  • Financial data experience and forecasting familiarity.
  • Experience leading small teams or mentoring juniors.

Responsibilities

  • Lead data analysis to identify trends and actionable insights for leadership decisions.
  • Extract, transform, and integrate data from multiple sources for dashboards and reports.
  • Develop and optimize SQL queries, views, and ETL logic for reporting.
  • Utilize Python for ETL, data cleaning, and preparation for analysis and visualization.
  • Create dashboards and visuals using Power BI and Tableau.

Skills

Data analytics
Python
SQL
Power BI
Tableau
ETL
Mentoring

Education

BS in Data Analytics / related field

Tools

Power BI
Tableau
Python
SQL

Job description

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 7+ years of experience in data analytics 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.

Key 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.
  • Utilize Python scripting for 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 Power BI, and other BI tools.
  • Integrate Python into Power BI for highly customizable and complex statistical visualizations
  • 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 7+ years of experience in data analytics, data science, business intelligence, reporting, data engineering, or a related analytical role.
  • Bachelor of Science or Bachelor of Science in Business degree in Data Analytics, Data Science, Information Systems, Computer Science, Statistics, Mathematics, Finance, or an equivalent field.
  • At least three years of experience with Python libraries such as pandas, dataframes, matplotlib, numpy, etc.
  • At least three years of writing complex DAX and M-language formulas involving financial data
  • At least five years of experience in finance or accounting
  • Experience in statistical modeling and financial forecasting (linear regression/logical regression/time series forecasting)
  • Experience automating workflows
  • 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
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Analyst & BI Lead (Federal)
Senior Data Analyst & BI Lead (Federal)

K.L. Scott & Associates • Washington

On-site
USD 120,000 - 150,000
Financial Data Analyst
Financial Data Analyst

Insight Global (United States) • Washington

On-site
USD 135,000 - 150,000
Senior Data Analyst: Insights & Dashboards Lead
Senior Data Analyst: Insights & Dashboards Lead

Prophecy Technologies Corp • United States

On-site
USD 90,000 - 120,000
Senior Data Analyst
Senior Data Analyst

Prophecy Technologies Corp • Malvern

On-site
USD 90,000 - 120,000
Data Program Lead / Senior Training Analytics and Power BI Lead
Data Program Lead / Senior Training Analytics and Power BI Lead

mks2technologies • Linthicum (MD)

On-site
USD 150,000 - 170,000
Sr. Data Analyst
Sr. Data Analyst

Tangerine Search Inc. • New York (NY)

On-site
USD 80,000 - 110,000
Comprehensive benefits
Opportunities for professional growth
Senior Data Analyst
Senior Data Analyst

Integrated BI Solutions Inc • Greenbelt (MD)

On-site
USD 90,000 - 120,000
Senior Data Analyst
Senior Data Analyst

Itgiantsolutions • United States

On-site
USD 120,000 - 160,000
Senior Data Scientist: AI + Cloud Analytics, Hybrid
Senior Data Scientist: AI + Cloud Analytics, Hybrid

Tripoint Solutions, LLC • Arlington (VA)

Hybrid
USD 100,000 - 175,000
Medical, Dental, Vision
FSA & HSA
Life & Disability Insurance
+6
Senior Data Analyst
Senior Data Analyst

SiloSmashers, Inc. • Washington

On-site
USD 130,000 - 140,000