- Страна
- США
- Зарплата
- 45 $ – 50 $
Откликайтесь
на вакансии с ИИ
Engineering Intern - Business Technology Operations (Foundational PIM)
Оценка ИИОтличная стажировка в известном бренде с очень высокой для интерна почасовой оплатой. Проект имеет реальную бизнес-ценность, что обеспечит качественный опыт в Data Engineering и системной архитектуре.
Сложность вакансии
Оценка ИИЭто позиция для стажера, поэтому требования к опыту минимальны, однако ожидаются сильные знания SQL и понимание архитектуры данных. Основная сложность заключается в работе с реальными корпоративными системами (ERP, PLM) и облачными решениями AWS.
Анализ зарплаты
Оценка ИИПредлагаемая ставка $45-$50 в час значительно выше средней рыночной ставки для стажеров в области ИТ в США, которая обычно составляет $25-$35 в час. Это делает вакансию крайне привлекательной с финансовой точки зрения.
Сопроводительное письмо
I am writing to express my strong interest in the Engineering Intern position within the Business Technology Operations team at Alo Yoga. As a Computer Science student with a deep fascination for data architecture and enterprise systems, the opportunity to help build a foundational Product Information Management (PIM) solution from the ground up is incredibly exciting. I am particularly drawn to Alo Yoga’s commitment to mindful movement and excellence, and I am eager to apply my technical skills to support such a dynamic and growing brand.
During my studies and personal projects, I have developed a solid foundation in SQL and relational database modeling, which aligns perfectly with your goal of consolidating product data into Amazon Redshift. I have experience working with ETL processes and Python, and I am confident in my ability to help transform fragmented data from Shopify, ERP, and PLM systems into a single, trusted source of truth. I am a proactive problem-solver who thrives in environments where I can bridge the gap between technical implementation and business requirements.
I am impressed by the scope of this internship, specifically the focus on creating a scalable data foundation that will impact the entire technology ecosystem. I am eager to bring my dedication and technical curiosity to the Biz Tech Operations team this summer and contribute to the long-term success of Alo’s data infrastructure.
Составьте идеальное письмо к вакансии с ИИ-агентом
Откликнитесь в aloyoga уже сейчас
Присоединяйтесь к команде Alo Yoga в Беверли-Хиллз и постройте фундамент для управления данными мирового бренда!
Описание вакансии
WHY JOIN ALO?
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.
OVERVIEW
We are seeking a motivated and technically strong Computer Science Intern – Product Information Management (PIM) to join our Biz Tech Operations team. This internship offers a unique opportunity to design and build a foundational Product Information Management (PIM) capability that will serve as a single, trusted source of product data across ALO’s technology ecosystem.
Today, product information is distributed across multiple systems—including NGC PLM, FDM4 ERP, FDM4 WMS, Shopify, 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 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 ALO’s 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 with Tech, Business, and downstream application teams to help define the vision, scope, and requirements for a centralized Product Information Management (PIM) solution
- Design and implement a foundational PIM data model that consolidates product data from multiple enterprise systems, including:
+ PLM
+ ERP
+ WMS
+ Shopify
+ Existing datasets in Amazon Redshift
- Build and enhance data pipelines into the data lake (Redshift) to ensure required product attributes are available, current, and reliable
- Develop SQL-based transformations and views that create canonical product records suitable for consumption by multiple systems and microservices
- Assist in defining data 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 and maintain technical documentation, including:
+ Product data models
+ Source-to-target mappings
+ Data flow diagrams
+ Attribute definitions and dependencies
- Support downstream consumption of PIM data by helping define access patterns (e.g., database views, exports, APIs, or service interfaces)
- Validate data quality and consistency across systems, identifying gaps, conflicts, and opportunities for standardization
- Learn and apply best practices for data modeling, data engineering, and platform design in a real-world enterprise environment
QUALIFICATIONS
- Currently pursuing a degree in Computer Science, Data Science, Information Systems, or a related technical field
- Strong working knowledge of SQL and relational databases
- Understanding of data modeling concepts, including entities, attributes, relationships, and normalization
- Experience with or exposure to ETL / ELT pipelines and data integration concepts
- Familiarity with one or more programming or scripting languages such as Python, Java, or C# is a plus
- Interest in enterprise systems, data platforms, and foundational architecture
- Strong problem-solving skills and comfort working with ambiguous 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.
For CA residents, Job Applicant Privacy Policy HERE.
Создайте идеальное резюме с помощью ИИ-агента
Навыки
- AWS
- Data Architecture
- Python
- SQL
- ETL
- Data Integration
- Data Modeling
- Relational Databases
- Amazon Redshift
Возможные вопросы на собеседовании
Проверка базовых навыков работы с данными, необходимых для построения PIM.
Можете ли вы объяснить разницу между нормализацией и денормализацией данных и в каких случаях в PIM-системе лучше использовать каждый из подходов?
Работа предполагает интеграцию данных из разных источников (Shopify, ERP).
Как бы вы подошли к решению проблемы конфликтующих данных, если один и тот же атрибут товара имеет разные значения в ERP и в Shopify?
Вакансия упоминает использование Amazon Redshift.
Опишите ваш опыт работы с SQL: какие самые сложные запросы или трансформации данных вам приходилось писать?
PIM — это связующее звено между бизнесом и ИТ.
Как вы будете объяснять бизнес-пользователю важность соблюдения правил управления данными (data governance) при вводе информации о товарах?
Оценка способности стажера к проектированию систем.
Представьте, что нам нужно добавить новый тип атрибутов для товаров (например, экологические сертификаты). Какие шаги вы предпримете для изменения модели данных?
Похожие вакансии
Стажёр - аналитик бизнес-процессов в команду молодежного продукта
Impact Research Intern - Summer 2026
Summer 2026 Intern
Operations & Strategy Intern (Summer 2026)
Middle Product Analyst
AI Analytics (Business Intelligence) Summer Intern
1000+ офферов получено
Устали искать работу? Мы найдём её за вас
Quick Offer улучшит ваше резюме, подберёт лучшие вакансии и откликнется за вас. Результат — в 3 раза больше приглашений на собеседования и никакой рутины!
- Страна
- США
- Зарплата
- 45 $ – 50 $