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

• Hands‑on experience building real operational Power BI dashboards used by engineering and environmental teams.
• Exposure to industrial pharmaceutical utility systems and large‑scale sustainability initiatives.
• Structured training with engineers and SMEs.
• A strong portfolio of analytics and automation work.
• Direct impact on energy efficiency, cost reduction, and environmental performance.

Third Party Agency and Recruiter Notice:

Agencies that present a candidate to Grifols must have an active, nonexpired, Grifols Agency Master Services Agreement with the Grifols Talent Acquisition Department. Additionally, agencies may only submit candidates to positions that they have been engaged to work on by a Grifols Recruiter. All resumes must be sent to a Grifols Recruiter under these terms or they will be considered a Grifols candidate.

Grifols provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.  We will consider for employment all qualified applicants in a manner consistent with the requirements of all applicable laws.

Location: NORTH AMERICA : USA : NC-Clayton:USNC0002 - Clayton 

Learn more about Grifols