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

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 iterationStand up new Snowflake instances and environments as the organization's data needs growBuild and maintain data models that support reporting and analysis across brands (OluKai, Melin, Roark) and subsidiariesEstablish data quality, testing, and monitoring practices so pipeline failures and data issues get caught before stakeholders find themPartner with teams across marketing, ecom, wholesale, and finance to understand data needs and translate them into reliable pipelines and modelsOwn data governance: naming conventions, access control, and documentation of sources and transformationsServe as the organization's subject-matter expert on data architecture and lineageRequirements & Qualifications:Bachelor’s degree required5+ years of senior level data engineering experience, with a track record of owning a data platform end to endDeep, hands-on Snowflake experience: warehouse architecture, performance and cost optimization, RBAC, Snowpipe, Streams/TasksProven 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 scratchPython for scripting, pipeline orchestration, and custom integrationsExperience designing data warehouse models (e.g., dimensional/star schema) for reporting and analytics use casesStrong communication skills; comfortable being the source of truth other teams rely onPreferred Qualifications:Experience with Domo or a similar BI/reporting platformExperience 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 entitiesLocation & 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.DepartmentTWS ITEmployment TypeFull-TimeMinimum ExperienceExperienced