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

Archipelago Companies•Irvine, CA

1d•Hybrid

About The Position

Tradewind Services, which provides shared services across Archipelago Companies’ portfolio of brands and international subsidiaries, is hiring a Lead Data Engineer to own data infrastructure end to end. The role involves building pipelines that bring data in from across the business, administering the Snowflake environment, and serving as the organization’s subject-matter expert on how its data fits together. This is a senior, high-ownership position responsible for establishing and maintaining a data warehouse and helping teams understand data sources and lineage. The position is hybrid and in-office in Irvine, California, with mandatory attendance four days per week and the option to work from home one day per week. The role may be on call as needed, and the arrangement is subject to change without notice in accordance with company guidelines. The salary range is $160,000–$198,000, plus the opportunity for an annual bonus; compensation depends on the experience the candidate brings.

Requirements

Bachelor’s degree required.
At least 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, including warehouse architecture, performance and cost optimization, RBAC, Snowpipe, and Streams/Tasks.
Proven experience building ETL/ELT pipelines from a range of source types, including advertising platforms, analytics and tracking tools, ERPs, relational databases, and spreadsheet-based sources.
Strong SQL skills and hands-on experience building ETL/ELT pipelines from scratch.
Python skills for scripting, pipeline orchestration, and custom integrations.
Experience designing data warehouse models, such as dimensional or star schemas, for reporting and analytics.
Strong communication skills and comfort serving as a source of truth for other teams.
Actively seek AI-enabled tools and emerging technologies, adapt quickly to use them to improve productivity, insights, and processes, and exercise sound judgment while maintaining compliance with organizational standards.

Nice To Haves

Experience with Domo or a similar BI/reporting platform.
Experience with retail or consumer products data, including wholesale, DTC/e-commerce, and inventory.
Experience with orchestration tools such as Airflow, dbt Cloud, or Prefect.
Experience consolidating data across multiple brands, business units, or entities.

Responsibilities

Design, build, and maintain ETL/ELT pipelines that bring data into Snowflake from business sources, including Shopify, Google Ads, Google Analytics, Google BigQuery, ERP flat-file exports, transactional databases, and internal documents such as Google Docs and Excel.
Own and administer the Snowflake environment, including architecture, performance tuning, cost and credit management, security, and access controls.
Maintain code in GitHub using version control and a structure that supports AI-assisted development and iteration.
Stand up new Snowflake instances and environments as the organization’s data needs grow.
Build and maintain data models for reporting and analysis across brands and subsidiaries.
Establish data quality, testing, and monitoring practices to detect pipeline failures and data issues before they affect stakeholders.
Partner with marketing, e-commerce, wholesale, and finance teams to understand data needs and translate them into reliable pipelines and models.
Own data governance, including naming conventions, access control, and documentation of data sources and transformations.
Serve as the organization’s subject-matter expert on data architecture and lineage.