Engineering Intern - Business Technology Operations (Foundational PIM) jobs in United States
cer-icon
Apply on Employer Site
company-logo

ALO · 4 hours ago

Engineering Intern - Business Technology Operations (Foundational PIM)

ALO is a company focused on mindful movement and improving lives through yoga. They are seeking a motivated Computer Science Intern to design and build a foundational Product Information Management (PIM) capability that will serve as a trusted source of product data across their technology ecosystem.

ApparelFashionTextiles
check
H1B Sponsor Likelynote

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

Qualification

SQLData modelingETL / ELT pipelinesPythonData integrationInterest in enterprise systemsProblem-solvingTechnical communication

Required

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

Preferred

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

Company

We are ALO.

H1B Sponsorship

ALO has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (22)
2024 (3)
2023 (4)
2022 (4)

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Andrew Holland
General Counsel and Chief Legal Officer
linkedin
leader-logo
Brittney Bohnert
Community & Partnerships Manager
linkedin
Company data provided by crunchbase