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 re