Senior Business Intelligence Analyst – Commercial Strategy

Ziff Davis; Vancouver; On-site; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

Life insurance

Disability benefits

Flexible Spending Accounts

401(k) with company match

Flexible Time Off

Volunteer Time Off

Paid holidays

Family building support

Parental leave

Fitness reimbursement

Wellness programs

Job summary

Ziff Davis is seeking a Senior Business Intelligence Analyst to modernize how we extract, automate, and present data. You will be a hands-on builder, translate complex data models into trusted insights, and apply AI automation to deliver a single version of truth for leadership.

You will develop Looker dashboards with LookML, connect AI APIs, and collaborate with Editorial, Sales and Finance to uncover root causes and drive strategic decisions across the organization.

Qualifications

• 4 - 6 years of management consulting, commercial analytics or a highly consultive BI role.
• Advanced Excel modeling with pivots and complex formulas; capable of executive-level decks.
• Experience using AI to automate workflows with connectors and prompts.
• Proficient SQL on Snowflake/BigQuery/GCP.
• Experience with Looker, LookML, Tableau, Power BI; strong dashboard design.
• Excellent communication and storytelling; capable of presenting to senior stakeholders.

Responsibilities

• Lead data-driven alignment meetings with key business stakeholders.
• Use AI tools to accelerate data discovery and automate reporting.
• Develop and optimize Looker Explores and dashboards with LookML.
• Create actionable reports for Editorial, Sales, and Finance.
• Implement validation and reconciliation frameworks for data accuracy.
• Partner with Editorial, SEO and Product to improve monetization and funnels.
• Mentor analytics team on generative AI usage and connectors.

Skills

SQL

BI tools

AI prompts

Executive storytelling

Excel advanced modeling

Presentation decks

Data storytelling

Stakeholder management

Education

Bachelor’s degree in Data Analytics, Business, Economics, Information Systems, or related field

Tools

Looker

LookML

Tableau

Power BI

Snowflake

BigQuery

GCP

AI APIs (Claude, Gemini, OpenAI)

Job description

The Opportunity:

We are looking for a highly skilled and intellectually curious Senior Business Intelligence Analyst to completely modernize how we extract, automate, and present data. This role sits at the exact intersection of AI automation and data storytelling. We need a hands-on builder with 3 to 5 years of experience who can translate complex data models into trusted, easily digestible insights.

Description

Position at Consumer Tech

We are looking for a highly skilled and intellectually curious Senior Business Intelligence Analyst to completely modernize how we extract, automate, and present data. This role sits at the exact intersection of AI automation and data storytelling. We need an analyst who is a wizard with SQL and BI tools, knows how to connect AI APIs (like Claude or Gemini) to automate routine analysis, and can package those insights into clear, business-ready slides.

You will act as your own stakeholder. We expect you to bring a proactive, consulting mindset -Leveraging existing data infrastructure, using cutting-edge generative AI technologies to automate manual reporting, and stepping up to confidently deliver a "single version of truth" to leadership without waiting for a script.

Key Responsibilities:

• Be a true stakeholder and lead data-driven alignment meetings across all major business dependencies, explaining complex data narratives clearly to non-technical teams.
• Utilize modern AI tools (Snowflake / BigQuery) with advanced language models (Claude, Gemini, OpenAI) and LLM'S to accelarate Data discovery to automate routine data discovery, anomaly detection, and performance summaries.
• Develop and optimize intuitive Looker Explores and dashboards using LookML to ensure our cross-functional teams have a single, accurate version of the truth for all commerce metrics.
• Move away from generic data dumps. Build specific, actionable reports for Editorial, Sales, and Finance, dynamically slicing the data to uncover root causes and category-level trends when basic metrics drop.
• Implement validation, monitoring, and reconciliation frameworks to ensure accuracy, consistency, and a single version of truth across all financial and commerce datasets.
• Run data alignment meetings and proactively drive the business conversation. Partner with Editorial and SEO teams to optimize content monetization and work with Product to enhance user conversion funnels.
• Act as the internal champion for practical AI use. Train and mentor the existing analytics team on how to use generative AI tools, prompt engineering, and database connectors to speed up their daily reporting tasks.

