Senior Advisor, Data & Analytics

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 performanc