Data Analyst: Federal Dashboards & Insights

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

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.