Business Intelligence Engineer (Power BI)

Avanza

Arlington (VA)

Hybrid

USD 90,000 - 130,000

Full time

13 hours 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

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 backed by a strong data analytics foundation to turn complex source data into accurate, high-performing reports.

You will own BI delivery from data assessment through model and report development, testing, deployment, and support; create intuitive dashboards; validate results; and collaborate with analysts,

Qualifications

  • Bachelor's degree or equivalent in a related field.
  • 5+ years in data analytics/BI, including 3+ years hands-on Power BI.
  • 5+ years in data analytics, BI, data engineering, or related field with hands-on Power BI.
  • Strong analytical judgment and attention to detail.
  • Strong communication with technical and non-technical stakeholders.
  • Experience with financial management/budgeting or federal government clients preferred.
  • Advanced Power BI Desktop/Service, semantic model design, report publishing.
  • Advanced DAX and Power Query (M).
  • Strong SQL and relational data skills, including star schemas.
  • Optimize model/report performance with Performance Analyzer, DAX Studio, and diagnostics.
  • Experience administering production BI solutions.
  • Familiarity with Dataverse/Azure data services; PL-300 a plus.

Responsibilities

  • Translate client questions into reporting requirements, metrics, and designs.
  • Own BI delivery from data assessment to deployment and support.
  • Create intuitive dashboards and reports for user exploration and performance understanding.
  • Reconcile results to authoritative sources and validate calculations.
  • Monitor production reports, refreshes, and performance; implement enhancements.
  • Collaborate with analysts, data engineers, developers, and consultants to integrate BI into client processes.
  • Maintain documentation of data sources, metric definitions, and business rules; train end users.

Skills

Analytical thinking
Stakeholder communication
Problem solving
Time management
Attention to detail

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, Statistics, or related field

Tools

Power BI
Power BI Desktop
Power BI Service
DAX
Power Query (M)
SQL
Dataverse
Azure data services
Git/Azure DevOps
Tabular Editor

Job description

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.
  • 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.
  • 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

Business Intelligence Engineer (Power BI)
Business Intelligence Engineer (Power BI)

Avanza LLC • Arlington (VA)

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

Avanza • Arlington (VA)

Hybrid
USD 90,000 - 130,000
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
Software Developer (Power Platform)
Software Developer (Power Platform)

Avanza LLC • United States

Hybrid
USD 95,000 - 125,000
Competitive salary with bonus
Healthcare coverage
401K with employer contribution
+3
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
Senior Power BI Developer
Senior Power BI Developer

AVer Information • United States

Hybrid
USD 150,000 - 170,000
Health benefits
Paid time off
Retirement benefits
+1
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
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
Manager - Financial Management & Analytics
Manager - Financial Management & Analytics

Avanza LLC • Arlington (VA)

Hybrid
USD 150,000 - 190,000
Healthcare – Medical, Dental, Vision
401(K) Retirement Plan with Employer贡献
Disability Insurance – Short/Long Term
+2