Business Intelligence Lead

Launched in 2014 by former philosophy professor David Barnett, PopSockets is a global digital-lifestyle company that sells empowering, fun, and expressive products that improve people’s digital lives. PopSockets 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, PopSockets was honored as one of Fast Company’s World's Most Innovative Companies.

The Business Intelligence (BI) Team at PopSockets is a group of talented and agile professionals looking to add an experienced Lead to our team as we continue to grow. This role will be responsible for maintaining, troubleshooting, and optimizing our Extract, Transform, Load (ETL) processes while collaborating with analysts and other stakeholders to drive an obsession with using data to inform decision making. The Business Intelligence Lead will be responsible for ensuring data reliability and accuracy from source systems and updating, as needed, any data transformations from the 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. A successful candidate can manage competing priorities in a fast-paced environment while maintaining a high degree of organization and attention to detail. Additionally, they should be comfortable working within a global company that utilizes multiple ERP systems, eCommerce tools, marketplace APIs (including, but not limited to Amazon Vendor, Seller Central and Walmart Marketplaces), and Ad platforms. We are looking for an individual with a positive attitude who wants to grow their skill set and institutionalize AI-driven change at a dynamic company that values collaboration and hard work. This position reports to our Director of FP&A and Business Intelligence in the US.

Responsibilities:

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 as it relates 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 OneLake 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 areas of opportunity and optimization to reducing querying time or credit usage
• Ability to multi-task, problem solve and take ownership of work in a fast-paced, high growth environment 
• Experience leading international teams and juggling multiple time zones
• Must be detail oriented with strong organizational and analytical skills 
• Experience with Microsoft Dynamics NAV/Business Central, Quickbooks, Salesforce Commerce Cloud, Shopify and Amazon Marketplaces are a plus but not essential  
• Leverage AI and automation to improve data quality monitoring, accelerate insights, and reduce manual analytical effort.

PopSockets is dedicated to the practice of equal opportunity employment. We prohibit unlawful discrimination against applicants and employees on the basis of age, race, sex, sexual orientation, gender identity, religion, national origin, disability, military status, genetic information, color, creed, ancestry, or any other status protected by applicable federal, state or local law. This prohibition includes unlawful harassment based on any of these protected classes. Unlawful harassment includes verbal or physical conduct which has the purpose or effect of interfering with an individual’s work performance, or creating an intimidating, hostile, offensive, unsafe or otherwise non-welcoming work environment. This policy applies to all employees, including managers, supervisors, co-workers; and non-employees such as customers, clients, vendors, consultants, etc.