Business Intelligence Engineer (Power BI)

Avanza LLC

Arlington (VA)

Hybrid

USD 120,000 - 150,000

Full time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Competitive salary
Health insurance
401(k) retirement plan
Paid time off

Job summary

Avanza is seeking a Business Intelligence Engineer (Power BI) to design, develop, and support reliable BI solutions for federal clients. This hands-on role requires deep Power BI expertise and a strong data analytics foundation to turn complex data into accurate, decision-driving reports.

The candidate will own BI delivery end-to-end—from data assessment and integration to report development, testing, deployment, and support.

Qualifications

  • Bachelor's degree or equivalent in a related field.
  • 5+ years in data analytics/BI/data engineering or a related field.
  • At least 3 years of hands-on Power BI development.
  • Ability to deliver production BI solutions using data from multiple sources.
  • Strong communication with both technical and non-technical stakeholders.

Responsibilities

  • Translate client questions into reporting requirements, metrics, and designs.
  • Own BI delivery from data assessment to deployment and support.
  • Create intuitive dashboards to help users explore performance.
  • Validate calculations and resolve data-quality issues before release.
  • Monitor production reports, refreshes, and performance; implement enhancements.
  • Collaborate with analysts, data engineers, developers, and consultants.
  • Document data sources, metrics, and business rules; train end users.

Skills

Analytical thinking
Communication

Education

Bachelor's degree or equivalent in CS/IS/Data Analytics/Engineering/Math/Stats

Tools

Power BI
SQL
DAX
Power Query
Dataverse
Azure data services
Git/Azure DevOps
Tabular Editor

Job 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 non-technical 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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Power BI Engineer — Federal Analytics & Dashboards
Senior Power BI Engineer — Federal Analytics & Dashboards

Avanza LLC • Arlington (VA)

Hybrid
USD 120,000 - 150,000
Competitive salary
Health insurance
401(k) retirement plan
+1
Senior Power BI Developer
Senior Power BI Developer

Aver, Llc • Springfield (VA)

Remote
USD 150,000 - 170,000
Health and wellness coverage
Paid time off and holidays
Retirement benefits
+1
Software Developer (Power Platform)
Software Developer (Power Platform)

Avanza • Arlington (VA)

Hybrid
USD 95,000 - 120,000
Healthcare – Medical, Dental, Vision
401(K) Retirement Plan with Employer  
Disability Insurance – Short Term and
+2
Software Developer (Power Platform)
Software Developer (Power Platform)

Avanza LLC • Arlington (VA)

Hybrid
USD 85,000 - 120,000
Healthcare
401K Plan
Disability Insurance
+2
Business Intelligence Data Analyst
Business Intelligence Data Analyst

MAGNUS Management Group • Washington

Remote
USD 90,000 - 130,000
401(k)
Dental insurance
Health insurance
+2
Power BI Developer
Power BI Developer

Andworx, LLC • Washington

Hybrid
USD 120,000 - 180,000
Senior Data & Business Intelligence Analyst
Senior Data & Business Intelligence Analyst

Jobgether • Oregon

Hybrid
USD 90,000 - 130,000
Fully remote work arrangement
PowerBI Developer
PowerBI Developer

Stratacent • Jersey City (NJ)

On-site
USD 100,000 - 130,000
Health Insurance
Vision Plan
Dental Plan
+3
Business Intelligence Consultant
Business Intelligence Consultant

Elios Talent • United States

Remote
USD 120,000 - 150,000
Software Developer (Power Platform, .NET)
Software Developer (Power Platform, .NET)

Avanza • Arlington (VA)

Hybrid
USD 90,000 - 120,000
Healthcare – Medical, Dental, Vision
401(K) Retirement Plan with Employer Contribution
Disability Insurance – Short Term and Long Term
+3