Remote Senior BI Engineer - Data Architecture

Kforce has a client that is 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

• 5+ years in BI/analytics engineering with production Looker/LookML experience (models, explores, derived tables, PDTs, access filters) - not just dashboard consumption
• 4+ years of advanced SQL in Snowflake or a comparable cloud warehouse (window functions, incremental merge patterns, query performance tuning)
• Direct experience with retail/ecommerce data models: order lifecycle, fulfillment, inventory, returns, customer/CDP data - ideally spanning a DTC platform (Shopify/BigCommerce/Salesforce Commerce) plus an ERP (NetSuite, Microsoft Dynamics, SAP)
• Experience working within a vendor-managed or templated ELT/transformation framework (Daasity, Fivetran + dbt, Matillion, or similar) - comfortable extending vendor patterns without introducing untracked one-offs
• Demonstrated ownership of data governance practices: field documentation, metric standardization, deprecation of unused assets, access control
• Strong stakeholder communication - able to translate finance/ops/merch requirements into data models and explain tradeoffs to non-technical leadership
• Ability to independently produce and maintain data lineage documentation at the level of source system, warehouse object, BI object, business consumer

Ideal Candidate:

• Experience with semantic layer design, data governance, and scalable architecture
• Strong Snowflake, SQL, and Looker expertise
• Background in BI, analytics engineering, or data engineering
• Builder mindset with the ability to balance technical engineering and business needs

The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.

We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.

Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce’s sole discretion unless and until paid and may be modified in its discretion consistent with the law.

By clicking “Apply Today” you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.