Senior Business Intelligence Analyst – AI & Automation

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

📋 Description

• Revamp the methods used for data extraction, automation, and presentation.

• Convert intricate data models into reliable and easily understandable insights.

• Facilitate data-driven alignment meetings across key business dependencies.

• Clearly articulate complex data narratives to non-technical teams.

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

• Streamline routine processes for data discovery, anomaly detection, and performance summaries.

• Design and enhance Looker Explores and LookML dashboards.

• Create actionable reports for Editorial, Sales, and Finance departments.

• Dynamically analyze data to identify root causes and category-level trends.

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

• Proactively lead business discussions.

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

• Work alongside Product teams to improve user conversion funnels.

• Advocate for practical AI applications within the organization.

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

• Oversee live data analysis and system integrity during peak shopping periods.

⛳️ Requirements

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

• Proficient in SQL with daily experience querying Snowflake, BigQuery, or GCP.

• Strong proficiency in Looker, Tableau, or Power BI.

• Experience in designing complex, user-friendly, and scalable dashboards.

• LookML expertise is a significant advantage.

• Advanced skills in Excel modeling, pivots, and complex formulas.

• Experience in creating executive-level pitch decks using Google Slides or PowerPoint.

• Practical experience in utilizing AI for workflow automation.

• Familiarity with setting up connectors and crafting advanced prompts.

• Experience in leveraging LLMs such as Claude or Gemini alongside SQL databases.

• Outstanding communication and storytelling abilities.

• Capacity to translate complex data into clear, non-technical business language.

• Confidence in leading meetings with senior stakeholders.

• Strong understanding of e-commerce and site performance metrics, including CVR, CTR, RPV, and traffic sourcing.

• Knowledge of Impact, Partnerize, Rakuten, CJ, or Amazon Associates.

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

• Availability to work during EST hours.

• Must be available to work on major shopping holidays, such as Black Friday, Cyber Monday, and Prime Day.

🏝️ Benefits

• Comprehensive medical, dental, and vision insurance.

• Life and disability insurance benefits.

• Flexible Spending Accounts (FSAs).

• 401(k) plan with company matching.

• Employee Stock Purchase Plan.

• Flexible Time Off policy.

• Volunteer Time Off.

• Paid holidays.

• Support for family building and caregiving.

• Family Care and Parental leave.

• Fitness reimbursement.

• Wellness initiatives.

• Employee Resource Groups.

• Company-sponsored events.

• Educational assistance.

• Mentorship opportunities.

• Career development resources.

• Employee engagement initiatives.

• Recognition awards.