Data Analyst III Security Clearance

Position: Performance/Data Analyst III with Security Clearance
Job Description:

Senior Data Analytics BI Engineer
Title Senior Data Analytics BI Engineer Location Washington, DC Metro / Hybrid / Federal Client Site as Required Clearance / Background U.S. citizenship required. Active federal clearance or ability to obtain Public Trust/Secret clearance preferred. Experience Level 8–12+ years of experience in data analytics, BI engineering, data engineering, software development, database modernization, reporting automation, and federal client delivery. Role Summary AITHERAS is seeking a Senior Data Analytics BI Engineer to support federal agency data modernization, business intelligence, compliance, reporting automation, and database transformation initiatives.

This role requires a senior hands-on technologist who can work directly with federal stakeholders, analyze complex legacy systems, modernize databases and workflows, build dashboards, automate reporting, and deliver practical data solutions across operational, finance, compliance, HR, and executive reporting environments. The ideal candidate combines BI engineering, data engineering, software development, workflow automation, database auditing, and federal consulting experience. This person should be comfortable analyzing hundreds of database tables and thousands of fields, identifying bottlenecks, migrating legacy MS Access solutions to SQL Server, building Power BI dashboards, automating reporting workflows, and supporting decision-makers at agency and government levels.

Key Responsibilities
Support federal agency data analytics, BI engineering, reporting automation, and database modernization initiatives.
Serve as a senior technical consultant to agency stakeholders, including Chief Data Officer teams, inspections, compliance, finance, HR, and operational departments.
Analyze, audit, and document complex legacy data environments with hundreds of database tables, thousands of fields, and multiple downstream reporting workflows.
Review existing databases, applications, workflows, and business processes to identify bottlenecks, data quality issues, modernization opportunities, and process improvements.
Design, build, and maintain Power BI dashboards, semantic models, datasets, measures, reports, and executive-facing visual analytics.
Develop and support SQL Server databases, queries, stored procedures, views, data models, and migration plans.
Lead migration of MS Access databases to SQL Server and support modernization of legacy frontends using Power Apps or similar low-code platforms.
Build automated ETL, data integration, file import, and reporting workflows that can be configured and maintained by end users where appropriate.
Support data scientists with AI data pipelines, ETL tasks, automated reporting, and data preparation workflows.
Automate ad hoc and recurring reports for agency decision-makers, finance teams, compliance teams, and government leadership.
Develop forecasting and rules-based automation solutions for scheduling, workload planning, HR medical exam tracking, and operational planning.
Automate finance risk assessment reports by merging manual and automated data inputs into repeatable reporting processes.
Enhance finance training reporting by tracking training statistics, trainee progress, compliance status, and reporting trends.
Digitize compliance documents and convert unstructured or semi-structured content into quantifiable data for analysis and decision-making.
Extract data from government-level reports and reconcile results against internal systems.
Build dashboards and workflow tools that support automated task assignment, data review, data entry, and data correction processes.
Develop secure proof-of-concept AI and generative AI solutions, including local/offline AI model API services for sensitive or disconnected data environments.
Create databases and tools for document management, automated quality control, deliverable tracking, project reporting, and compliance monitoring.
Support NIST cybersecurity compliance documentation, review, and evidence-gathering activities.
Produce Section 508-compliant reports, spreadsheets, dashboards, and client deliverables.
Automate financial, mortgage,…