Data Analyst

K.L. Scott & Associates; Washington; On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Competitive salary

Health, dental, and vision insurance

401K

Discretionary PTO

Professional development opportunities

Job summary

K.L. Scott & Associates in Washington, DC, is seeking a Data Analyst with 3+ years of experience to support a federal client. You will analyze data, build datasets, and develop dashboards and reports for leadership decisions.

The ideal candidate will work with business analysts, senior data analysts, dashboard developers, and federal stakeholders to translate reporting needs into accurate analytical outputs, ensuring quality and usability.

Qualifications

• 3+ years in data analytics, reporting, BI dashboards or related role.
• BS in Data Analytics, Data Science, IS, Finance, Math or CS or equivalent.
• 2+ years with Python libraries (pandas, matplotlib, numpy).
• 2+ years writing complex SQL for relational DBs.
• 2+ years of writing DAX and M language formulas.

Responsibilities

• Collect, clean, validate, and prepare data from multiple sources for dashboards and reports.
• Write SQL queries to support recurring and ad hoc reporting needs.
• Support ETL/ELT activities including data cleansing and rule documentation.
• Build datasets for dashboards, visuals, and performance reports.
• Develop dashboards and visualizations using Power BI and other BI tools.
• Integrate Python into Power BI for advanced visualizations.
• Create ad hoc reports and analytics summaries for stakeholders.
• Collaborate with analysts and stakeholders to understand reporting requirements.
• Document data dictionaries, metric definitions, and dashboard logic.
• Participate in testing, validation, and stakeholder feedback iterations.

Skills

Python

SQL

Power BI

DAX

Data Analytics

Education

Bachelor of Science in Data Analytics

Tools

Power BI

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

Data Analyst

The ideal candidate is detail-oriented, technically capable, and comfortable working with structured data, Python, R, SQL, DAX, BI tools, and dashboard requirements. Experience supporting a federal public safety agency is a plus.

The ideal candidate will reside in or within commutable distance to Washington DC.

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.
• Work with business analysts and client stakeholders to understand reporting requirements, 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.

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.
• At least two years of writing complex DAX and M-language formulas involving financial data
• At least two years of experience in finance or accounting
• Experience in statistical modeling and financial forecasting (linear regression/logical regression/time series forecasting)
• Experience automating workflows
• Experience working with multiple data sources and preparing datasets for reporting, dashboards, or business intelligence products.
• Experience supporting ETL/ELT, data cleansing, data validation, and data quality review activities.
• Experience developing dashboards, reports, and visualizations using Power BI, or similar BI tools.
• Understanding of data visualization concepts, dashboard design principles, and reporting best practices.
• Ability to build ad hoc reports and summarize analytical findings for stakeholders.
• Strong written and verbal communication skills.
• Ability to work effectively with federal clients, business analysts, senior data analysts, dashboard developers, and technical teams.
• Strong attention to detail, organizational skills, and ability to manage multiple analytical tasks in a client-facing environment.
• Must be in-person in Washington, D.C. 5 days a week.
• Must have or be able to obtain full scope background investigation and clearance.

Preferred Qualifications:

• Experience supporting federal clients, particularly federal public safety, law enforcement, homeland security, emergency management, or related mission environments.
• Expert in Python, SQL, and Power BI DAX
• Expert in financial modeling and forecasting
• Expert in ETL/ELT processes
• Experience in BASH commands and PowerShell
• Experience working in government consulting or public sector analytics environments.
• Experience with additional BI, reporting, database, or data preparation tools.
• Familiarity with data dictionaries, data lineage, metric documentation, and data governance practices.
• Experience supporting executive-level dashboards, operational performance reporting, or mission-focused analytics.
• Familiarity with Agile, hybrid, or iterative project delivery environments.

Desired Skills and Competencies

• Strong analytical, problem-solving, and critical-thinking skills.
• Solid Python, SQL, DAX, data preparation, dashboarding, and data visualization capabilities.
• Ability to turn business and reporting needs into accurate datasets, charts, reports, and dashboard outputs.
• Strong communication skills and ability to explain analytical findings to technical and non-technical audiences.
• Strong attention to detail and commitment to data quality and documentation.
• Ability to collaborate effectively with senior analysts, business analysts, federal stakeholders, and technical teams.
• Willingness to learn, receive mentorship, and contribute to team standards and repeatable analytical practices.

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 collaboration with client stakeholders, public safety subject matter experts, business analysts, senior data analysts, dashboard developers, and project leadership. The Data Analyst will help transform raw data into usable datasets, dashboards, reports, and visual insights that support operational and leadership decision-making.

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.