Business Intelligence Lead

Overview

Launched in 2014 by former philosophy professor David Barnett, Pop Sockets is a global digital-lifestyle company that sells empowering, fun, and expressive products that improve people’s digital lives. Pop Sockets has sold close to 300 million of its iconic phone grips in 75 countries and now has an expanding ecosystem of related products, including phone cases, wallets, mounts, batteries, and chargers.

Our mission is to empower enhanced mobile functionality, self-expression, and authentic human connection. We imagine an Eternal Positivity Machine that sparks joy, creativity, and meaningful relationships. We bring this vision to life by upholding the highest standards in materials, packaging, logistics, and design—while ensuring our supply chain and labor practices remain ethical, responsible, and transparent. In 2021, Pop Sockets was honored as one of Fast Company’s World’s Most Innovative Companies.

The Business Intelligence (BI) Team at Pop Sockets is growing and seeks an experienced Lead to maintain, troubleshoot, and optimize our Extract, Transform, Load (ETL) processes. You will collaborate with analysts and stakeholders to drive data-informed decision making, ensure data reliability and accuracy from source systems, and update data transformations from raw data to normalized, report-ready tables. You will lead and develop a small, high-performing BI team while remaining hands-on in architecture, modeling, and performance optimization.

The role requires managing competing priorities in a fast-paced environment and working within a global company that uses multiple ERP systems, eCommerce tools, marketplace APIs (including Amazon Vendor, Seller Central, and Walmart Marketplaces), and advertising platforms. We value a positive attitude and a willingness to grow skills while institutionalizing AI-driven change. This position reports to our Director of FP&A and Business Intelligence in the US.

• Data Platform & Modeling
  • Own our data lifecycle from source system to end-user consumption
  • Utilize 3rd party tools alongside custom solutions to maintain ETL and reverse ETL logic
  • Maintain data best practices related to version control, data governance, and documentation
  • Normalize and model raw data into analytics-ready tables for consumption in Power BI, custom-built applications, and AI agents

• Analytics Enablement
  • Collaborate cross-functionally to develop dashboards in Power BI and AI-ready data models
  • Enhance reporting by partnering with internal stakeholders to identify gaps in current reporting
  • Institutionalize and manage an intake process for new reporting requests
  • Enable data democratization by maintaining a data gold layer that’s exposed to Microsoft Fabric for Power BI and Copilot to leverage for data-driven decisions

• Operations & Optimizations
  • Ensure Snowflake and other pillars of our tech stack remain performant, cost-efficient, and scalable as data volume and business complexity grow
  • Be obsessed with improving processes, leveraging automation and integrating AI into all workflows to drive efficiencies
  • Inform the development of our BI roadmap alongside the Director of FP&A and Business Intelligence
  • Partner with international teams, which may require working outside of standard work hours

• Bachelor’s degree in Business Analytics, Computer Science and Engineering, Data Science or other quantitatively relevant disciplines
• Proven experience leading data architecture and modeling decisions in a complex, multi-source environment
• Expert knowledge of ETL principles and SQL or other database querying languages
• Experience using Snowflake and Microsoft Fabric, including One Lake and Power BI
• Familiarity with Fivetran or other ETL software tools
• Proficient in navigating and utilizing API documentation to integrate and troubleshoot data sources effectively
• Demonstrated ability to normalize, standardize and aggregate raw data into reporting-ready tables at multiple levels of granularity
• Proactive in identifying opportunities to optimize and reduce querying time or credit usage
• Ability to multi-task, problem solve and own work in a fast-paced, high-growth environment
• Experience leading…