POSITION DESCRIPTION
We are currently in the process of implementing SAP Datasphere and are seeking a motivated Data Warehouse Specialist Intern to support our team during this exciting transformation. This internship offers a unique opportunity to gain hands-on experience in enterprise data & analytics, while working alongside our Lead Data & Analytics and the Global Business Systems team.
The intern will assist with activities related to data integration, data modeling, testing, reporting, and documentation in support of the global data warehouse and analytics initiatives. This role is ideal for a student with a strong interest in data engineering, data warehousing, and business intelligence.
KEY RESPONSIBILITIES
- Support the implementation of SAP Datasphere by assisting with:
- Data extraction, transformation, and loading (ETL) activities
- Building and validating data models and pipelines
- Testing and troubleshooting integration between ERP and data warehouse
- Assist in creating documentation for data models, processes, and business rules
- Help prepare and maintain reports and dashboards (e.g., Power BI & SAP Analytics Cloud)
- Perform data quality checks and flag issues for resolution
- Research and explore best practices in data warehousing and analytics
- Participate in team meetings and gain exposure to cross-functional collaboration between IT, business users, and external partners
KNOWLEDGE & SKILLS
Required:
- Currently pursuing a Bachelor’s or Master’s degree in Information Technology, Computer Science, Data Analytics, Business, or related field
- Basic understanding of databases, SQL, and data warehousing concepts
- Familiarity with business intelligence tools (e.g., Power BI, Tableau, or similar)
- Strong analytical and problem-solving skills
- Eagerness to learn new technologies and concepts (especially SAP Datasphere)
- Proficiency in Microsoft Office (Excel, Word, PowerPoint, Sharepoint, Teams, …)
- Good written and verbal communication skills
Preferred:
- Exposure to ETL tools or data integration platforms
- Basic knowledge of ERP systems (SAP experience is a plus)
- Interest in data modeling, cloud data platforms, or machine learning
INTERNSHIP BENEFITS
- Hands-on experience with a global SAP Datasphere implementation
- Mentorship from experienced data and analytics & IT professionals
- Exposure to enterprise-scale data engineering and reporting practices
- Opportunity to contribute to real-world projects with measurable business impact
WORKING CONDITIONS
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. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to stand and walk up to 50% of the time. Working conditions include those of a normal construction environment, as well as standard hazards associated with installed HVAC equipment and rotating equipment. This position requires occasional lifting of up to 30 lbs, and travel of 10 - 20% of the time.
BAC Hiring Compensation Range $22 - $28.
BAC provides additional earnings in the form of overtime as applicable under law.
Top Skills
What We Do
At BAC, we don’t just build cooling systems, we shape the future of sustainable solutions. With over 85 years of innovation, we lead the HVAC, industrial, and refrigeration industries in delivering evaporative, hybrid, and dry cooling technologies that power the world’s most demanding environments.
Global Reach | Sustainable Stewardship | Relentless innovation
From data centers to manufacturing plants, our solutions help customers reduce energy use, improve efficiency, and protect the planet. Every day, our 3,000+ employees from our 500+ sales offices and 10 factories globally work side-by-side with partners to deliver smarter, safer, and more sustainable cooling.
We’re proud to be part of Amsted Industries, an employee-owned company that thrives on teamwork, integrity, and enterprise. At BAC, we’re inspired by nature and powered by our people. Founded in 1938, BAC (Baltimore Aircoil Company) is a global leader in sustainable cooling solutions. Our mission is simple yet powerful: to continually advance truly sustainable cooling, inspired by nature and powered by our people, for a world that depends on it to grow, succeed, and thrive.
We serve a wide range of industries, from commercial HVAC and industrial processing to mission-critical data centers, delivering high-performance solutions that balance human and planetary health.
Our Values:
-- Courage
-- Innovation
-- Responsibility
-- Trust
Why Work at BAC?
BAC is more than a workplace, it’s a community. We empower our employees to lead, innovate, and grow. Our culture thrives on collaboration, inclusion, and a shared commitment to sustainability. Whether you're in engineering, marketing, operations, or customer service, your work at BAC makes a global impact.
At BAC, You Can:
-- GROW
-- MAKE AN IMPACT
-- FEEL VALUED
-- BELONG
We are:
-- Employee-owned through Amsted Industries (US only)
-- Globally present with local expertise
-- Leaders in sustainability and innovation
