Senior Business Intelligence Analyst – AI, Automation

This is a fully remote position, open to applicants in United States.

📋 Description

• Facilitate data-driven alignment meetings that involve significant business dependencies.

• Clearly articulate intricate data stories to teams without technical expertise.

• Integrate Snowflake and BigQuery with Claude, Gemini, and OpenAI via APIs and connectors.

• Automate routine processes for data discovery, anomaly detection, and performance reporting.

• Create and refine Looker Explores and dashboards utilizing LookML.

• Generate actionable reports for the Editorial, Sales, and Finance departments.

• Conduct dynamic data analyses to uncover root causes and trends at the category level.

• Establish validation, monitoring, and reconciliation frameworks for financial and commerce datasets.

• Lead business discussions, providing a unified source of truth for leadership.

• Collaborate with Editorial and SEO teams to enhance content monetization strategies.

• Work alongside Product teams to improve user conversion pathways.

• Advocate for the practical use of AI within the organization.

• Educate and mentor the analytics team on generative AI tools, prompt engineering, and database connectors.

⛳️ Requirements

• 3-5 years of practical experience in business intelligence, data analytics, or a similarly consultative data role.

• Proficient in SQL with hands-on experience querying Snowflake, BigQuery, or GCP on a daily basis.

• Extensive experience with contemporary BI platforms, such as Looker, Tableau, or Power BI.

• Proven ability to design complex, user-friendly, and scalable dashboards.

• Strong skills in Excel, including advanced modeling, pivot tables, and complex formulas.

• Highly adept at creating executive-level pitch decks using Google Slides or PowerPoint.

• Practical experience in leveraging AI to streamline workflows.

• Familiarity with setting up connectors, crafting advanced prompts, and utilizing LLMs like Claude or Gemini in conjunction with SQL databases.

• Experience with Looker and LookML is a significant advantage.

• Excellent communication and storytelling abilities.

• Capable of translating complex data into clear, non-technical business language and leading meetings with senior stakeholders.

• Knowledge of e-commerce and site performance metrics, such as CVR, CTR, RPV, and traffic sources.

• Familiarity with affiliate marketing networks like Impact, Partnerize, Rakuten, CJ, or Amazon Associates.

• A Bachelor's degree in Data Analytics, Business, Economics, Information Systems, or a related field is preferred.

• Willingness to work during significant shopping periods, including Black Friday, Cyber Monday, and Prime Day.

• Ability to work during EST hours.

🏝️ Benefits

• Comprehensive medical, dental, and vision insurance.

• Life and disability coverage.

• Flexible Spending Accounts (FSAs).

• 401(k) plan with company matching.

• Employee Stock Purchase Plan.

• Flexible Time Off policy.

• Volunteer Time Off opportunities.

• Paid holidays.

• Support for family building and caregiving.

• Family Care and Parental leave options.

• Fitness reimbursement.

• Wellness initiatives.

• Employee Resource Groups.

• Company-sponsored events.

• Educational assistance.

• Mentorship programs.

• Resources for career development.

• Programs for employee engagement.

• Recognition awards.