Founded in 1846, Laurentian Bank Financial Group (LBCFG) is a diversified financial services provider whose mission is to help its customers improve their financial health.
The Laurentian Bank of Canada and its entities are collectively referred to as Laurentian Bank Financial Group (the "Group" or the "Bank").
With more than 2,900 employees guided by the values of proximity, simplicity and honesty, the Group provides a broad range of advice-based solutions and services to its personal, business and institutional customers.
With pan-Canadian activities and a presence in the U.S., the Group is an important player in numerous market segments.
This role sits within LBC Tech, a subsidiary of Laurentian Bank Financial Group.
ad-hoc reports, data extracts, and analytic cubes. He or she will also participate in the development and implementation of BI solutions needed for marketing campaigns and Key Performance Indicators (KPI's).
MicroStrategy or other OLAP solutions.
º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.
oAnalyse source data and document the requirements for the requested BI solutions, including any data transformation methodologies as needed
oPrepare 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 6-8yrs of work experience.
ºAt least 4 + 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.
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.