Senior Business Intelligence Analyst – AI & Automation
Job Description:
- Modernize how data is extracted, automated, and presented
- Translate complex data models into trusted, digestible insights
- Lead data-driven alignment meetings across major business dependencies
- Explain complex data narratives clearly to non-technical teams
- Connect Snowflake and BigQuery with Claude, Gemini, and OpenAI using APIs and connectors
- Automate routine data discovery, anomaly detection, and performance summaries
- Develop and optimize Looker Explores and LookML dashboards
- Build actionable reports for Editorial, Sales, and Finance
- Dynamically slice data to uncover root causes and category-level trends
- Implement validation, monitoring, and reconciliation frameworks across financial and commerce datasets
- Drive business conversations proactively
- Partner with Editorial and SEO teams to optimize content monetization
- Work with Product to enhance user conversion funnels
- Champion practical AI use internally
- Train and mentor the analytics team on generative AI tools, prompt engineering, and database connectors
- Monitor live data analysis and system integrity during major shopping holidays
Requirements:
- 3-5 years of hands-on experience in business intelligence, data analytics, or a highly consultative data role
- Advanced SQL and daily experience querying Snowflake, BigQuery, or GCP
- Strong experience with Looker, Tableau, or Power BI
- Experience designing complex, user-friendly, and scalable dashboards
- LookML experience is a strong advantage
- Advanced Excel modeling, pivots, and complex formulas
- Experience building executive-level pitch decks using Google Slides or PowerPoint
- Direct practical experience using AI to automate workflows
- Experience setting up connectors and writing advanced prompts
- Experience leveraging LLMs such as Claude or Gemini alongside SQL databases
- Exceptional communication and storytelling skills
- Ability to translate complex data into clear, non-technical business terms
- Ability to confidently run meetings with senior stakeholders
- Strong grasp of e-commerce and site performance metrics, including CVR, CTR, RPV, and traffic sourcing
- Familiarity with Impact, Partnerize, Rakuten, CJ, or Amazon Associates
- Bachelor’s degree in Data Analytics, Business, Economics, Information Systems, or a related field is preferred
- Ability to work EST hours
- Required to work on major shopping holidays, including Black Friday, Cyber Monday, and Prime Day
Benefits:
- Comprehensive medical, dental, and vision coverage
- Life and disability benefits
- Flexible Spending Accounts (FSAs)
- 401(k) with company match
- Employee Stock Purchase Plan
- Flexible Time Off
- Volunteer Time Off
- Paid holidays
- Family building and caregiving support
- Family Care and Parental leave
- Fitness Reimbursement
- Wellness programs
- Employee Resource Groups
- Company-sponsored events
- Educational support
- Mentorship programs
- Career development resources
- Employee engagement programs
- Recognition awards