Data Analyst

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.

Requirements

into scalable, high-quality solutions. Position Overview We are seeking a Data Analyst with at least 3+ years of experience in data analytics to support a federal client in analyzing data, developing datasets, building dashboards, and preparing visualizations and reports that help client leadership make informed decisions. This role will work with business analysts, senior data analysts, dashboard developers, and federal stakeholders to translate reporting needs into clear, accurate, and useful analytical products.

Experience supporting a federal public safety agency is a plus. The ideal candidate will reside in or within commutable distance to Washington DC.

, metrics, data definitions, and intended dashboard use cases. Perform data quality reviews, identify anomalies or inconsistencies, and support resolution of data issues. Assist with dashboard testing, user acceptance testing, validation, and refinement based on stakeholder feedback.

Prepare clear documentation, including data dictionaries, metric definitions, report logic, source-to-target notes, and dashboard user guidance. Collaborate with senior data analysts, internal data teams, and dashboard developers to ensure analytical outputs are accurate, useful, and aligned with client priorities. Present analysis, findings, and dashboard functionality to technical and non-technical audiences as needed.

Support continuous improvement of reporting processes, dashboard usability, and data analysis workflows.

Key Responsibilities

: Support data analysis efforts by collecting, cleaning, validating, and preparing data from multiple source systems for dashboards, reports, and visualizations. Write SQL queries to extract, transform, join, summarize, and analyze data for recurring and ad hoc reporting needs. Support ETL activities, including data extraction, cleansing, transformation, quality checks, and documentation of business rules.

Build and maintain datasets used for dashboards, data visuals, performance reports, and analytical deliverables. Develop dashboards, reports, charts, and visualizations using Power BI, and other BI or reporting tools. Integrate Python into Power BI for highly customizable and complex statistical visualizations Create ad hoc reports and analytical summaries in response to client stakeholder and project team requests.

Required Qualifications

: Minimum of 3+ years of experience in data analysis, reporting, business intelligence, dashboard development, or a related analytical role. Bachelor of Science or Bachelor of Science in Business degree in Data Analytics, Data Science, Information Systems, Finance, Statistics, Mathematics, Computer Science, or an equivalent field. At least two years of experience with Python libraries such as pandas, dataframes, matplotlib, numpy, etc.

At least two years of experience writing complex SQL queries to extract, join, transform, and analyze data from relational databases or structured data sources.