INTERNSHIP DETAILS
Engineering Intern - Business Technology Operations (Foundational PIM)
Company ALO
LocationBeverly Hills
Work ModeOn Site
PostedJanuary 31, 2026

Internship Information
Core Responsibilities
Interns will partner with Tech, Business, and downstream application teams to define the vision and requirements for a centralized Product Information Management solution. They will also design and implement a foundational PIM data model and build data pipelines to ensure product attributes are reliable and accessible.
Internship Type
full time
Salary Range
$45 - $50
Company Size
5249
Visa Sponsorship
No
Language
English
Working Hours
40 hours
Apply Now →
You'll be redirected to
the company's application page
About The Company
We are ALO. We inspire mindful movement, wellness, and taking the consciousness of physical practice and meditation into the world - this is the real studio to street.
We make technologically advanced activewear, scientifically forward, clean beauty & wellness solutions, and igniting movement & mindfulness content to bring more mind-body wellness to the world.
Alo stands for Air, Land, Ocean. Behind everything we do is the intention to protect and respect our planet's resources with solar power and sweatshop-free, eco-aware production, our non profit has brought yoga and mindfulness to millions.
Alo is a feeling. We see a tomorrow where the pursuit of happiness starts with one intentional breath, where health is wealth and where joining together to lift each other up changes the vibration of the world.
About the Role
<div class="content-intro"><p><strong>WHY JOIN ALO?</strong></p>
<p>Mindful movement. It’s at the core of why we do what we do at ALO—it’s our calling. Because mindful movement in the studio leads to better living. It changes who yogis are off the mat, making their lives and their communities better. That’s the real meaning of studio-to-street: taking the consciousness from practice on the mat and putting it into practice in life.</p></div><p><strong>OVERVIEW</strong></p>
<p><span data-contrast="auto">We are seeking a motivated and technically strong </span><span data-contrast="auto">Computer Science Intern – Product Information Management (PIM)</span><span data-contrast="auto"> to join our Biz Tech Operations team. This internship offers a unique opportunity to design and build a </span><span data-contrast="auto">foundational Product Information Management (PIM) capability</span><span data-contrast="auto"> that will serve as a single, trusted source of product data across ALO’s technology ecosystem.</span><span data-ccp-props="{}"> </span></p>
<p><span data-contrast="auto">Today, product information is distributed across multiple systems—including </span><span data-contrast="auto">NGC PLM, FDM4 ERP, FDM4 WMS, Shopify</span><span data-contrast="auto">, and spreadsheets—resulting in duplicated integrations, inconsistent data, and manual workarounds. As an intern, you will help design and implement a centralized PIM solution built on ALO’s </span><span data-contrast="auto">data lake (Amazon Redshift)</span><span data-contrast="auto"> and supporting data pipelines, enabling all downstream systems, services, and teams to reliably source product data from a single platform.</span><span data-ccp-props="{}"> </span></p>
<p><span data-contrast="auto">This work will create a scalable foundation that can be expanded over time with additional product attributes, governance, and automation to support ALO’s continued growth and tech environment expansion.</span></p>
<p><span data-ccp-props="{}">The ALO internship programs starts June 8th and ends July 31st. Interns will be working 40 hours a week at our Beverly Hills HQ.</span></p>
<p><strong>RESPONSIBILITIES </strong><em> </em></p>
<ul>
<li><span data-contrast="auto">Partner with Tech, Business, and downstream application teams to help define the </span><span data-contrast="auto">vision, scope, and requirements</span><span data-contrast="auto"> for a centralized Product Information Management (PIM) solution</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto">Design and implement a </span><span data-contrast="auto">foundational PIM data model</span><span data-contrast="auto"> that consolidates product data from multiple enterprise systems, including:</span><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"> </span>
<ul>
<li data-leveltext="o" data-font="Courier New" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":1440,"335559991":360,"469769226":"Courier New","469769242":[9675],"469777803":"left","469777804":"o","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="2"><span data-contrast="auto">PLM</span><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"> </span></li>
<li data-leveltext="o" data-font="Courier New" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":1440,"335559991":360,"469769226":"Courier New","469769242":[9675],"469777803":"left","469777804":"o","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="2"><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}">ERP</span></li>
<li data-leveltext="o" data-font="Courier New" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":1440,"335559991":360,"469769226":"Courier New","469769242":[9675],"469777803":"left","469777804":"o","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="2"><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}">WMS</span></li>
<li data-leveltext="o" data-font="Courier New" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":1440,"335559991":360,"469769226":"Courier New","469769242":[9675],"469777803":"left","469777804":"o","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="2"><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}">Shopify</span></li>
<li data-leveltext="o" data-font="Courier New" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":1440,"335559991":360,"469769226":"Courier New","469769242":[9675],"469777803":"left","469777804":"o","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="2">Existing datasets in Amazon Redshift</li>
</ul>
</li>
<li><span class="TextRun SCXW82646544 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW82646544 BCX0">Build and enhance </span></span><span class="TextRun MacChromeBold SCXW82646544 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW82646544 BCX0">data pipelines into the </span></span><span class="TextRun Highlight MacChromeBold SCXW82646544 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW82646544 BCX0">data lake (Redshift)</span></span><span class="TextRun SCXW82646544 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW82646544 BCX0"> to ensure required product attributes are available, current, and reliable</span></span></li>
<li data-leveltext="" data-font="Symbol" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Develop SQL-based transformations and views that create </span><span data-contrast="auto">canonical product records</span><span data-contrast="auto"> suitable for consumption by multiple systems and microservices</span></li>
<li data-leveltext="" data-font="Symbol" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto"><span class="TextRun SCXW74223795 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW74223795 BCX0">Assist</span><span class="NormalTextRun SCXW74223795 BCX0"> in defining </span></span><span class="TextRun MacChromeBold SCXW74223795 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW74223795 BCX0">data ownership, source-of-truth rules, and attribute-level lineage</span></span><span class="TextRun SCXW74223795 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW74223795 BCX0"> (e.g., which system owns which product attributes)</span></span></span></li>
<li data-leveltext="" data-font="Symbol" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto"><span class="TextRun SCXW74223795 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW74223795 BCX0"><span class="TextRun SCXW16787412 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW16787412 BCX0">Collaborate with Business Analysts and stakeholders to document product data requirements and translate business needs into technical solutions</span></span></span></span></span></li>
<li><span data-contrast="auto">Create and maintain </span><span data-contrast="auto">technical documentation</span><span data-contrast="auto">, including:</span><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"> </span>
<ul>
<li><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"><span class="TextRun SCXW173484804 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW173484804 BCX0">Product data models</span></span><span class="EOP SCXW173484804 BCX0" data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"> </span></span></li>
<li><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"><span class="EOP SCXW173484804 BCX0" data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"><span class="TextRun SCXW108164397 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW108164397 BCX0">Source-to-target mappings</span></span><span class="EOP SCXW108164397 BCX0" data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"> </span></span></span></li>
<li><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"><span class="EOP SCXW173484804 BCX0" data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"><span class="EOP SCXW108164397 BCX0" data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"><span class="TextRun SCXW4962710 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW4962710 BCX0">Data flow diagrams</span></span><span class="EOP SCXW4962710 BCX0" data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"> </span></span></span></span></li>
<li><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"><span class="EOP SCXW173484804 BCX0" data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"><span class="EOP SCXW108164397 BCX0" data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"><span class="EOP SCXW4962710 BCX0" data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"><span class="TextRun SCXW216631976 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW216631976 BCX0">Attribute definitions and dependencies</span></span><span class="EOP SCXW216631976 BCX0" data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"> </span></span></span></span></span></li>
</ul>
</li>
<li><span data-contrast="auto">Support downstream consumption of PIM data by helping define </span><span data-contrast="auto">access patterns</span><span data-contrast="auto"> (e.g., database views, exports, APIs, or service interfaces)</span></li>
<li><span data-contrast="auto"><span class="TextRun SCXW204355193 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW204355193 BCX0">Validate data quality and consistency across systems, </span><span class="NormalTextRun ContextualSpellingAndGrammarErrorV2Themed SCXW204355193 BCX0">identifying</span><span class="NormalTextRun SCXW204355193 BCX0"> gaps, conflicts, and opportunities for standardization</span></span></span></li>
<li><span data-contrast="auto"><span class="TextRun SCXW204355193 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW204355193 BCX0"><span class="TextRun SCXW118353403 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW118353403 BCX0">Learn and apply best practices for </span></span><span class="TextRun MacChromeBold SCXW118353403 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW118353403 BCX0">data modeling, data engineering, and platform design</span></span><span class="TextRun SCXW118353403 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW118353403 BCX0"> in a real-world enterprise environment</span></span></span></span></span></li>
</ul>
<p><strong>QUALIFICATIONS</strong></p>
<ul>
<li><span data-contrast="auto">Currently pursuing a degree in </span><span data-contrast="auto">Computer Science, Data Science, Information Systems, or a related technical field</span></li>
<li><span data-contrast="auto">Strong working knowledge of </span><span data-contrast="auto">SQL</span><span data-contrast="auto"> and relational databases</span></li>
<li><span data-contrast="auto">Understanding of </span><span data-contrast="auto">data modeling concepts</span><span data-contrast="auto">, including entities, attributes, relationships, and normalization</span></li>
<li><span data-contrast="auto">Experience with or exposure to </span><span data-contrast="auto">ETL / ELT pipelines</span><span data-contrast="auto"> and data integration concepts</span></li>
<li><span data-contrast="auto">Familiarity with one or more programming or scripting languages such as </span><span data-contrast="auto">Python, Java, or C#</span><span data-contrast="auto"> is a plus</span></li>
<li><span data-contrast="auto">Interest in </span><span data-contrast="auto">enterprise systems, data platforms, and foundational architecture</span></li>
<li><span data-contrast="auto">Strong problem-solving skills and comfort working with </span><span data-contrast="auto">ambiguous and evolving requirements</span></li>
<li><span data-contrast="auto">Ability to communicate technical concepts clearly to both technical and non-technical stakeholders</span><span data-ccp-props="{"335559739":0}"> </span></li>
<li><span data-contrast="auto">A strong desire to build systems that will be used and extended by others over time</span></li>
</ul>
<p><strong><span data-contrast="auto">NICE TO HAVE (NOT REQUIRED)</span></strong><span data-ccp-props="{}"> </span></p>
<ul>
<li><span data-contrast="auto">Exposure to Product Information Management (PIM), Master Data Management (MDM), or data governance concepts</span></li>
<li><span data-contrast="auto">Familiarity with cloud data platforms (AWS, Azure)</span></li>
<li><span data-contrast="auto">Experience integrating data from SaaS platforms (e.g., Shopify or PLM systems)</span></li>
<li><span data-contrast="auto">Coursework or projects involving data architecture or enterprise systems</span></li>
</ul>
<p class="p1">The base pay range for this position is $45/hr-$50/hr which represents the current range for the non-exempt position. Please note that actual pay will vary based on factors including but not limited to location, experience, and performance.</p><div class="content-conclusion"><div class="c-scrollbar__hider" data-qa="slack_kit_scrollbar">
<div class="c-scrollbar__child">
<div class="c-virtual_list__scroll_container" data-qa="slack_kit_list">
<div id="1690839906.519949" class="c-virtual_list__item c-virtual_list__item--initial-activeitem" data-qa="virtual-list-item" data-item-key="1690839906.519949">
<div class="c-message_kit__background c-message_kit__background--hovered p-message_pane_message__message c-message_kit__message p-message_pane_message__message--last" data-qa="message_container" data-qa-unprocessed="false" data-qa-placeholder="false">
<div class="c-message_kit__hover c-message_kit__hover--hovered" data-qa-hover="true">
<div class="c-message_kit__actions c-message_kit__actions--default">
<div class="c-message_kit__gutter">
<div class="c-message_kit__gutter__right" data-qa="message_content">
<div class="c-message_kit__blocks c-message_kit__blocks--rich_text">
<div class="c-message__message_blocks c-message__message_blocks--rich_text" data-qa="message-text">
<div class="p-block_kit_renderer" data-qa="block-kit-renderer">
<div class="p-block_kit_renderer__block_wrapper p-block_kit_renderer__block_wrapper--first">
<div class="p-rich_text_block">
<div class="p-rich_text_section">For CA residents, Job Applicant Privacy Policy <a class="c-link" href="https://cdn.shopify.com/s/files/1/2185/2813/files/CCPA_Workforce_Member_Privacy_Policy_-_Alo_Alo_INTL_IP_Inc._-_July_2025_-_CA_ONLY_1.pdf?v=1762796781" target="_blank" data-stringify-link="https://cdn.shopify.com/s/files/1/2185/2813/files/CCPA_Workforce_Member_Privacy_Policy_-_Alo_and_Bella_Canvas_-_June_2023_-_CA_ONLY.pdf?v=1687812344" data-sk="tooltip_parent">HERE</a>.</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="c-message_actions__container c-message__actions"> </div>
</div>
</div>
</div>
</div>
</div>
</div>
</div></div>
Key Skills
SQLData ModelingETLData IntegrationPythonJavaC#Problem-SolvingData EngineeringTechnical DocumentationData QualityData GovernanceCloud Data PlatformsProduct Information ManagementMaster Data ManagementData Architecture
Categories
TechnologyData & AnalyticsEngineeringSoftware
Prep Tools
FREE
YOUR PERSONALIZED PREP ROADMAP
0-2 Engineering Intern - Business Technology Operations (Foundational PIM)
Interview Prep Plan
1
Week 1:Technical Foundations2
Week 2:SQL3
Week 3:System DesignFREE
STUCK ON A QUESTION? PRACTICE IT
Practice Any Question
Get instant AI feedback
"How would you design a scalable system for ALO's use case?"
Record your answer & get scored
FREE
STAND OUT FROM THE CROWD
AI Cover Letter
Tailored for ALO
Dear ALO Hiring Team,
I am excited to apply for the Engineering Intern - Business Technology Operations (Foundational PIM) position. With my experience in SQL and Data Modeling...
Continue with AI →