Business Analyst Intern

Dairyland Power Cooperative; La Crosse (WI); On-site; USD 21,000 - 30,000; Full time

Job summary

Dairyland Power Cooperative seeks a Business Analyst Intern to transform business data into accurate reports, dashboards, and scorecards. You will prepare data, develop KPIs, validate reports, analyze processes, and document insights to drive strategic priorities.

The role involves presenting findings to both technical and nontechnical audiences, ensuring data accuracy, and supporting project planning in a collaborative environment. Travel may be required.

Qualifications

• Pursuing undergraduate or graduate degree in data analytics, information systems, business analytics, data science, statistics, or related field.
• Strong data visualization foundations and ability to present insights clearly.
• Experience or coursework in transforming data into dashboards and reports.

Responsibilities

• Design, build and maintain interactive scorecards & dashboards for cross functional partners.
• Develop clear, effective data visualizations to convey trends and performance.
• Connect, clean, transform, and organize data from multiple sources.
• Develop DAX measures and calculated columns for KPIs.
• Conduct business process analysis to identify improvements.
• Validate reports, calculations, and source data for accuracy.
• Assist in project planning and execution aligned with business goals.
• Create and maintain documentation for data sources and calculations.
• Present dashboards and findings to technical and nontechnical audiences.
• Perform other duties as assigned.

Skills

Data visualization

Relational data understanding

Data analysis

Attention to detail

Analytical skills

Verbal communication

Written communication

Requirements gathering

Independent work

Education

Undergraduate or graduate degree in data analytics / information systems / business analytics / data science

Tools

Power BI

Power Query (M)

DAX

Excel

Job description

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, recognize trends and communicate findings clearly
• Strong attention to detail and commitment to data accuracy
• Strong analytical, problem-solving and organizational skills
• Strong verbal, written and interpersonal communication skills
• Ability to gather requirements and work with individuals from varied technical and business backgrounds
• Ability to manage confidential information
• Ability to work independently with guidance and manage multiple priorities

PREFERRED QUALIFICATIONS

• Experience developing reports or dashboards in Microsoft Power BI
• Experience with Power Query (M) in Excel or Power BI
• Experience using DAX in Power BI to create measures and calculations
• Understanding of report performance optimization, row-level security and Power BI publishing practices

LICENSES AND CERTIFICATIONS

Valid Driver's License

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to stand; walk; use hands to finger, handle or feel; and reach with hands and arms.

ENVIRONMENTAL DEMANDS

Normal work schedule is indoors.

OTHER JOB CHARACTERISTICS

Travel required, occasionally overnight. Works with limited supervision in a variably paced, variable pressure setting. Handles multiple priorities.