Seeing beyond numbersº
At Laurentian Bank, we believe we can change banking for the better. Founded in Montreal in 1846, Laurentian Bank helps families, businesses and communities thrive.
Today, we have over 2,800 employees working together as One Team, to provide a broad range of financial services and advice-based solutions for customers across Canada and the United States.
We drive results by placing our customers first, making the better choice, acting courageously, and believing everyone belongs.
This role sits within LBC Tech, a subsidiary of Laurentian Bank Financial Group.
reports, data extracts, data marts, analytic cubes as well as ad-hoc reporting solutions. He or she will also participate in the analysis, development and implementation of BI solutions needed for marketing campaigns and Key Performance Indicators (KPI's).
The current core BI components are based in IBM technology, and include IBM Cognos, IBM Data Manager, IBM Campaign Manager, but additional technologies are being incorporated in such as MicroStrategy and TABLEAU.
ºAct as a BI liaison between the internal business stakeholders and the Enterprise Data Warehouse / BI Solution Team
ºConsult with internal business stakeholders to document BI requirements and recommend appropriate BI solutions
ºReview requests for BI solutions as required (including Data Extracts, ETL, Analytic Cubes, Reports and Dashboards) and assist the BI Solution 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
for all BI products for which the business unit is responsible
ºParticipate in the design and development of BI solutions for corporate initiatives, where required
ºSupport the internal business stakeholders for various business data inquiries.
ºEvaluate the data quality and accuracy of the BI products with internal stakeholders
ºProvide complex 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 10yrs of work experience
º7 + years related experience in a similar role as a BI or OLAP Analyst / Developer
ºExpert knowledge, skills and experience working on large scale EDW / BI projects and / or operational teams, within Oracle and / or SQL Server database environments
ºExpert knowledge, skills and experience with SQL, and writing SQL queries
ºKnowledge, skills and experience as an ETL tools developer.
ºExpert knowledge, skills and experience as an OLAP Developer, creating analytic cubes, reports and dashboards.
º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 results oriented.
ºFocused on teamwork and collaboration.
ºFully bilingual, with exceptional communication skills, both written and verbal, in English and French.
ºDevelopment experience in TABLEAU would be a strong asset.
ºKnowledge and experience with in-cloud solutions would be a strong asset
ºKnowledge and experience working with IBM Data Manager would be an asset
ºKnowledge and experience working with IBM Cognos Metric Studio.
ºKnowledge and experience working with IBM Campaign Manager would be an asset
ºKnowledge and experience working with Data Profiling tools would be an asset
ºKnowledge and experience with predictive modelling tools would be an asset
ºKnowledge of the banking industry, would be an asset
Equity, Diversity & Inclusion
We are proud to be an equal opportunity employer and are committed to fostering an inclusive and accessible work environment that reflects the diversity of our customers and our communities.
We welcome and encourage applications from individuals from all groups, including Indigenous people, women, visible minorities, and persons with disabilities, regardless of race, national or ethnic origin, colour, religion, age, sex, sexual orientation, gender identity or expression, marital status, family status, genetic characteristics, disability or any other legally-protected ground.
Accommodations for persons with disabilities are available upon request for job applicants taking part in all aspects of the recruitment process.
We may collect, use or disclose your personal information for the purpose of establishing an employment relationship with you.