Business Intelligence (Power BI) Intern

Dempsey & Siders Agency•Cincinnati, OH

About The Position

The Business Intelligence (BI) Intern will support the Data team in the development, maintenance, and enhancement of business intelligence solutions using Microsoft Power BI. This role provides hands-on experience working with enterprise data, creating interactive dashboards, developing reports, and helping business users gain insights through data visualization and analytics. The intern will collaborate with BI developers, data engineers, database administrators, and business stakeholders to deliver reporting solutions that support data-driven decision-making.

Requirements

Experience with Microsoft Power BI
Experience with data modeling and relationships
Experience with Power Query and DAX
Experience with dashboard and report design best practices
Experience with enterprise data governance and reporting standards
Experience working with SQL Server, Oracle, and cloud-based data sources
Experience with Agile project delivery and stakeholder engagement

Responsibilities

Assist in the design, development, and testing of Power BI reports and dashboards.
Create and maintain visualizations, KPIs, scorecards, and operational reports.
Support data preparation activities, including data cleansing, transformation, and validation.
Develop and modify Power Query transformations and basic DAX calculations.
Work with SQL-based data sources, data warehouses, and enterprise reporting platforms.
Participate in gathering business requirements and translating them into reporting solutions.
Help document report specifications, data definitions, and development standards.
Perform report testing and quality assurance to ensure accuracy and consistency.
Assist with report deployment, workspace management, and user support activities.
Collaborate with team members to identify opportunities to improve reporting processes and data accessibility.
Participate in Power BI training, knowledge-sharing sessions, and analytics team projects.