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

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

Job summary

Archipelago Companies is seeking a Lead Data Engineer to own data infrastructure end to end. You will build pipelines from Shopify, Google Ads, Google Analytics, ERPs, and internal data sources into Snowflake.

This senior role leads Snowflake architecture, data modeling for reporting across OluKai, Melin, Roark, and subsidiaries, and ensures data quality and governance with cross-functional collaboration.

Qualifications

• 5+ years of senior level data engineering experience.
• Deep Snowflake experience: warehouse architecture, cost optimization, RBAC, Snowpipe, Streams/Tasks.
• Proven experience building ETL/ELT pipelines from multiple sources.
• Strong SQL and Python for pipelines.
• Experience designing data warehouse models for reporting/analytics.
• Excellent cross-team communication.
• Ability to adopt AI-enabled tools while maintaining governance.

Responsibilities

• Design, build, and maintain ETL/ELT pipelines into Snowflake from Shopify, Google Ads/Analytics, ERP exports, and databases.
• Own and administer Snowflake environment including architecture and security.
• Stand up new Snowflake instances as data needs grow.
• Build data models supporting reporting across brands and subsidiaries.
• Establish data quality, testing, and monitoring; prevent data issues.
• Partner with marketing, ecommerce, wholesale, and finance on data needs.
• Own data governance and documentation; be the source of truth.

Skills

Snowflake

ETL/ELT

SQL

Python

Data modeling

RBAC

Data governance

Communication

AI tools

Education

Bachelor’s degree

Tools

Snowflake

GitHub

Airflow

dbt Cloud

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.

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 include but are not limited to:

• 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:

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:

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.