Laurentian Bank of Canada is a banking institution whose activities extend across Canada. Founded in 1846, the Bank is guided by values of proximity, simplicity and honesty, and its mission is to help clients improve their financial health. Laurentian Bank serves one and half million throughout the country and employs more than 3,600 people, whose talent and devotion make the Bank a solid player in several market segments.Working at Laurentian Bank means:-Growing within an ambitious team where everyone grows with pride. -Helping build a future where you and your team make a valued contribution. -Making a difference in clients' lives and the Bank's development. The Laurentian Bank is committed to creating a diverse and inclusive environment. We are proud to offer equal opportunities to all of our employees, and we support applicants in the designated groups of the Employment Equity Act.For the description please refer to the French version below.Relevant du Directeur Principal Intelligence d'affaires, le titulaire du poste coordonne le travail et supervise l'exécution des tâches d'un groupe de professionnels BI. Dans le cadre de son rôle au sein du Centre de Compétences en Intelligence d'Affaires (CCIA), il aura pour mission principale de s'assurer de l'arrimage des activités de développement sur plusieurs mandats menés en parallèle, et ce, en étroite collaboration avec les différentes parties prenantes. Le titulaire du poste devra également offrir un service conseil en gestion par bases de données et d'intelligence d'affaires, afin d'orienter les décisions stratégiques. Dans un contexte de changement, le titulaire du poste devra assurer une gestion opérationnelle efficace et agile des professionnels sous sa responsabilité et mettre en place des mécanismes efficients de suivi. Il s'assure que toute la documentation pertinente concernant les projets et initiatives en cours et futurs soit en place, standardisée, à jour et disponible pour les différents intervenants. Il sera appelé à rédiger et présenter des brefs stratégiques pour les initiatives qui en nécessitent.
ºConsult with internal business stakeholders to document BI requirements ºReview requests for BI solutions as required (including Reports, Data Extracts, Analytic Cubes, and Dashboards) and assist the BICC Team Lead in estimating the work effort needed for development, testing and deployment of BI solutions.ºComplete the development, testing and deployment of BI solutions, as assigned by the BICC Team Lead, including, but not limited to;oAnalyse source data and document the requirements for the requested BI solutions, including any data transformation methodologies as neededoPrepare the functional specifications of the various developments and validate the results in cooperation with teammates and users. oDevelop and maintain any additional required documentation and reference structures (including business rules, best practices, methodologies, etc.) for all BI products for which the business unit is responsible. oCreate multi-dimensional data sets from the source data to be used in the creation of required BI products.oDevelop and test the BI solutions as defined. oSupport the implementation of the BI solution in production.ºParticipate in the design and development of BI solutions for corporate initiatives, where required.ºEvaluate the data quality and accuracy of the BI products with internal stakeholders.ºProvide data analysis to support the development of predictive models and relationship marketing campaigns and to help orient strategic decisions, the Bank's positioning, and program development. ºParticipate actively in deployment, post-implementation monitoring and development of all BI products and related projects. ºEnsure rigorous monitoring of development activities and solutions to ensure compliance with set deadlines and budgets. ºHelp support BI production activities when required.ºEstablish and maintain effective communication with stakeholders and partners of the team and business lines. ºKeep updated on all existing and future Enterprise Data Warehouse structures, end-to-end processes and core technologies. ºPerform all tasks of a similar or general nature requested by his or her superior or required for the job.
ºUniversity degree or diploma (or certification) in computer science, business intelligence, or related field, with at least 10 yrs of work experience.ºAt least 5 + years related experience in a similar role as a BI or OLAP Analyst / Developer ºStrong knowledge, skills and experience working on large scale EDW/BI projects and/or operational teams, within Oracle and/or SQL Server database environments. ºStrong knowledge, skills and experience with SQL, and writing SQL queries.ºStrong knowledge, skills and experience as an OLAP Developer, creating analytic cubes, reports and dashboards with IBM Cognos. ºDemonstrated knowledge, skills and experience working with business stakeholders to assess BI needs.ºDemonstrated knowledge, skills and experience documenting BI functional and technical requirements.ºDemonstrated knowledge, skills and experience working with complex data sets, and performing data analysis.ºDynamic, autonomous/resourceful and focused on results. ºFocused on teamwork and collaboration. ºBilingual (French/English) verbal and written communication skills are assets.ºKnowledge and experience working with Data Profiling tools would be an asset.ºKnowledge and experience with SAS, and predictive modelling tools would be an asset. ºKnowledge of the banking industry would be an asset.