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

Boucherville, Quebec, Canada

Apply Now

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 CleaningData TransformationData ValidationRequirements AnalysisFunctional 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 are the key qualifications required for this role?

Candidates need a minimum of 3 years of experience in data analysis, mastery of SQL for data manipulation, and understanding of relational database structures. Experience with a BI tool is also required.

What benefits does Canam offer?

Benefits include flexible hours (35.5-hour week), hybrid work, 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, on-site cafeteria, and social club activities.

What is the company culture like at Canam?

Canam fosters a collaborative team environment focused on building the future, work-life balance, employee well-being, and shared success through social clubs, parties, tournaments, and a supportive alloy of achievements and wellness.

What makes a strong candidate for this BI analyst role?

A strong candidate will have at least 3 years in data analysis, strong SQL skills, knowledge of relational databases, and experience with BI tools, along with 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

Try Jobo Free