OluKai, melin, Roark (Tradewind Services) Lead Data Engineer
- Compensation
- $160K–$198K
- Location
- Irvine, California, United States
- Work setup
- Onsite
- Seniority
- Lead
- Employment
- Not specified
- Experience
- 5+ years
- Category
- Data engineering
- Posted
Skills
Must have
- 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 spreadshe
- 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 judgme
Nice to have
- 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
Full 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: