Business Analyst Intern

PURPOSE: The Business Analyst Intern supports strategic decision-making by transforming business data into accurate, actionable reports, dashboards, scorecards, and other visualizations. This role will assist with data preparation, key performance indicator (KPI) development, report validation, process analysis, documentation, and communication of insights to help Dairyland identify trends, improve performance, and advance strategic priorities.

ESSENTIAL JOB FUNCTIONS

• Design, build and maintain interactive scorecards & dashboards for cross functional partners.
• Develop clear, effective data visualizations that help technical and nontechnical users understand trends, performance drivers and business results.
• Connect, clean, transform and organize diverse datasets of structured and unstructured data from multiple sources.
• Develop DAX measures, calculated columns to create key performance indicators that accurately reflect business definitions and reporting requirements.
• Conduct business process analysis, identifying areas for improvement.
• Review and validate reports, calculations and source data to ensure accuracy, consistency and reliability.
• Assist in the planning and execution of projects, ensuring alignment with business goals.
• Create and maintain documentation for data sources, business definitions, calculations, report logic and user instructions.
• Present completed dashboards and analytical findings to technical and nontechnical audiences.
• Perform other duties as assigned.

MINIMUM QUALIFICATIONS

Education & Experience: Currently pursuing either an undergraduate or graduate degree in data analytics, information systems, business analytics, data science, statistics, or another related field.

Skills

• Foundational knowledge of effective data visualization practices, including chart selection, layout, labeling and visual hierarchy
• Foundational knowledge of relational data, data tables and relationships
• Ability to analyze data,