Intern - Energy & Sustainability Data Analyst (Power BI Focus)

Would you like to join an international team working to improve the future of healthcare? Do you want to enhance the lives of millions of people? Grifols is a global healthcare company that since 1909 has been working to improve the health and well-being of people around the world. We are leaders in plasma-derived medicines and transfusion medicine and develop, produce and market innovative medicines, solutions and services in more than 110 countries and regions.

Overview

Grifols is seeking a highly motivated Energy & Sustainability Data Analyst Intern with strong analytical skills and a passion for dashboard development. This role is focused on building automated data workflows and Power BI dashboards that support the Environmental Department and the Energy & Sustainability efforts at the Clayton site.

 

The primary goal is to transform raw utility and SCADA data into accurate, actionable insights that help improve energy efficiency, water conservation, and sustainability performance across the facility.

 

Key Responsibilities

Data Automation & Dashboard Integration (Primary Focus)

• Develop an automated data pipeline that performs Extract, Transform, Load (ETL) processing to move information from utility bills, SCADA systems, spreadsheets, and internal reports into structured datasets.
• Extract data from multiple sources (billing systems, SCADA, spreadsheets, manual logs).
• Transform the data by cleaning, validating, merging, formatting, and preparing it using Power Query.
• Load the transformed data into Power BI so dashboards refresh automatically without manual updates.
• Build and maintain Power BI dashboards that visualize real‑time and monthly trends in energy, water, natural gas, and sustainability metrics.
• Implement data quality checks and document workflows for repeatability and long‑term sustainability.

 

Excel / Power Query / ETL Support

• Use Excel and Power Query to structure, clean, and manipulate datasets feeding Power BI.
• Automate routine data imports and transformations to reduce manual effort.
• Ensure data accuracy through systematic checks, comparisons, and validation steps.

 

Energy, Water & Sustainability Support (Secondary Focus)

• Assist with analysis of utility consumption trends and cost drivers.
• Participate in facility walkthroughs to understand equipment, metering points, and operational systems.
• Support the Environmental team’s energy, water, and sustainability initiatives with data‑driven insights.
• Work with subject‑matter experts across the site to understand how utility systems operate and how data reflects real‑world conditions.

 

Documentation & Continuous Improvement

• Create clear documentation for ETL processes, Power BI data models, and dashboard refresh procedures.
• Maintain version control and process notes for transparency and handoff.
• Suggest process improvements that enhance automation, accuracy, or reporting efficiency.

 

Minimum Requirements

• Rising Junior or Senior in:
• Data Analytics / Data Science
• Engineering (any discipline)
• Environmental Science
• Mathematics
• Computer Science
• Or related 4‑year degree program
• GPA of 3.0 or higher required.

 

Required Skills & Qualifications

Technical Skills

• Strong analytical and mathematical reasoning abilities.
• Experience with Power BI preferred, or strong willingness and ability to learn.
• Intermediate‑to‑advanced Excel proficiency (pivots, lookup functions, data cleaning).
• Familiarity with Power Query preferred for data transformation.
• Exposure to scripting languages (R, Python, etc.) is a plus.
• Ability to work with large datasets from multiple sources.

 

Soft Skills

• Strong attention to detail and a methodical approach to problem‑solving.
• Clear communication skills with the ability to simplify complex topics.
• Curiosity and eagerness to learn new Systems (SCADA, metering, utility monitoring).
• Ability to work independently with minimal supervision.

 

What This Internship Offers<