Enterprise Data Analyst Intern, Power BI & Data Quality (Summer 2027)

Job description

Job responsibilities

• Supports validation of data as pipelines are modernized, comparing outputs between existing and new sources (row counts, totals, and key metrics) and documenting discrepancies
• Tests Power BI reports after dataset changes to confirm figures remain accurate, and logs results
• Documents KPI definitions, business logic, and DAX measures in a central reference to support a governed, single-source-of-truth metrics layer
• Builds and maintains a data dictionary covering tables, fields, grain, and source mappings
• Reviews data quality exception reports, identifies recurring patterns, and summarizes findings for the team
• Develops Power BI dashboards or report pages for internal stakeholders using approved data models, under review by a senior team member
• Supports user acceptance testing by writing test cases and coordinating feedback from business users
• Presents a summary of work to the team and IT leadership at the end of the internship

Job requirements

• Rising Junior, Senior, or Graduate student (MS/MA or Ph.D.) pursuing a degree in Management Information Systems, Computer Science, Data Science, Statistics, Mathematics, Engineering, Business Analytics, or a related…
• Cumulative GPA of 3.0 or higher
• Coursework or project experience with SQL (joins, aggregations, filtering)
• Working knowledge of Excel (pivot tables, formulas); VBA is a plus
• Exposure to Power BI or a similar tool such as Tableau, through coursework or personal projects
• Strong attention to detail and a habit of checking your own work
• Ability to handle confidential information with discretion
• Familiarity with Python, DAX, cloud data platforms (AWS), or Agile practices preferred