Job Qualifications:

• 4 - 6 years of management consulting, commercial analytics or a highly consultive BI Role. We are looking for a hungry, upward-trajectory builder.
• Beyond SQL and Looker, you are an absolute surgeon in Excel (advanced modeling, pivots, complex formulas) and highly skilled at building compelling, executive-level pitch decks (Google Slides / PowerPoint).
• Direct, practical experience utilizing AI to automate workflows. You know how to set up connectors, write advanced prompts, and leverage LLMs (Claude, Gemini) alongside SQL databases to automate data analysis.
• Intermediate-level SQL skills with strong, daily hands-on experience querying enterprise cloud data platforms (specifically Snowflake, BigQuery, or GCP).
• Deep experience with modern BI platforms (Looker, Tableau, Power BI) to design complex, user-friendly, and scalable dashboards. If you have specific experience with Looker and LookML, that is a strong advantage.
• Exceptional communication and storytelling skills. You must be able to translate complex data into clear, non-technical business terms and confidently run meetings with senior stakeholders.

Preferred Qualifications:

• A strong grasp of e-commerce and site performance metrics, including conversion rate (CVR), click-through rate (CTR), revenue per visit (RPV), and traffic sourcing.
• Familiarity with performance tracking and affiliate marketing networks (Impact, Partnerize, Rakuten, CJ, Amazon Associates).
• Bachelor’s degree in Data Analytics, Business, Economics, Information Systems, or a related field.

Special Working Conditions:

• This role requires working on major shopping holidays (e.g., Black Friday, Cyber Monday, Prime Day) to monitor live data analysis, provide insights, and system integrity.
• Shift Timings: EST hours

About CNET Group:

CNET Group (part of Ziff Davis) represents a growing portfolio of trusted digital media brands—including CNET, PCMag, Mashable, Lifehacker, and ZDNet—specializing in tech reviews, news, and advice. Reaching over 81 million monthly users, we help consumers navigate, purchase, and enjoy technology through expert analysis and in-depth reporting. Our content empowers the world to use tech for personal development in all areas of life, and we seamlessly guide our readers toward the products and services that make their lives better.

About Ziff Davis:

Ziff Davis (NASDAQ: ZD) is a vertically focused digital media and internet company whose portfolio includes leading brands in technology, shopping, gaming and entertainment, connectivity, health, cybersecurity, and martech. Today, Ziff Davis is focused on seven key verticals - Technology, Connectivity, Shopping, Entertainment, Health & Wellness, Cybersecurity and Marketing Technology. Its brands include IGN, Mashable, RetailMeNot, PCMag, Humble Bundle, Spiceworks, Everyday Health, BabyCenter, Moz, iContact and Vipre Security.

Our Benefits:

• CNET Group offers competitive salaries in addition to robust, health and wellness-focused benefits, including comprehensive medical, dental, and vision coverage, as well as life and disability benefits.
• Our employees enjoy Flexible Spending Accounts (FSAs), a 401(k) with company match, and an Employee Stock Purchase Plan.
• We are committed to work-life balance with Flexible Time Off, Volunteer Time Off, and paid holidays.
• We offer family building and caregiving support and generous Family Care and Parental leave, when you need it.
• We also provide Fitness Reimbursement and access to wellness programs, ensuring our team stays healthy both physically and mentally.

At Ziff Davis, we remain dedicated to creating an environment where everyone feels valued, respected, and empowered to succeed. We offer Employee Resource Groups, company-sponsored events, and regular opportunities for professional growth through educational support, mentorship programs, and career development resources. Our employees are recognized and celebrated through employee engagement programs and recognition awards.

If you're seeking a dynamic and collaborative work environment where you can see the direct impact of your performance and thrive both personally and professionally, then CNET Group is the place for you.

Ziff Davis is an Equal Opportunity Employer. At Ziff Davis, Diversity, Equity, and Inclusion (DEI) has always been about fairness, equal opportunity, and belonging. DEI enables us to attract and retain the best talent, regardless of background or circumstances, while enabling our thousands of employees worldwide to thrive.

#CNETGroup