4-6 years in management consulting or commercial analytics with a consultative BI focus.
Expertise in SQL and Looker, with advanced Excel skills for modeling and reporting.
Experience using AI to automate workflows and connect databases.
Hands-on experience with Snowflake, BigQuery, or GCP for querying data.
Proficient in modern BI tools like Looker, Tableau, or Power BI, with a preference for LookML experience.
Strong communication skills to convey complex data insights to non-technical stakeholders.
Responsibilities
Lead data-driven alignment meetings, translating complex narratives for non-technical teams.
Utilize AI tools and advanced language models to automate data discovery and performance summaries.
Develop and optimize Looker dashboards to provide accurate commerce metrics.
Create actionable reports for various teams, identifying trends and root causes.
Implement frameworks for data validation and consistency across datasets.
Drive business conversations and collaborate with Editorial and SEO teams to enhance monetization.
Mentor the analytics team on generative AI tools and reporting efficiencies.
Benefits
Opportunity to work at the intersection of AI and data storytelling.
Hands-on role with a focus on modernizing data processes.
Proactive involvement in shaping business strategies through data insights.
Chance to mentor and lead within the analytics team.
Engagement with cutting-edge technologies and methodologies.
Full Job Description
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.
This is not a backend data engineering or data science role. Our data is already structured in Snowflake and BigQuery. 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 -Levraging 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 EveryDayHealth
Everyday Health Group is a digital media company which owns websites and produces content relating to health and wellness for consumers and medical professionals. For consumers, its brands include Everyday Health, Diabetes Daily, Migraine Again, DailyOM, What to Expect, BabyCenter, and Emma’s Diary. Its brands for professionals include Health eCareers, Prime Medical, MedPage Today, and Castle Connolly. Everyday Health Group is a division of the Ziff Davis media and internet conglomerate.
