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.
