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: 812 years

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 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.

Required Qualifications

• 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.

Preferred Qualifications

• 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.

Tools / Technologies

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.