Data Analyst

K.L. Scott & Associates

$70K — $95K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 5+ years of experience in data analysis, reporting, or business intelligence roles.
  • Bachelor's degree in Data Analytics, Data Science, or related field.
  • Proficiency in SQL for data extraction and analysis from structured data sources.
  • Experience with ETL processes including data cleansing and validation activities.
  • Skilled in developing dashboards and visualizations using Tableau or Power BI.
  • Excellent communication skills for conveying analytical findings to various audiences.
  • Strong attention to detail and organizational skills.

Responsibilities

  • Collect, clean, and prepare data for dashboards and reports from multiple sources.
  • Write SQL queries to analyze and summarize data for reporting needs.
  • Support ETL activities including data quality checks and documentation.
  • Build and maintain datasets for dashboards and reports.
  • Develop reports and visualizations using BI tools like Tableau and Power BI.
  • Respond to stakeholder requests with ad hoc reports and summaries.
  • Collaborate with business analysts to clarify reporting requirements.

Benefits

  • Health, dental, and vision insurance
  • 401K
  • Discretionary PTO
  • Professional development opportunities
  • Dynamic and collaborative work environment
Full Job Description
Position Overview

We are seeking a Data Analyst 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 Data Analyst is detail-oriented, technically capable, and comfortable working with structured data, SQL queries, 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.

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 Tableau, Power BI, and other BI or reporting tools.
  • 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 5 years of experience in data analysis, reporting, business intelligence, dashboard development, or a related analytical role.
  • Bachelor of Science or Bachelor of Arts degree in Data Analytics, Data Science, Information Systems, Finance, Statistics, Mathematics, Computer Science, or an equivalent field.
  • Experience writing SQL queries to extract, join, transform, and analyze data from relational databases or structured data sources.
  • Experience working with multiple data sources and preparing datasets for reporting, dashboards, or business intelligence products.
  • Experience supporting ETL, data cleansing, data validation, and data quality review activities.
  • Experience developing dashboards, reports, and visualizations using Tableau, 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.

Preferred Qualifications:
  • Experience supporting federal clients, particularly federal public safety, law enforcement, homeland security, emergency management, or related mission environments.
  • 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.

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.

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.

Similar Jobs

More Jobs at K.L. Scott & Associates

  • Data Analyst
    $70K — $95K *
    Washington, DC 20011 (District Of Columbia County)
    Information Technology
    In-Person
  • Business Analyst
    $80K — $110K *
    Washington, DC 20011 (District Of Columbia County)
    Business Services
    In-Person
  • Data Analytics Integrator
    $80K — $110K *
    Atlanta, GA 30349 (Fulton County)
    Business Services
    In-Person

More Information Technology Jobs

Find similar Data Analyst jobs: