Analyste fonctionnel en intelligence d'affaires (BI) at Canal

Québec City, Quebec, Canada

Canal Logo
Not SpecifiedCompensation
Junior (1 to 2 years), Mid-level (3 to 4 years)Experience Level
Full TimeJob Type
UnknownVisa
Manufacturing, ConstructionIndustries

Requirements

  • Minimum de 3 ans d’expérience en analyse de données
  • Maîtrise de SQL pour la manipulation des données, et compréhension des structures de bases de données relationnelles
  • Expérience avec un outil de visualisation (ex. : Tableau, Power BI)
  • Connaissance de la Suite Atlassian (ex. : Jira, Confluence)
  • Maîtrise de l'anglais parlé et écrit

Responsibilities

  • Analyser et documenter les besoins précis de l’entreprise en matière de données d’intelligence d’affaires
  • Transformer les requis des unités d'affaires en spécifications fonctionnelles claires
  • Répondre aux questions de l’équipe de développement BI afin de clarifier la structure et la signification des données sources
  • Documenter les processus d’extraction de données (ETL/ELT), en utilisant des méthodologies appropriées pour assurer la traçabilité
  • Participer au nettoyage, à la transformation et à la validation des données, garantissant l'exactitude et l'intégrité de toutes les données migrées et utilisées

Skills

Key technologies and capabilities for this role

Business IntelligenceETLELTData AnalysisData DocumentationData ValidationData CleaningData TransformationFunctional Specifications

Questions & Answers

Common questions about this position

What is the work arrangement for this position?

The role offers a hybrid work mode including on-site presence and telework, with possibility to work from offices in Boucherville, Québec, or Saint-Georges. It is listed as on-site location type but supports flexible hybrid options.

What benefits does Canam offer?

Benefits include flexible 35.5-hour workweek, profit sharing, group insurance from day one (life, disability, medications, dental, travel), defined contribution pension plan, employee assistance program, free telemedicine, wellness contribution, free coffee, and social club activities.

What skills are required for this BI analyst role?

Required skills include minimum 3 years of data analysis experience, mastery of SQL for data manipulation and understanding relational database structures, experience with visualization tools like Tableau or Power BI, and knowledge of Atlassian Suite such as Jira and Confluence.

What is the company culture like at Canam?

Canam fosters a collaborative team environment focused on building the future, work-life balance, well-being, and achievements, with social clubs, parties, tournaments, and an emphasis on collective success.

What makes a strong candidate for this position?

A strong candidate will have at least 3 years of data analysis experience, strong SQL skills, familiarity with BI visualization tools and Atlassian Suite, and the ability to analyze business needs, document ETL processes, and collaborate with development teams.

Canal

E-commerce platform for multi-brand selling

About Canal

ShopCanal.com is an e-commerce platform designed to support multi-brand selling for retailers, platforms, and creators. It allows businesses to sell products from various brands, which helps them attract more customers and increase sales. The platform operates on a co-selling model, enabling businesses to collaborate with brands they admire, which is a more effective approach than traditional affiliate marketing. This model not only enhances brand partnerships but also broadens the reach of businesses across the internet. ShopCanal likely generates revenue through a commission or fee structure, earning a percentage of the sales made on its platform. Users appreciate the platform for its user-friendly design and growth potential, recognizing the advantages of co-selling and brand collaborations. The goal of ShopCanal is to help its clients achieve their sales objectives more quickly and efficiently.

San Francisco, CaliforniaHeadquarters
2021Year Founded
$26.3MTotal Funding
SERIES_ACompany Stage
Consulting, Consumer GoodsIndustries
51-200Employees

Benefits

Competitive compensation packages
Unlimited PTO + 12 company holidays
Quality health, vision, & life insurance
401k plans with 3% employer contribution
Commuter benefits
Home office stipends
All-day snacks + dinner provided after 5:30pm

Risks

Increased competition from similar e-commerce platforms could dilute Canal's market share.
Economic downturns may impact Canal's revenue due to reduced consumer spending.
Reliance on commission-based revenue may be unsustainable if partner brands' sales decline.

Differentiation

Canal offers a curated network of over 165 brands for co-selling.
ShopCanal.com facilitates multi-brand selling, enhancing retailer and creator collaborations.
Canal's co-selling model is a stronger alternative to traditional affiliate marketing.

Upsides

Increased consumer preference for curated shopping experiences boosts Canal's platform demand.
The rise of social commerce presents integration opportunities for Canal's platform.
Growing sustainability trends allow Canal to promote eco-friendly brands, attracting conscious shoppers.

Land your dream remote job 3x faster with AI