Engineering Intern Business Technology Operations (Foundational PIM)

WHY JOIN ALO

Mindful movement. Its at the core of why we do what we do at ALOits 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. Thats the real meaning of studio-to-street: taking the consciousness from practice on the mat and putting it into practice in life.

OVERVIEW

We areseekinga motivated and technically strongComputer Science Intern Product Information Management (PIM)to join our Biz Tech Operationsteam. This internship offers a unique opportunity to design and build afoundational Product Information Management (PIM) capability that will serve as a single trusted source of product data across ALOs technology ecosystem.

Today product information is distributed across multiple systemsincludingNGC PLMFDM4ERPFDM4WMS Shopify and spreadsheetsresulting in duplicated integrations inconsistent data and manual workarounds. As an intern you will help design and implement a centralized PIM solution built on ALOs data lake (Amazon Redshift)and supporting data pipelines enabling all downstream systems services and teams to reliably source product data from a single platform.

This work will create a scalable foundation that can be expanded over time with additional product attributes governance and automation to support ALOs continued growth and tech environment expansion.

The ALO internship programs starts June 8th and ends July 31st. Interns will be working 40 hours a week at our Beverly Hills HQ.

RESPONSIBILITIES

• Partner withTech Business and downstream application teams to help define thevision scope and requirements for a centralized Product Information Management (PIM) solution
• Design and implement afoundational PIM data modelthatconsolidatesproduct data from multiple enterprise systems including:
  • PLM
  • ERP
  • WMS
  • Shopify
  • Existing datasets in Amazon Redshift
• Build and enhancedata pipelines into thedata lake (Redshift) to ensure required product attributes are available current and reliable
• Develop SQL-based transformations and views that createcanonicalproduct records suitable for consumption by multiple systems and microservices
• Assistin definingdata ownership source-of-truth rules and attribute-level lineage (e.g. which system owns which product attributes)
• Collaborate with Business Analysts and stakeholders to document product data requirements and translate business needs into technical solutions
• Create andmaintaintechnical documentation including:
  • Product data models
  • Source-to-target mappings
  • Data flow diagrams
  • Attribute definitions and dependencies
• Support downstream consumption of PIM data by helping defineaccess patterns (e.g. database views exports APIs or service interfaces)
• Validate data quality and consistency across systemsidentifying gaps conflicts and opportunities for standardization
• Learn and apply best practices fordata modeling data engineering and platform designin a real-world enterprise environment

QUALIFICATIONS

• Currentlypursuing a degree inComputer Science Data Science Information Systems or a related technical field
• Strong working knowledge ofSQL and relational databases
• Understanding ofdata modeling concepts including entities attributes relationships and normalization
• Experience with or exposure toETL / ELT pipelines and data integration concepts
• Familiarity with one or more programming or scripting languages such asPython Java or C# is a plus
• Interestinenterprise systems data platforms and foundational architecture
• Strong problem-solving skills and comfort working withambiguous and evolving requirements
• Ability to communicate technical concepts clearly to both technical and non-technical stakeholders
• A strong desire to build systems that will be used and extended by others over time

NICE TO HAVE

• Exposure to Product Information Management (PIM) Master Data Management (MDM) or data governance concepts
• Familiarity with cloud data platforms (AWS Azure)
• Experience integrating data from SaaS platforms (e.g. Shopify or PLM systems)
• Coursework or projects involving data architecture or enterprise systems

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.