Intern, Energy Data Analyst

Dairyland Power; La Crosse (WI); Hybrid; USD 34,000 - 49,000; Full time

Benefits offered by this job

Driver's license

Job summary

Dairyland Power Cooperative in La Crosse, WI invites an Energy Data Analyst Intern to turn energy and business data into clear, actionable reports. You will build dashboards and data models to support strategic decisions and report on performance and trends.

The role emphasizes Power BI development, data visualization best practices and collaboration with business partners to translate questions into analytical products. Internship is on site with travel as needed.

Qualifications

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

Responsibilities

• Design, build and maintain interactive dashboards/scorecards for energy, financial and operational analysis.
• Develop clear, effective data visualizations that help technical and nontechnical users understand trends, performance drivers and business results.
• Create and maintain Power BI semantic models using STAR schema and dimensional modeling principles.
• Connect, clean, transform and organize diverse datasets of structured and unstructured data from multiple sources.
• Develop DAX measures, calculated columns and key performance indicators that accurately reflect business definitions and reporting requirements.
• Work with staff and other business partners to gather reporting requirements and translate business questions into practical analytical products.
• Review and validate reports, calculations and source data to ensure accuracy, consistency and reliability.
• Identify trends, variances and unusual results in energy and business data and clearly communicate relevant findings.
• 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.

Skills

Power BI

Data visualization

Relational data

Data analysis

Data accuracy

Analytical skills

Communication skills

Requirements gathering

Confidential information handling

Independent work

Education

Pursuing data analytics degree

Tools

SQL

Relational databases

STAR schema

Power BI modeling

Job description

Hourly Wage: $30.00 Must be on site in La Crosse, WI

PURPOSE

The Energy Data Analyst Intern will support strategic decision-making by transforming energy and business data into clear, accurate and useful reports. This position will develop data models, dashboards and visualizations that help DPC understand performance, identify trends and make informed decisions. The position advances DPC’s strategic priorities, particularly financial strength, growth and innovation and our safety culture.

ESSENTIAL JOB FUNCTIONS

• Design, build and maintain interactive dashboards/scorecards for energy, financial and operational analysis.
• Develop clear, effective data visualizations that help technical and nontechnical users understand trends, performance drivers and business results.
• Create and maintain Power BI semantic models using STAR schema and dimensional modeling principles.
• Connect, clean, transform and organize diverse datasets of structured and unstructured data from multiple sources.
• Develop DAX measures, calculated columns and key performance indicators that accurately reflect business definitions and reporting requirements.
• Work with staff and other business partners to gather reporting requirements and translate business questions into practical analytical products.
• Review and validate reports, calculations and source data to ensure accuracy, consistency and reliability.
• Identify trends, variances and unusual results in energy and business data and clearly communicate relevant findings.
• 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

• Experience developing reports or dashboards in Microsoft Power BI
• Understanding effective data visualization practices
• 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 using DAX to create measures, calculations and key performance indicators
• Knowledge of STAR schema, dimensional modeling and Power BI semantic model design
• Experience with SQL and relational databases
• 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.

With headquarters in La Crosse, Wis., Dairyland is a generation and transmission cooperative that provides wholesale energy for 24 electric distribution cooperatives and 17 municipal utilities in Wisconsin, Minnesota, Iowa and Illinois. At Dairyland, we know that happy employees are the backbone of any good organization. By offering an excellent compensation and benefits package, opportunities for career growth and a supportive environment, Dairyland helps ensure a quality business and premier workplace.