Power BI Analyst

American University•Washington, DC

7h•Hybrid

About The Position

The Power BI Analyst will be responsible for analyzing business reporting needs; translating requirements into effective data visualizations; and designing, developing, and maintaining Power BI reports and dashboards that support decision-making and defined business outcomes. The incumbent will collaborate closely with business stakeholders, BI Developers, Data Engineers, and Solution Architects to ensure reporting solutions are accurate, performant, and aligned with enterprise standards. This role is focused on visualization, report development, and semantic model usage within the AU Business Intelligence ecosystem.

Requirements

Bachelor's degree or equivalent.
2 - 4 years of relevant experience in business intelligence, analytics, or related roles.
Demonstrated experience developing reports and dashboards using Microsoft Power BI.
Experience working with enterprise data sources, including relational databases.
Strong understanding of Power BI semantic models and data modeling concepts.
Proficiency in reading and interpreting SQL.
Experience with DAX and report performance optimization techniques.
Understanding of dimensional modeling and data warehousing concepts.
Familiarity with cloud analytics platforms (e.g., Microsoft Fabric, Azure).
Proven ability to translate business requirements into effective visual analytics and dashboards.
Strong attention to data accuracy, quality, and validation practices.
Experience leveraging certified datasets and enterprise semantic models.
Understanding of enterprise BI governance practices, standards, and deployment processes.
Familiarity with software development lifecycle (SDLC) and change management practices.
Ability to assess impact of changes and manage competing priorities.
Excellent communication skills with the ability to engage both technical and non-technical stakeholders.
Experience facilitating requirements discussions and translating business needs into technical solutions.
Ability to develop documentation, training materials, and support end-user adoption.
Proactive, results-oriented mindset with strong problem-solving skills.
Ability to work independently and collaboratively in a fast-paced environment.

Nice To Haves

Experience with Workday reporting and/or higher education data environments.
Exposure to Salesforce reporting.
Experience supporting user training, knowledge sharing, or BI adoption initiatives.

Responsibilities

Work with business units to understand reporting and visualization needs, analyze requirements, and translate business questions into Power BI report designs and user-friendly dashboards.
Participate in feasibility discussions and contribute to level-of-effort estimates for reporting solutions.
Develop and maintain Power BI reports and dashboards that meet defined business outcomes, following established visualization, usability, and accessibility standards.
Utilize certified datasets and semantic models where available and collaborate with BI and Solution Architects to ensure optimal report performance and consistency.
Ensure accuracy, reliability, and data quality of all published BI products.
Support user acceptance testing and iterative enhancement of Power BI reports by gathering feedback, addressing issues, and implementing enhancements or bug fixes.
Assess the impact of requested changes on timelines and scope and escalate risks or conflicts as appropriate.
Ensure adherence to enterprise BI standards, governance practices, and deployment processes.
Provide ongoing support for AU’s business intelligence solutions, including report documentation, training materials, presentations, and one-on-one assistance to end users.
Promote adoption of Power BI through knowledge sharing and best practices.