Business Intelligence Lead
About The Position
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.
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
- Leverage AI and automation to improve data quality monitoring, accelerate insights, and reduce manual analytical effort.
Nice To Haves
- Experience with Microsoft Dynamics NAV/Business Central, Quickbooks, Salesforce Commerce Cloud, Shopify and Amazon Marketplaces are a plus but not essential
Responsibilities
- 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
- 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
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
