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 preferred
Experience Level: 8–12 years

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.

• 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, compliance, and operational data workflows, including large-scale file processing and data validation
• Build integrations with enterprise financial systems such as Deltek or similar platforms
• Perform continuous data analysis, issue resolution, root cause analysis, and recommendations for system, data, and reporting improvements
• Prepare technical documentation, workflow documentation, user guides, process maps, and client-ready analytical summaries

• 8 years of experience in data analytics, BI engineering, database development, software development, data engineering, or federal reporting automation
• Experience supporting federal government agencies, federal contractors, or regulated public-sector environments
• Strong experience with Power BI dashboard development, data modeling, DAX, Power Query, report design, and BI publishing workflows
• Strong SQL Server experience, including database design, querying, stored procedures, views, optimization, and data migration
• Experience modernizing legacy MS Access databases, including migration to SQL Server or similar enterprise database platforms
• Experience building automated ETL workflows, file imports, data transformations, and recurring reporting pipelines
• Experience auditing complex databases, applications, and workflows to assess data quality, bottlenecks, usability, and modernization needs
• Experience supporting finance, compliance, inspections, HR, operations, risk, or executive reporting functions
• Experience developing automated reports, dashboards, Excel-based tools, and decision-support products for senior stakeholders
• Ability to analyze large-scale data environments with many tables, fields, business rules, and downstream dependencies
• Experience translating manual processes into automated workflows, applications, dashboards, or configurable end-user tools
• Experience documenting data structures, business rules, technical workflows, system dependencies, and reporting logic
• Strong client-facing communication skills with the ability to gather requirements, explain technical findings, and recommend practical solutions

• Prior experience supporting DEA, DOJ, DHS, HUD, FHA, federal law enforcement, federal finance, or federal compliance programs
• Experience working with Chief Data Officer, compliance, inspections, finance, HR, or executive reporting teams
• Experience with Power Apps, Power Automate, SharePoint, Microsoft Dataverse, Microsoft Fabric, Azure, or Microsoft 365 government environments
• Experience with Python, R, VBA, C#, .NET, JavaScript, or other automation/software development languages
• Experience with AI/ML data pipelines, data preparation for data science teams, or generative AI proof-of-concept development
• Experience developing secure local/offline AI solutions for sensitive data environments
• Experience with document digitization, OCR workflows, document management, data scraping, and automated reconciliation
• Experience with Deltek or other federal contractor financial systems
• Experience with NIST cybersecurity compliance, data security documentation, or federal IT control reviews
• Experience creating Section 508-compliant Excel reports, dashboards, or federal deliverables
• Active Public Trust, Secret, or higher clearance

Power BI, SQL Server, MS Access, Power Apps, Power Automate, Excel, VBA, SQL, ETL tools, Power Query, DAX, SharePoint, Microsoft 365, Microsoft Dataverse, Python, R, APIs, generative AI platforms, local/offline AI models, document management tools, data scraping tools, Deltek, NIST documentation tools, Section 508-compliant reporting tools, and government reporting systems.