Overview 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.OurRichmond Head Officecurrently has opportunities for:Data AnalystThe Data Analyst is responsible for supporting analytical projects, building dashboards, and delivering insights that drive business performance across the merchandise services organization. This role partners with the Manager, Master Data Management and cross-functional teams to conduct analyses, automate reporting, and provide data-driven recommendations across planning, pricing, space, and promotional functions.This is a foundational role in building the company\'s analytical capabilities, requiring someone who can extract and transform data, develop visualizations, and translate analytical findings into actionable insights for business stakeholders.As with all positions, this person embodies the core essence of the London Drugs Brand Framework by always going above and beyond the expected.Key Responsibilities Data Extraction & Analysis:Extract data from multiple systems using SQL and other data extraction tools to support analytical requestsConduct data analysis to identify trends, patterns, and insights across merchandise services functionsPerform data validation and quality checks to ensure accuracy and reliability of analytical work productsClean and transform raw data into analysis-ready datasets using analytical platformsSupport ad-hoc analytical requests from Manager, Master Data Management and functional leadersDashboard & Visualization Development:Build and maintain dashboards and visualizations using business intelligence tools to track key performance metricsDevelop automated reporting solutions that reduce manual effort and improve data timelinessDesign clear, compelling visualizations that communicate insights effectively to business audiencesPartner with functional teams to understand reporting requirements and dashboard preferencesMaintain dashboard accuracy through regular data refreshes and validation processesAnalytical Project Support:Support strategic analytical projects including category performance analysis, pricing studies, and promotional effectiveness reviewsConduct research and data gathering to support business cases and strategic recommendationsBuild analytical models and tools to improve efficiency and quality of recurring analysesDocument analytical methodologies, assumptions, and data sources to ensure reproducibilityPrepare presentations and summaries of analytical findings for stakeholder reviewCross-Functional Analytical Support:Partner with Planning, Pricing, Space, and other functional teams to deliver analytical supportTranslate business questions into analytical approaches and data requirementsConduct analyses that integrate data across multiple functions to provide holistic business insightsCommunicate findings clearly to business stakeholders with varying levels of analytical sophisticationIdentify data gaps and partner with IT and Master Data Management to address data availability issuesPlatform Development & Automation:Support implementation and optimization of analytical platforms and toolsBuild automated workflows that streamline data extraction, transformation, and reporting processesDevelop reusable analytical templates and frameworks to improve consistency and efficiencyTest and validate analytical tools and processes to ensure accuracy and reliabilityDocument technical processes and create user guides to enable self-service analyticsEducation & Experience Required Qualifications:Strong proficiency in SQL for data extraction, transformation, and analysisAdvanced Excel skills including pivot tables, formulas, and data modelingExperience with business intelligence and data visualization toolsStrong analytical and problem-solving skills with attention to detailExcellent communication skills; ability to translate data into clear insights for business audiencesAbility to manage multiple priorities and meet deadlines in a fast-paced environmentPreferred Qualifications:Experience with retail data including sales, inventory, pricing, or customer analyticsFamiliarity with advanced analytical platformsExperience with statistical software or programming languagesKnowledge of data warehousing concepts and cloud-based analytics platformsExperience supporting cross-functional analytical projectsIf you are a well organized, self-motivated, individual who has a positive attitude, a desire to support Company initiatives, and a commitment to achieving Company objectives, then we have the opportunity for you to excel!If you are interested in exploring opportunities but not sure where to start, talk to your Manager about this posting.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.#J-18808-Ljbffr