Trainee Automation Engineer Jobs in Virginia (NOW HIRING)

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, 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.
Collaborate with federal clients, project managers, software developers, data scientists, compliance teams, finance teams, and executive stakeholders.
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.
Ability to work independently as a senior hands-on consultant in a federal client environment.
Strong attention to detail, quality control, and documentation discipline.
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.
Experience with mortgage, financial services, due diligence, asset review, loan file processing, or federal financial reporting.
Experience processing very large document or file volumes under tight deadlines.
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, government reporting systems Certifications Preferred but not required: Microsoft Certified: Power BI Data Analyst, Microsoft Certified: Azure Data Engineer, Microsoft Power Platform App Maker, Microsoft Power Platform Functional Consultant, Microsoft Azure AI Engineer, Security+, ITIL Foundation, Certified Analytics Professional, Lean Six Sigma Green Belt, PMP, CDMP Performance Outcomes
Modernize legacy databases and reporting workflows into scalable SQL Server, Power BI, and Power Platform solutions.
Improve reporting speed, quality, and consistency through automation and reusable data pipelines.
Reduce manual effort in finance, compliance, HR, inspections, and operational reporting.
Deliver executive dashboards and ad hoc analysis that support agency and government-level decision-making.
Identify and resolve data quality issues, workflow bottlenecks, and system inefficiencies.
Enable secure and practical use of AI, automation, and data engineering in sensitive federal environments.
Produce accurate documentation, audit support materials, and client-ready technical deliverables.