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

Construction, ManufacturingIndustries

Requirements

Minimum de 3 ans d’expérience en analyse de données
Maîtrise de SQL pour la manipulation des données
Compréhension des structures de bases de données relationnelles
Capacité à naviguer dans l'ambiguïté
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 pour 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 pour garantir l'exactitude et l'intégrité

Skills

Key technologies and capabilities for this role

BIETLELTData AnalysisData ValidationRequirements GatheringFunctional SpecificationsData CleaningData Transformation

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 possibilities to work from offices in Boucherville, Québec, or Saint-Georges. It supports a flexible schedule of 35.5 hours per week for work-life balance.

What benefits does Canam offer?

Benefits include group insurance from day one (life, disability, medications, dental, travel) with employer contributions, a defined contribution pension plan, employee assistance program, free telemedicine, annual wellness contribution, free coffee, on-site cafeteria, and social club activities.

What skills are required for this BI functional analyst role?

Candidates need a minimum of 3 years of data analysis experience, mastery of SQL for data manipulation, and understanding of relational database structures. Additional skills include analyzing business needs, documenting ETL/ELT processes, and data validation.

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 outings to encourage team bonding.

What makes a strong candidate for this position?

A strong candidate has at least 3 years of data analysis experience, strong SQL skills, and the ability to bridge business needs with data platforms through clear functional specifications and ETL documentation.

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