Bachelor's degree in computer science, engineering, business administration, data science, or related field.
Minimum 10 years of experience in business intelligence, data, and analytics, including senior or architecture roles.
Proven track record in delivering enterprise BI programs with measurable outcomes.
Experience designing semantic models, KPIs, and dashboards at an enterprise scale.
Familiarity with enterprise data warehouse or data lake platforms, particularly Snowflake or similar.
Experience in CPG, food and beverage, or manufacturing is a plus.
Bilingual in French and English, essential for communication across regions.
Responsibilities
Contribute to the enterprise BI vision, roadmap, and architecture.
Engage with leaders across departments to validate use cases and translate them into BI products.
Define BI standards and best practices for project teams.
Track and communicate the benefits of BI initiatives through KPIs.
Act as a trusted advisor for analysts and business users, promoting new data practices.
Design and govern the enterprise semantic layer and KPI definitions.
Lead the modernization of the BI estate, migrating reports to Power BI.
Benefits
Competitive salary with opportunities for advancement.
Remote work options available based on company policy.
Group insurance and pension plan with employer contributions.
Telemedicine and employee assistance programs.
Health and wellness programs, including an on-site gym.
Company-organized activities for team engagement.
Full Job Description
Reporting to the Director, Data and Analytics, the Senior Advisor is responsible for building Lassonde's enterprise business intelligence capabilities across Canada and the United States. The role covers both the data foundations (back-end) and the reporting and analytics experience (front-end), so that business teams have access to trusted, consistent and self-serve data and KPIs.
Job advantages
A competitive salary with opportunities for advancement and career development.
Remote work may be available in accordance with the company's current policy and the requirements of the role.
A group insurance plan and a pension plan with employer contributions.
Telemedicine and an employee and family assistance program.
Recognition and health and wellness programs.
An on-site gym in Rougemont.
Activities organized by the company.
Key activities
Enterprise BI strategy and stakeholder engagement:
Contribute to the enterprise BI vision, roadmap and target architecture.
Engage Supply Chain, Commercial, Finance, R&D and Operations leaders to validate priority use cases and translate them into BI products with clear owners and value cases.
Define the BI standards, patterns and best practices that guide project teams and the BI team.
Track the benefits of BI initiatives through KPIs tied to business outcomes and communicate their impact to leadership.
Act as a trusted advisor and coach for analysts, developers and business users, and support the adoption of new data practices and tools.
BI experience, semantic layer and self-serve analytics:
Design and govern the enterprise semantic layer and the certified KPI definitions so that business users access trusted, consistent metrics.
Modernize the BI estate: rationalize the reporting portfolio, define the target reporting platforms and lead the migration of existing Cognos 11 analytical reports to Power BI or equivalent dashboards.
Define dashboard and report design standards (usability, visual consistency, performance) and the certification and lifecycle process for reports.
Enable self-serve access to trusted data through training, documentation, a support model and adoption metrics.
Build and coach a community of BI developers and power users across the business functions.
Back-end: data foundations and BI platforms:
Define and evolve the target data architecture for BI: ingestion, data lake, cloud data warehouse (e.g. Snowflake), integration patterns and environments.
Lead the evolution of the data warehouse toward a North American warehouse and support the integration of Canadian and U.S. data environments.
Design and oversee ETL/ELT pipelines and dimensional data models that connect the enterprise source systems (ERP, supply chain, commercial, finance, HR).
Implement data quality rules, monitoring, metadata, catalog and lineage, working with the governance and master data teams.
Ensure the performance, security, access control and resilience of the data platforms, in partnership with Cybersecurity and Infrastructure.
Prepare the data foundation for advanced analytics and the future integration of artificial intelligence.
BI security and privacy:
Define and apply access control standards for BI content and data (role-based and row-level security, certified datasets), in partnership with Cybersecurity and Infrastructure.
Embed privacy by design in BI solutions and data models (classification, minimization, masking) in line with Quebec Law 25, PIPEDA and applicable U.S. state privacy regimes, working with Legal and Privacy.
Monitor and audit access to and use of sensitive data, and ensure that reports used for financial and legal reporting are reliable, traceable and consistent.
Required training and experience
Bachelor's degree in a relevant discipline (computer science, engineering, business administration, data science or related field).
Minimum 10 years of progressive experience in business intelligence, data and analytics, including experience in a senior, lead or architecture role.
Proven track record delivering enterprise BI programs (platform modernization, migration, reporting rationalization) with measurable business outcomes.
Experience designing semantic models, KPIs and dashboards at enterprise scale.
Experience designing and operating enterprise data warehouse or data lake platforms, including Snowflake or other modern cloud data warehouses, and data pipelines at scale.
Experience in CPG, food and beverage or manufacturing (an asset).
Experience in a multi-site, multi-country environment (an asset).
Skills sought
Bilingual (French/English), both written and spoken - essential for communication with English-speaking colleagues, clients, and suppliers across provinces and internationally.
Strong influence and communication skills, with the ability to translate among executive, business, IT and technical audiences.
Pragmatic, outcome-driven approach with good prioritization skills.
Change leadership skills in a complex, evolving organization.
Knowledge of source systems used in a manufacturing and CPG business (operations, supply chain, commercial, finance, HR).
Expert knowledge of Power BI and other modern data visualization tools (e.g. Tableau), including semantic modelling (e.g. Power BI semantic models).
Strong data visualization and user experience skills.
Advanced proficiency in SQL, ETL processes, dimensional modelling (Snowflake or other modern cloud data warehouses, SQL Server, SSIS or equivalent) and data warehouse concepts.
Deep working knowledge of modern data architecture (data lake, cloud data warehouse such as Snowflake or equivalent, integration, catalog and lineage).
Knowledge of data quality, observability, orchestration and CI/CD practices applied to data.
Working knowledge of data security and privacy practices (access control, data classification) and of Quebec Law 25 and PIPEDA as they apply to BI.
Ability to build data literacy and drive adoption across non-technical teams.
Rigorous and detail-oriented, with a strong sense of ownership.
Specific conditions to the position:
Must be legally authorized to work in Canada.
Ability to travel withing Canada and the United States as required.
What success looks like
Success in this role results in a modern, reliable, and consistent BI environment, which empowers teams to make informed decisions based on trusted data. The person will also help increase the adoption of BI solutions and evolve data foundations to support future business needs.
