BI Architect (LookML)

This data craftsman/craftswoman will be responsible for developing, maintaining, and governing the semantic layer in LookML; auditing and debugging vendor-managed ETL processes; troubleshooting and improving complex SQL transformations; and maintaining the data structures that move information from Shopify, NetSuite, and other operational systems into Snowflake. They will use Looker as the primary interface for delivering trusted, consistent data for strategic and tactical decision-making.

This is a fully REMOTE position, but candidates must work on Eastern Time core Standard Working Hours (9AM-6PM ET) with some flexibility., * You can translate an ambiguous finance, operations, merchandising, or marketing question into a durable data model.

• You care about consistent metric definitions and do not want revenue, AOV, margin, or customer counts calculated differently across dashboards.
• You can trace a number from its source system through transformation logic, warehouse objects, LookML, and the final dashboard.
• You can identify unused, duplicated, poorly documented, or unowned data assets and establish a better standard.
• You can explain technical tradeoffs to both engineers and business leaders.
• You are comfortable working independently inside a small, highly visible BI team.
• You enjoy mentoring other engineers and improving how the entire team works.

VoTech Recruiting of Jacksonville, FL is in search of BI Architect and craftsmen who isn’t afraid to get their hands dirty diving into data structures for a major e-commerce site based in Jacksonville, FL. Our client needs a full time, self-starter who wants the opportunity to come into a small but crucial BI team and make their mark on the company., * You have written and maintained production LookML, including models, Explores, views, derived tables, PDTs, joins, and access controls.

• You have owned or helped govern the semantic layer of a BI environment, not just created dashboards from existing Explores.
• You have hands-on experience working with Shopify data and understand the ecommerce order lifecycle, including orders, payments, fulfillment, inventory, returns, customers, and discounts.
• You have hands-on experience working with NetSuite data as an ERP and financial system of record.
• You can reconcile data across Shopify, NetSuite, warehouse or fulfillment systems, tax platforms, and other operational sources.
• You can read, troubleshoot, and improve complex transformation SQL.
• You have worked in Snowflake or a comparable cloud data warehouse.
• You can design and maintain incremental and full-refresh transformation logic across scheduled and event-triggered workflows.
• You are comfortable auditing and debugging vendor-managed ETL or ELT pipelines rather than replacing them with undocumented one-off solutions., * You have never worked in an E-Commerce Organization
• Your Looker experience has primarily been consuming existing Explores or building dashboards.
• You have not written production LookML.
• You want a pure architecture or management position without hands-on SQL and debugging.
• You prefer fulfilling individual reporting requests over building reusable, governed data models.
• You are uncomfortable investigating why two important systems report different numbers., * E-commerce: 2 years (Required)
• Looker: 5 years (Required)

Tuition reimbursement, Parental leave, 401(k), Health insurance, Retirement plan, 401(k) matching, Paid time off, Vision insurance Full-time Remote, * Base Salary Range 165-195k based on candidate experience, plus yearly bonus

Job Type: Full-time

Pay: $165,000.00 - $195,000.00 per year, * 401(k)

• 401(k) matching
• Dental insurance
• Flexible schedule
• Flexible spending account
• Health insurance
• Health savings account
• Paid time off
• Parental leave
• Relocation assistance
• Retirement plan
• Tuition reimbursement
• Vision insurance

VoTech Recruiting is a tech recruiting shop staffed by developers. Our owner is a data professional and we are a data driven recruiting firm. We love building awesome code and awesome people’s resumes!

We only take the very best clients because we attract only the best software craftsmen/craftswomen. Our awesome client runs a major e-commerce site based out of Jacksonville, FL which is simply dripping with data.

Why We Want You

This role is built for someone who has already owned the layer between raw ecommerce data and the numbers a company uses to make decisions.