← back to jobs
> job detail
A
⚙️Data Engineer

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

Archipelagocos · Irvine, California, United States
// classified as
Data Engineer (Pipelines, infra, ingestion, ETL.)
posted
1d ago
location
Irvine, California, United States
languages
sql
tools
bigquery, dbt, snowflake
> stack
sqlbigquerydbtsnowflakeairflowdbt
> 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

 

 

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.

 

Apply at Archipelagocos →