Business Intelligence Lead

PopSockets is seeking a Business Intelligence Lead to join its team as it continues to grow. The ideal candidate will have experience leading data architecture and modeling decisions in a complex, multi-source environment. The role will be responsible for maintaining, troubleshooting, and optimizing ETL processes, and will lead a small, high-performing BI team. The Business Intelligence Lead will also be responsible for ensuring data reliability and accuracy, updating data transformations, and collaborating with analysts and other stakeholders to drive an obsession with using data to inform decision making.

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

Benefits

• $110,000 - $120,000 a year
• 15% bonus potential