OluKai, melin, Roark (Tradewind Services) Lead Data Engineer

melin; Irvine (CA); Hybrid; USD 160,000 - 198,000; Full time

Job summary

Archipelago Companies is hiring a Lead Data Engineer to own our data infrastructure end to end, building pipelines and managing Snowflake across brands. You will define data models, governance, and trust for multiple subsidiaries, acting as the go-to expert for data architecture.

The role requires 5+ years in data engineering, strong Snowflake skills, and a track record of delivering end-to-end data platforms.

Qualifications

• Bachelor’s degree required.
• 5+ years of senior data engineering experience owning a data platform end to end.
• Deep Snowflake experience: RBAC, Snowpipe, Streams/Tasks.
• Proven experience building ETL/ELT pipelines from diverse sources.
• Strong SQL and Python for scripting and orchestration.
• Experience designing data warehouse models (dimensional/star) for reporting.
• Excellent communication and ability to be trusted data source across teams.
• Actively seeks AI-enabled tools and emerging tech for productivity and insights.

Responsibilities

• Design, build, and maintain ETL/ELT pipelines to Snowflake from Shopify, Google Ads, Analytics, ERP exports, and spreadsheets.
• Own and administer Snowflake environment: architecture, performance tuning, cost management, security, access controls.
• Stand up new Snowflake instances as the organization's data needs grow.
• Build data models supporting reporting across brands and subsidiaries.
• Establish data quality, testing, and monitoring to catch issues before stakeholders see them.
• Partner with marketing, ecom, wholesale, and finance to translate data needs into reliable pipelines.
• Own data governance: naming conventions, access, and documentation of sources and transformations.
• Serve as data architecture and lineage SME.

Skills

SQL

Python

Data Modeling

ETL/ELT pipelines

Snowflake

Data governance

RBAC / security

Communication

AI tool awareness

Education

Bachelor’s degree

Tools

Airflow

dbt Cloud

Prefect

GitHub

Job description

Who We Are

Archipelago Companies, a portfolio of highly successful consumer lifestyle brands, is seeking a talented and passionate individual with an entrepreneurial mindset to join our team. Our brands, including OluKai, Kaenon, Melin, Roark, and Tradewind Services are leaders in their respective markets, offering high-quality products and authentic marketing stories direct to consumers. At Archipelago Companies, we pride ourselves on our commitment to integrity, and we strive to create a culture of excellence in everything we do. If you are a driven and innovative individual with a passion for consumer brands, we invite you to apply for our open position and become a part of our dynamic and growing team.

Who We Are

Archipelago Companies, a portfolio of highly successful consumer lifestyle brands, is seeking a talented and passionate individual with an entrepreneurial mindset to join our team. Our brands, including OluKai, Kaenon, Melin, Roark, and Tradewind Services are leaders in their respective markets, offering high-quality products and authentic marketing stories direct to consumers. At Archipelago Companies, we pride ourselves on our commitment to integrity, and we strive to create a culture of excellence in everything we do. If you are a driven and innovative individual with a passion for consumer brands, we invite you to apply for our open position and become a part of our dynamic and growing team.

About The Role

Tradewind Services provides shared services across Archipelago Companies' portfolio of brands (OluKai, Melin, Roark) and international subsidiaries (Arch-UK, Arch-EU). We're hiring a Lead Data Engineer to own our data infrastructure end to end: building the pipelines that bring data in from across the business, running our Snowflake environment, and becoming the go-to expert on how our data fits together.

This is a senior, high-ownership role. You'll be the person who can stand up a data warehouse from scratch and the person other teams come to when they need to know where a number comes from.

Key Responsibilities

• Design, build, and maintain ETL/ELT pipelines that bring data into Snowflake from across the business: Shopify, Google Ads, Google Analytics, Google BigQuery, ERP flat-file exports, transactional databases, and internal documents (Google Docs, Excel)
• Own and administer the Snowflake environment: architecture, performance tuning, cost and credit management, security, and access controls. Code lives in GitHub, version-controlled and structured for easy AI-assisted development and iteration
• Stand up new Snowflake instances and environments as the organization's data needs grow
• Build and maintain data models that support reporting and analysis across brands (OluKai, Melin, Roark) and subsidiaries
• Establish data quality, testing, and monitoring practices so pipeline failures and data issues get caught before stakeholders find them
• Partner with teams across marketing, ecom, wholesale, and finance to understand data needs and translate them into reliable pipelines and models
• Own data governance: naming conventions, access control, and documentation of sources and transformations
• Serve as the organization's subject-matter expert on data architecture and lineage

Requirements & Qualifications

• Bachelor’s degree required
• 5+ years of senior level data engineering experience, with a track record of owning a data platform end to end
• Deep, hands-on Snowflake experience: warehouse architecture, performance and cost optimization, RBAC, Snowpipe, Streams/Tasks
• Proven experience building ETL/ELT pipelines from a range of source types: ad platforms (e.g., Google Ads), analytics/tracking tools (e.g., Google Analytics), ERPs, relational databases, and spreadsheet-based sources (e.g., Google Sheets)
• Strong SQL and hands-on experience building ETL/ELT pipelines from scratch
• Python for scripting, pipeline orchestration, and custom integrations
• Experience designing data warehouse models (e.g., dimensional/star schema) for reporting and analytics use cases
• Strong communication skills; comfortable being the source of truth other teams rely on
• Actively seeks out AI-enabled tools and emerging technologies, adapting quickly to leverage them for improved productivity, deeper insights, and more effective processes, while exercising sound judgment and maintaining compliance with organizational standards

Preferred Qualifications

• Experience with Domo or a similar BI/reporting platform
• Experience with retail or consumer products data (wholesale, DTC/ecom, inventory)
• Experience with orchestration tools (e.g., Airflow, dbt Cloud, Prefect)
• Experience consolidating data across multiple brands, business units, or entities

Location & Office Structure

Location & Office Structure: This is an in-office hybrid position, mandatory 4 days per week in office in Irvine, CA with the option to work from home 1 day per week. On call as needed and subject to change without notice as per company guidelines.

Compensation

Compensation: The salary range for this position is $160,000 - $198,000 plus opportunity for annual bonus; salary is based on the experience that you bring to the position.