Senior Analyst, Business Intelligence
LAURENTIAN BANK OF CANADA
TORONTO, ON, CA
3d ago

Job Description

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.

  • Reporting to the Senior Manager, Enterprise Data Warehouse, the incumbent is responsible for the analysis, development, testing and maintenance of the core Business Intelligence components of the bank's Enterprise Data Warehouse, in collaboration with internal stakeholders, including but not limited to;
  • 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.

    Responsibilities

    º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

  • Analyse source data and document the requirements for the requested BI solutions, including any data transformation methodologies as needed
  • Prepare the functional specifications of the various developments and validate the results in cooperation with teammates and users.
  • Develop 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

  • Create multi-dimensional data sets from the source data to be used in the creation of required BI products
  • Develop and test the BI solutions as defined
  • Support the implementation of the BI solution in production
  • º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.

    Qualifications

    º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.

    ASSETS

    º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

    Additional Information

    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.

    Accessibility

    Accommodations for persons with disabilities are available upon request for job applicants taking part in all aspects of the recruitment process.

    PIPEDA

    We may collect, use or disclose your personal information for the purpose of establishing an employment relationship with you.

    Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form