Business Intelligence Engineer (Power BI)

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.