Job Title

Data Analyst, Consumer & Commercial AnalyticsMade by Gather - the company behind Americas fastest-growing kitchenware brands. Founded in 2003 by entrepreneur Shae Hong, Made by Gather makes super-premium design and innovation accessible through our brands Beautiful by Drew and bella. Weve spent 20+ years developing our special sauce.Hybrid work scheduleSummer FridaysFree access to fitness center with lockers and showers in office buildingPrivate courtyardDirect access to McGill metro station and REM stationAdjacent to Time Out Market and other restaurants and retailersDynamic environment surrounded by beauty; we provide coffee, drinks, and snacksIf youre looking for a workplace that values initiative, creativity, and results while providing tools to grow through learning and development programs, this is the place for you.About The RoleOur teams make decisions daily using a wide range of data: sales, digital shelf, media, reviews, audience, brand equity, and surveys. They need fast, reliable answers to move forward.Thats where you come in. This role keeps the business running on data day-to-day. Youll build recurring reports, answer one-off questions, and develop dashboards that enable self-service.Youll also maintain our data foundation: metric definitions, documentation, quality checks, and privacy standards. Youll work closely with data science and cross-functional teams including marketing, sales, product, and insights.Every team relies on data. The analyst who owns reporting, dashboards, and the semantic layer has a major impact on decision-making. Youll gain exposure across brands, channels, and functions while building the foundation that enables speed and trust.ResponsibilitiesReporting, ad-hoc analysis, and dashboardsOwn recurring deliverables like weekly/monthly scorecards, trackers, and leadership readouts.Ensure reports are accurate, timely, and clear; investigate discrepancies before sharing.Be the go-to for ad-hoc requests from brand, marketing, and commercial teams.Turn questions into insights using sources like Circana, Profitero, media platforms (Amazon, Walmart Connect, Target Roundel, Meta, TikTok), GWI, BERA, Yogi, and custom surveys.Build and maintain dashboards designed for usability; if its not used, its not effective.Handle ad-hoc data pulls from the warehouse without needing full pipeline builds.Design, field, and analyze primary research (pulse checks, concept tests, pricing, messaging). Write questionnaires, set logic and quotas, and translate results into actionable insights.Hands-on data governanceOwn metric definitions and shared dimensions powering dashboards.Maintain a clear data dictionary so metrics are consistently understood.Document data sources, including scope, refresh cadence, and limitations.Build and run quality checks to catch errors before reports are shared.Maintain naming conventions and taxonomy across files and dashboards.Identify and resolve inconsistencies across reports.Handle consumer data in compliance with GDPR, CCPA, and internal standards.Qualifications23 years of analytics, BI, or reporting experience, ideally with consumer, retail, CPG, or media data.Strong SQL skills; able to write clean queries using joins, CTEs, and window functions.Comfortable with Snowflake or similar cloud warehouses and performance considerationsExperience building dashboards in Power BI; Tableau or Looker also relevant.Strong Excel skills (cleaning, pivoting, lookups).Experience combining multiple data sources into clear insights.Solid understanding of survey methodology and tools like Alchemer, Qualtrics, or SurveyMonkey. Familiar with techniques like conjoint, MaxDiff, and A/B testing.High attention to detail and accuracy.Clear written communication; able to translate data into insights.Service-oriented mindset; dependable for stakeholders.Understands importance of documentation, naming, and data operations.Bonus QualificationsExperience with dbt (models, testing, dependencies).Experience with syndicated data sources (Circana/IRI, Profitero, GWI, BERA, Yogi, Kantar, SEMRush).Advanced quantitative research experience (conjoint, MaxDiff, van Westendorp, TURF) or A/B testing.Familiarity with retail media (Amazon Ads, Walmart Connect, Target Roundel) and/or digital platforms (Meta, TikTok, Google).Experience with data catalog/documentation tools.Awareness of data privacy frameworks (GDPR, CCPA).PowerPoint skills for presenting insights.Data Analyst, Consumer & Commercial AnalyticsNous sommes une entreprise de biens de consommation spcialise dans les petits appareils lectromnagers et produits de cuisine. Nos quipes utilisent quotidiennement des donnes varies : ventes, prsence digitale, mdias, avis, audience, quit de marque et enqutes, et ont besoin de rponses rapides et fiables.Cest l que vous intervenez. Ce rle est au cur des oprations data quotidiennes. Vous construirez des rapports rcurrents, rpondrez des analyses ponctuelles et dvelopperez des tableaux de bord en libre-service.Vous serez galement responsable de lorganisation des donnes : dfinitions, documentation, qualit et confidentialit. Vous collaborerez avec la data science et les quipes marketing, commerciales, produit et insights.Chaque quipe sappuie sur les donnes. Ce rle a donc un impact direct sur la prise de dcision. Vous interviendrez sur plusieurs marques, canaux et fonctions tout en renforant les fondations data de lentreprise.ResponsabilitsReporting, analyses ad hoc et tableaux de bordGrer des livrables rcurrents (tableaux de bord, suivis, prsentationGarantir prcision, clart et respect des dlais; investiguer les carts.Transformer les questions en analyses via des sources comme Circana, Profitero, plateformes mdias, GWI, BERA, Yogi et enqutes.Construire des tableaux de bord orients utilisateur.Raliser des extractions ad hoc depuis lentrept de donnes.Concevoir et analyser des tudes (tests rapides, concepts, prix, messages) et produire des recommandations exploitables.Gouvernance des donnesGrer les dfinitions de mtriques et dimensions.Maintenir un dictionnaire de donnes clair et cohrent.Documenter les sources, frquences et limites.Mettre en place des contrles qualit.Maintenir des conventions de nommage cohrentes.Identifier et rsoudre les incohrences.Grer les donnes consommateurs selon le RGPD, CCPA et standards internes.Qualifications2 3 ans dexprience en analytique, BI ou reporting.Matrise de SQL (requtes structures, jointures, fonctions avances).Exprience avec Snowflake ou quivalent.Exprience Power BI (Tableau/Looker un plus).Excellente matrise dExcel.Capacit combiner plusieurs sources de donnes.Bonne connaissance des mthodologies denqute et outils associs.Rigueur, prcision et sens du dtail.Clart rdactionnelle.Orientation service et collaboration.Comprhension des fondamentaux de gouvernance des donnes.Qualifications supplmentairesExprience avec dbt.Exprience avec donnes syndiques (Circana/IRI, Profitero, GWI, BERA, Yogi, Kantar, SEMRush).Exprience en recherche quantitative avance ou tests A/B.Connaissance des plateformes mdia et marketing digital.Exprience avec outils de documentation data.Connaissance des cadres de confidentialit (RGPD, CCPA).Comptences PowerPoint.