Job Specifications
We Make Life More Rewarding and Dignified
Location: Libertyville
Department: Information Technology
Summary
Embark on a hands-on journey in cloud data and analytics as our Summer 2026 Cloud Data Engineering Intern. In this internship based in Libertyville, IL, you will join Hollister's Data Platforms & AI team to help build and optimize the next generation of our cloud data architecture. You'll work with a modern tech stack - Microsoft Azure, Microsoft Fabric, SAP Datasphere, and Power BI - to integrate and transform enterprise data into actionable insights.
From day one, you will contribute to key data initiatives: connecting data from core systems (like SAP) into our Azure analytics environment, developing robust data pipelines, and creating impactful visualizations to drive business decisions. This role offers a blend of engineering and analytics: you'll get to write data transformations and also see the "why" behind the numbers by collaborating with business teams using the dashboards you help create. Both undergraduate and master's students who are passionate about cloud data technologies are encouraged to apply.
For this opportunity, the expectation is to be onsite a minimum of 4 days per week in the Libertyville, IL office.
Responsibilities
Build & Manage Data Pipelines: Design, develop, and test data pipelines for integrating data from various sources (including enterprise SAP systems) into our Azure-based data platform. You will work with tools like Azure Data Factory or Fabric's data integration features to ingest and transform data, ensuring pipelines are reliable and efficient. For instance, you might help configure a data flow that pulls data from SAP Datasphere into a Fabric Lakehouse, enabling advanced analytics on previously siloed data.
Data Transformation & Modeling: Assist in cleansing and transforming raw data into analytics-ready datasets. This could involve writing SQL queries or Python scripts to combine and aggregate data, and helping to define data models (e.g., star schemas) for our cloud data warehouse. You'll learn to optimize queries and transformations for performance, especially within the Azure Synapse and Fabric environments.
Dashboard & Report Development: Collaborate with data analysts to develop and refine Power BI dashboards and reports for various business teams. You'll connect Power BI to cloud datasets, create data visualizations, and iteratively improve them based on user feedback. A key project might be supporting a dashboard for a department like marketing or finance, where you'll ensure the data is accurate and visuals clearly convey insights (such as trends in sales or operational metrics).
Support Data Architecture Initiatives: Work closely with senior engineers on cloud data architecture projects. This might include contributing to the design of our Microsoft Fabric environment - e.g., setting up OneLake storage, configuring workspaces, or evaluating new Fabric components for enterprise use - as well as exploring ways to integrate or migrate legacy data systems (like SAP BW) into the modern platform. You'll gain exposure to architectural decision-making and learn how different components (storage, compute, integration, visualization) fit together in a cohesive data ecosystem.
Data Quality & Governance: Help implement data quality checks and governance practices. For example, you may assist in monitoring data pipeline runs and validating the data outputs, or in setting up rules/alerts for data freshness and accuracy. You'll also learn about our data governance standards - such as using consistent naming conventions, data cataloging, and cloud resource tagging policies. In fact, our team emphasizes practices like tagging Azure resources for cost tracking; you might analyze usage logs or tag metadata to support our FinOps (cloud financial management) efforts.
Collaboration & Troubleshooting: Participate in daily team stand-ups and project meetings to align on tasks. Work alongside seasoned data engineers and architects, both locally and in our global offices, to troubleshoot issues and optimize solutions. If a pipeline fails or a dashboard query is slow, you'll be involved in diagnosing the problem (perhaps checking Azure logs or tweaking a data model) and proposing fixes. This collaboration will enhance your problem-solving skills and give you experience with agile project methodologies.
Research & Innovation: Stay curious and bring new ideas! You will be encouraged to research emerging tools or techniques in cloud data engineering. This could mean trying out a new feature in Azure or Fabric, exploring functionalities of SAP Datasphere, or even evaluating a third-party data tool. If you discover improvements - say a faster way to load data or a useful analytics function - you'll have the chance to demo it to the team and potentially incorporate it into our processes.
Documentation & Training: Maintain clear documentation of your work, including pipeline d
About the Company
Hollister Incorporated is an independent, employee-owned company that develops, manufactures, and markets healthcare products and services worldwide. Our Mission is to make life more rewarding and dignified for people who use our products and services. Throughout the company, there is the recognition that Hollister is unique, not only as an independent, employee-owned company but also in its Mission and its commitment to The Immutable Principles on which the company was founded. Through a shared affirmation that every human ...
Know more