Business Intelligence Engineer (Power BI)

Avanza LLC•Arlington, VA
•$100,000 - $120,000•Hybrid

About The Position

Avanza is seeking a Business Intelligence Engineer to design, develop, and support reliable business intelligence solutions for federal clients. This hands-on role requires deep Power BI expertise and a strong foundation in data and analytics. The successful candidate will turn complex source data and ambiguous business questions into accurate, high-performing reports that clients can trust for decision-making. The role owns BI solution delivery from source-data assessment and integration through semantic modeling, report development, testing, deployment, and ongoing support. It includes validating reporting results against authoritative sources, resolving data-quality issues, monitoring production performance, and helping users understand and use reporting solutions. The position works with analysts, data engineers, developers, and consultants to integrate BI solutions into client processes. This is a hybrid role. Employees must live within commuting distance of Avanza's headquarters in Arlington, Virginia. Due to federal contract requirements, applicants must be U.S. citizens or lawful permanent residents.

Requirements

  • Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, Statistics, or a related field; equivalent relevant experience will be considered.
  • At least 5 years of professional experience in data analytics, business intelligence, data engineering, or a related field, including at least 3 years of substantial hands-on Power BI development.
  • Demonstrated ability to independently deliver and support production BI solutions using complex data from multiple sources.
  • Strong analytical judgment and attention to detail, including the ability to question assumptions, investigate anomalies, and explain findings.
  • Strong written and verbal communication skills and the ability to work effectively with technical and nontechnical stakeholders.
  • Advanced proficiency with Power BI Desktop and Power BI Service, including semantic model design, report authoring, publishing, and sharing.
  • Advanced DAX skills, including measures, filter context, time intelligence, and efficient calculations, and proficiency with Power Query (M).
  • Strong SQL and relational data skills, including dimensional/star-schema modeling, data granularity, relationships, and integration of databases, Excel, SharePoint, and API-based sources.
  • Ability to optimize model and report performance using techniques and tools such as Performance Analyzer, DAX Studio, query diagnostics, and appropriate storage and refresh strategies.
  • Experience administering production solutions, including workspaces, scheduled refresh, gateways, row-level security, access permissions, and deployment practices.
  • Must be a U.S. citizen or lawful permanent resident due to federal contract requirements.
  • Must reside within a commutable distance of the headquarters in Arlington, Virginia.

Nice To Haves

  • Experience with financial management, budgeting, or federal government clients.
  • Familiarity with Dataverse, Microsoft Fabric, Azure data services, Git/Azure DevOps, or Tabular Editor.
  • Power BI Data Analyst Associate (PL-300) certification.

Responsibilities

  • Translate client questions into clear reporting requirements, performance metrics, and solution designs.
  • Own BI solution delivery from source-data assessment and integration through model and report development, testing, deployment, and support.
  • Create intuitive, accessible dashboards and reports that help users explore information and understand performance.
  • Reconcile reporting results to authoritative sources, validate calculations, investigate discrepancies, and resolve data-quality issues before release.
  • Monitor and troubleshoot production reports, refreshes, and performance, and implement enhancements as business needs evolve.
  • Collaborate with analysts, data engineers, developers, and consultants to resolve dependencies and integrate BI solutions into client processes.
  • Maintain documentation of data sources, metric definitions, business rules, and changes.
  • Support and train end users.

Benefits

  • Competitive salary.
  • Performance bonus.
  • Benefits package.
  • Medical, dental, and vision healthcare.
  • 401(k) retirement plan with employer contribution.
  • Short-term and long-term disability insurance.
  • Group life insurance, including Accidental Death & Dismemberment.
  • Paid time off, including vacation and sick time.
  • Opportunity to work on high-impact analytics, automation, and emerging technology initiatives.
  • Professional growth and advancement opportunities.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service