Business Intelligence, Business Solutions, Data Modeling, Data Quality, Documentation, Financial Operations, Identify Issues, Looker, Marketing, Merchandising, Metrics, NetSuite, Performance Management, Performance Tuning/Optimization, Quality Monitoring, Reconciliation, Reporting Dashboards, SQL (Structured Query Language), Technical Leadership
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