Senior BI Engineer - Data Architecture

W2 Role only, No C2C please

seeking a Remote Senior BI Engineer - Data Architecture. In this role, you will focus on data infrastructure, data modeling, and governance, not dashboard development. The primary technologies include Snowflake, Looker/LookML, SQL, Daasity, NetSuite, Shopify, and WMS platforms.

Key Responsibilities:

• Own and enhance Snowflake transformation processes within the Daasity ELT framework
• Write, troubleshoot, and optimize complex SQL transformations
• Manage incremental and full data refresh strategies
• Consolidate transformation logic across NetSuite, Shopify, WMS, and marketing systems
• Build reconciliation processes between key business systems Looker Ownership: Design and maintain scalable LookML models, explores, views, and derived tables
• Improve performance through optimized joins, PDTs, and datagroup configurations
• Establish governance standards for metrics, field definitions, and data consistency
• Partner with Finance, Operations, Merchandising, and Marketing to create sustainable data models instead of one-off reporting solutions Data Architecture
• Maintain end-to-end data lineage and documentation * Monitor data quality, freshness, and pipeline performance
• Evaluate future architecture decisions, including Daasity vs. dbt approaches
• Lead technical scoping for new data source integrations and platform expansion