BI Architect (Looker)

View full description

Requirements:

• 5+ years of experience working on BI architecture
• 5+ years of hands-on SQL experience with complex query optimization
• 2+ years of experience modeling data in LookML and creating self-service content in Looker
• Experience with modern data stack technologies including cloud data warehouses (preferably BigQuery, Snowflake, or Redshift)
• Proven experience with modern data transformation tools (DBT preferred)
• Strong understanding of data warehouse architecture and dimensional modeling
• Experience working with multi-channel retail data, including DTC, marketplace, and brick-and-mortar sources
• Track record of building scalable reporting solutions that drive business value
• Familiarity with e-commerce platforms; experience with Shopify & Amazon data a significant plus
• Experience with retail POS and distribution data from syndicated sources (like IRI) is a plus

Responsibilities:

• Developing and maintaining Looker data models that drive critical business KPIs across sales, marketing, and operations
• Supporting the continued rollout and evolution of Lume's Looker implementation
• Driving meaningful insights through advanced analytics across customer lifecycle, marketing attribution, product performance, and omnichannel retail metrics
• Leading the development of standardized reporting and dashboards to support cross-functional decision-making
• Collaborating with stakeholders to translate business requirements into scalable analytics solutions
• Providing Looker training and mentorship to team members, both end users and developers
• Administering and maintaining the Looker environment, including user provisioning, permission management, and instance monitoring
• Managing Looker deployments, upgrades, and performance optimization
• Implementing robust caching strategies and troubleshooting performance issues
• Establishing and maintaining documentation for analytics processes and self-service reporting