Avanza LLC

Business Intelligence Engineer (Power BI)

Avanza LLC Arlington County, Virginia, United States · $100K–$120K/yr

Business Consulting and Services · 2-10 employees

Nov 10
business-intelligence Senior (5-10 yrs) Full-time United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

Translate client questions into reporting requirements, metrics, and solution designs, then deliver BI solutions from source-data integration through modeling, report development, testing, deployment, and support. Validate results and data quality, troubleshoot production reports and refreshes, optimize performance, document solutions, and collaborate with stakeholders while supporting and training end users.

What they look for

Power BI DAX Power Query SQL Data Modeling Dashboard Development Data Integration Performance Optimization Data Quality Validation Power BI Service Administration Row-Level Security Scheduled Refresh and Gateways Stakeholder Communication Requirements Analysis Production Support Financial Management

Requirements

A bachelor's degree in a relevant field or equivalent experience is required, along with at least five years of relevant professional experience, including three or more years of hands-on Power BI development. Candidates should have advanced Power BI, DAX, and Power Query skills; strong SQL and data-modeling expertise; experience delivering and supporting production BI solutions; and effective analytical and communication skills.

Benefits

Performance Bonus Medical Insurance Dental Insurance Vision Insurance 401(k) Retirement Plan With Employer Contribution Short-Term Disability Insurance Long-Term Disability Insurance Group Life Insurance Accidental Death and Dismemberment Insurance Paid Vacation Paid Sick Time Professional Growth and Advancement Opportunities

Full description

Job Summary

Avanza is seeking a Business Intelligence Engineer (Power BI) to design, develop, and support reliable business intelligence solutions for our federal clients. This hands-on position requires deep Power BI expertise backed by a strong foundation in data and analytics. The successful candidate can turn complex source data and ambiguous business questions into accurate, high-performing reports that clients trust for decision-making.

Responsibilities

  • Translate client questions into clear reporting requirements, performance metrics, and solution designs.
  • Own delivery of BI solutions 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; 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.

Qualifications

  • Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, Statistics, or a related field; equivalent relevant experience will be considered.
  • 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.
  • Experience with financial management, budgeting, or federal government clients is preferred, not required.

Microsoft Power BI & Analytics Engineering Skills

  • Advanced proficiency with Power BI Desktop and Power BI Service, including semantic model design, report authoring, publishing, and sharing.
  • Advanced DAX skills (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.
  • Familiarity with Dataverse, Microsoft Fabric, Azure data services, Git/Azure DevOps, or Tabular Editor is a plus; Power BI Data Analyst Associate (PL-300) certification is also a plus.

Work Authorization Requirement

  • Due to federal contract requirements, applicants must be U.S. citizens or lawful permanent residents.

Location

  • This is a hybrid role. Employees must reside within a commutable distance of our headquarters in Arlington, VA.

Benefits

  • Competitive salary, performance bonus, and benefits package.
  • Healthcare - Medical, Dental, Vision
  • 401(k) Retirement Plan with Employer Contribution
  • Disability Insurance - Short Term and Long Term
  • Group Life Insurance including Accidental Death & Dismemberment
  • Paid Time Off (PTO) - Vacation and Sick Time
  • Opportunity to work on high-impact analytics, automation, and emerging technology initiatives.
  • Work in a fast-paced and dynamic environment with a talented team.
  • Professional growth and advancement opportunities.

About Us

Avanza is a premier management consulting firm that excels in transforming organizational performance through the strategic application of AI and deep expertise in Organizational Management, Financial Management, and Information Technology.

Our culture is rooted in fostering an environment characterized by clear, candid communication, meticulous attention to detail, a proactive and hands-on approach to challenges, a steadfast commitment to service excellence, and a focus on delivering tangible results for our clients. Our ambition is clear: to emerge as the leader in Organizational Performance Transformation. We are dedicated to steering our clients through their evolution, driving progress, and delivering outcomes that matter.

Similar roles