Senior Business Intelligence Analyst – AI & Automation

PCMag

. Modernize how data is extracted, automated, and presented .

Posted 11/5/2026full-timeRemote • United StatesSenior💰 $85,000 - $95,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data analytics and business intelligence, with a strong focus on SQL, Looker, and AI-driven automation. Capable of translating complex data insights into actionable business strategies while effectively communicating with both technical and non-technical stakeholders.

Highest-signal resume keywords

Advanced SQLLooker ExperienceData AnalyticsAI Workflow AutomationE-Commerce Metrics

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalyticsBusiness IntelligenceSQLLookerLookMLExcel ModelingDashboard DesignAPI IntegrationAnomaly DetectionPerformance Summaries

Soft Skills

Exceptional CommunicationStorytelling SkillsStakeholder ManagementMentoringProactive Leadership

Tools & Technologies

SnowflakeBigQueryTableauPower BIGoogle SlidesPowerPointClaudeGeminiGCPDatabase Connectors

Industry Keywords

E-CommerceSite Performance MetricsCVRCTRRPVTraffic SourcingContent MonetizationAnalytics Team TrainingPrompt EngineeringShopping Holidays

Tech Stack

Tools & technologies

BigQueryGoogle Cloud PlatformSnowflakeSQLTableau

About the role

Key responsibilities & impact

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

What you’ll need

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

Comp & perks

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