The Business Intelligence Lead will oversee ETL processes, manage data integrity, collaborate on analytics, and lead a BI team to optimize reporting and decision-making.
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
Requirements
- 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.
Top Skills
AI
Amazon Marketplaces
ETL
Fivetran
Microsoft Fabric
Power BI
Salesforce Commerce Cloud
Shopify
Snowflake
SQL
PopSockets LLC Boulder, Colorado, USA Office
We're just outside Downtown Boulder (no traffic!) in a gorgeous, newly built and designed office with terrific mountain views!
Similar Jobs
AdTech • Big Data • Consumer Web • Digital Media • Marketing Tech
The Lead BI Manager will deliver business intelligence and strategic insights, clean dashboards, ensure data alignment, and analyze performance to drive revenue growth.
Top Skills:
LookerSQL
AdTech • Big Data • Consumer Web • Digital Media • Marketing Tech
Lead the development and delivery of business intelligence insights through analysis, reporting, and collaboration with cross-functional teams at Launch Potato.
Top Skills:
LookerSQL
AdTech • Big Data • Consumer Web • Digital Media • Marketing Tech
The Lead BI Developer is responsible for delivering actionable insights, standardizing dashboards in Looker, addressing reporting discrepancies, and collaborating across teams to align financial and operational data.
Top Skills:
LookerSQL
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
