K.L. Scott & Associates
Senior Data Analyst
Washington, D.C · Senior
Sponsorship not specifiedDetected 36 days ago
PythonBashData StructuresSQLPandasNumPyData AnalysisData EngineeringData VisualizationStatisticsFinancial ModelingAccountingForecastingLeadershipCommunicationProblem Solving
About the role
- The ideal candidate will reside in or within commutable distance to Washington DC.
- 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.
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.
- 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.
- 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.
- 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.
- Support user acceptance testing, dashboard validation, defect resolution, and stakeholder feedback cycles.
Requirements
- 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 five years of experience in finance or accounting
- Experience in statistical modeling and financial forecasting (linear regression/logical regression/time series forecasting)
- Experience with business intelligence tools, data visualization concepts, dashboard design, and reporting best practices.
- Ability to conduct complex data analysis and communicate findings clearly to client leadership and technical teams.
- Strong written and verbal communication skills, including the ability to explain data concepts to non-technical stakeholders.
- Strong problem-solving skills, attention to detail, and ability to work in a fast-paced, client-facing environment.
- Must be in-person in Washington, D.C. 5 days a week.
Nice to have
- Experience supporting federal clients, particularly federal public safety, law enforcement, emergency management, homeland security, or related mission environments.
- Expert in Python, SQL, and Power BI DAX
- Expert in financial modeling and forecasting
- Expert in ETL/ELT processes
- Expert in BASH commands and PowerShell
- Experience working in government consulting, federal data modernization, or mission analytics environments.
- Experience with additional BI, reporting, or analytics tools beyond Tableau and Power BI.
- Experience with dashboard performance optimization, data governance, data quality frameworks, or data management best practices.
Skills
- Advanced analytical thinking and ability to connect data findings to mission and business decisions.
- Expert in Python, SQL, DAX, ETL/ELT, dataset development, dashboarding, and data visualization skills.
- Strong stakeholder engagement and presentation skills.
- Ability to mentor analysts and promote consistent analytical standards.
- High attention to detail and commitment to data quality, documentation, and repeatable analytical methods.
Compensation
- Competitive salary
Benefits
- Health, dental, and vision insurance
- "Discretionary" PTO
Equal opportunity
- K.L. Scott & Associates is committed to diversity and inclusion and welcomes candidates from all backgrounds and experiences to apply.
Apply directly at K.L. Scott & Associates →Create a free account for alerts like thisView K.L. Scott & Associates immigration profile
This listing is sourced directly from K.L. Scott & Associates's careers page and normalized into a canonical job model.