AITHERAS, LLC

Senior Data Analytics BI Engineer

Arlington, VA
Full Time
Experienced

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

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.

Share

Apply for this position

Required*
We've received your resume. Click here to update it.
Attach resume or Paste resume
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Voluntary Self-Identification of Disability
Voluntary Self-Identification of Disability Form CC-305
OMB Control Number 1250-0005
Expires 05/31/2026
Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Please check one of the boxes below:

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

You must enter your name and date
Human Check*