Ecommerce Data Insights Analyst - Internal

London Drugs INTERNAL; Richmond; Remote; CAD 70,000 - 95,000; Full time

Benefits offered by this job

Flexible work from home

Job summary

London Drugs is seeking an Ecommerce Data Insights Analyst to turn data into actionable insights for our digital business. You will develop and maintain reporting solutions, build dashboards, automate processes, and provide analytical support across Ecommerce and related teams.

The role combines analytics, reporting, and BI in a fast-paced retail environment, with flexible work-from-home options and collaboration across Marketing, Merchandising, IT, and Fulfilment.

Qualifications

• Experience in data analytics, BI, reporting or related field.
• Advanced Excel skills including pivot tables and formulas.
• Experience building dashboards with BI tools (Power BI/Tableau).
• Working knowledge of SQL and GA4/Tag Manager helpful.
• Ability to translate data into actionable insights.

Responsibilities

• Build, maintain, and enhance reporting solutions for Ecommerce performance.
• Develop and optimize Power BI dashboards and BI tools.
• Create reports using Power BI, GA4, Looker Studio, and ecommerce systems.
• Implement Google Tag Manager tracking to support reporting.
• Collaborate with teams to provide analytics support and insights.

Tools

Power BI

Tableau

Looker Studio

Power Automate

Job description

As a valued London Drugs family member, the opportunities for career growth are unlimited! Here is a great chance for you to grow your skills and experience. We currently have the following opportunity in our Ecommerce division:

Are you passionate about turning data into meaningful business insights? Do you enjoy building dashboards, uncovering trends, and helping teams make informed decisions?

As an Ecommerce Data Insights Analyst, you'll play a key role in shaping the future of our digital business by transforming data into actionable insights that drive performance. You'll develop and maintain reporting solutions, build impactful dashboards, automate manual processes, and provide analytical support across Ecommerce and other business teams.

This is an exciting opportunity for a data-driven professional who enjoys combining analytics, reporting, business intelligence, and problem-solving in a fast-paced retail and ecommerce environment.

What You'll Do

Reporting & Dashboard Development

• Build, maintain, and enhance reporting solutions that provide visibility into Ecommerce performance
• Develop and optimize Power BI dashboards and business intelligence tools
• Create reports using platforms such as Power BI, Google Analytics 4 (GA4), Looker Studio, and ecommerce reporting systems
• Implement and maintain Google Tag Manager tracking to support accurate measurement and reporting
• Ensure stakeholders have access to reliable, timely, and easy-to-understand business insights

Data Analysis & Business Insights

• Analyze business performance data and investigate trends, opportunities, and challenges
• Translate complex data into actionable recommendations for non-technical audiences
• Support decision-making across merchandising, fulfilment, loss prevention, and leadership teams
• Identify patterns, opportunities, and operational improvements through data analysis

Automation & Data Integration

• Develop automated reporting processes that improve efficiency and reduce manual effort
• Write SQL queries to extract and validate data from internal systems
• Support data integration initiatives and maintain documentation for automated processes
• Continuously identify opportunities to streamline workflows through automation

Data Quality & Reporting Accuracy

• Monitor reporting accuracy and proactively investigate discrepancies
• Validate data sources and ensure consistent metric definitions• Troubleshoot reporting issues and identify root causes
• Maintain trusted reporting standards across the organization

Cross-Functional Collaboration

• Partner with teams across the business to provide reporting and analytics support
• Serve as a subject matter resource for Ecommerce metrics and reporting practices
• Collaborate with Ecommerce, Marketing, Merchandising, IT, Customer Care, Fulfilment, and other stakeholders
• Support testing, issue investigation, and ongoing Ecommerce initiatives as part of a collaborative team environment

What You Bring

• Experience in Data Analytics, Business Intelligence, Reporting, Ecommerce Analytics, or a related field
• Advanced Microsoft Excel skills, including pivot tables, formulas, and data analysis functions
• Experience developing dashboards and visualizations using Power BI, Tableau, Looker Studio, or similar tools
• Working knowledge of SQL and relational database concepts
• Experience with Google Analytics 4 (GA4) and Google Tag Manager
• Strong analytical, problem-solving, and critical thinking skills
• Excellent attention to detail and commitment to data accuracy
• Ability to communicate technical findings clearly to non-technical audiences
• Strong organizational skills with the ability to manage multiple priorities
• Effective verbal and written communication skills
• Experience with workflow automation tools such as Power Automate is considered an asset
• Ecommerce, digital commerce, retail, or omnichannel business experience is preferred

London Drugs is an equal opportunity employer. The above statements are intended to describe the general nature and level of work applicable to this position and are not intended to be an exhaustive list of all responsibilities, duties and skills required.

Flexible work from home options available.