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.

Requirements

Must-haves

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

Nice-to-haves

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

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

goaisqlpython

Platform: bamboohr
Effort: medium