Job Description

In a changing world, unprecedented challenges require unmatched talent. Join one of Montreal's Top Employers in 2022. We are a dynamic and growing organization having its main establishment located in downtown Montreal and part of a leading international banking institution fully committed to building a more sustainable future. Note that the position may be in the Canadian Branch of BNP Paribas or in one of its subsidiaries based in Montreal.

The Role Explained

The North American Global Banking IT is working on implementing IT solutions to support various clients: Finance, Human Resources, Procurement, Premises & Logistics, Business Continuity Management, IT Security, etc.

We are looking for a talented individual looking to join a dynamic environment where they can raise the bar for the industry.

The position at a glance

Responsible for the success of IT projects by developing new, maintaining existing and supporting a number of in-house/vendor applications from the data warehouse, database and business intelligence perspective. The work will require analyzing business requirements, interpreting and understanding technical specifications and following instruction from the team lead, peer developers, business analysts and project managers.

In detail

The scope of the engagement will include but not be limited to:

• Good working knowledge of data warehouse, database and business intelligence environments, concepts and techniques
• Strong understanding of concepts and techniques for design, development and implementation of ETL and data quality
• Review, understand, interpret and transform clearly defined technical specifications into data warehouse, database and/or business intelligence solutions
• Ability to perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples)
• Ability to perform problem analysis, structured analysis, design and programming techniques
• Use of Data Modeling, Database Query Optimization and Data Access techniques and concepts
• Database knowledge in areas of import and export, users, roles, privileges, schema and object management, session monitoring, etc.
• Code, maintain, test and provide code reviews for developed processes and procedures (e.g. queries, scripts, stored procedures, database objects, indices, triggers, etc.)
• Strong performance tuning knowledge in SQL and ability to interpret plans, identify bottlenecks in queries and remediate them
• Work proactively to solve issues and problems
• Create use cases and assist in UAT testing efforts for the developed solutions
• Document, effectively track and resolve issues in a timely manner during the development and testing phases (work with the team and end users as appropriate)
• Review and document performance
• Provide weekly progress reports of work performed
• Work with the project team to assist in other aspects of the project
• Follow and adhere to BNP Paribas development standards, the software development lifecycle, vendor application / project standards and guidelines
• Embrace the opportunity to take on special projects outside of specific roles and responsibilities

Qualifications

The strengths and skills that will help you succeed

Experience

• Strong Linux/Unix administration & development experiences - 5 years of experience minimum.
• Strong Oracle database knowledge (SQL, PL/SQL, basic administration ...) - 5 years of experience minimum.
• Strong Linux/Unix and Python scripting knowledge (best practices, limitations, error handling ...) - 5 years of experience minimum.
• Experiences on Data Warehouse and ETL related development - 3 years of experience minimum.
• Experiences on DevOps (GIT, Jenkins, Sonar ...) - 2 years of experience minimum.
• Experience with Computer Associates Autosys scheduler or other scheduling/monitoring tools.
• Must have banking industry experience.
• Atlas2 Infocenter BNP Paribas application knowledge is a huge plus.

Knowledge

• Knowledge of Agile & Waterfall development methods
• Knowledge of CMMI (Capability Maturity Model Integration)

Soft Skills

• Excellent analytical skills
• Good communication skills both oral and written to be able to work with a varied user base
• Previous experience in large corporate environments (Finance preferred)

What's in it for you

In addition to competitive compensation, we offer flexible benefits including a family and spouse insurance program, a defined contribution pension plan and paid days for volunteering. Hybrid work arrangements, such as remote working up to 50% and flexible working hours are available for most positions. BNP Paribas provides excellent training and personal development programs, as well as opportunities for career development within the company and internationally.

To find out more about our range of benefits,

What you need to know

• We will review candidates as they apply, so don't wait to submit your application;
• If you are selected to participate in the recruitment process, please inform Human Resources of any accommodations you may require. BNP Paribas will work with you to ensure that you are able to participate fully in the process;
• You must be legally eligible to work in the Greater Montreal area and, if applicable, hold a valid work or study permit. Physical presence in BNP Paribas' office(s) is an essential function of this position;
• Given the vast majority of our clients, both internal and external, is based outside of Quebec and Canada, our positions require employees to speak another language than French - being English for most positions; other languages such as Spanish or Portuguese may be also specifically required and such will be clearly mentioned in the requirements of the position;
• All BNP Paribas employees in Canada must be adequately vaccinated against COVID-19 on the date of hire, unless exempt for a reason protected by the Canadian Human Rights Act.

Diversity, Equity and Inclusion (DE&I) at the heart of our commitments

At BNP Paribas all employees are on an equal footing allowing us to create a work environment that values and respects people for their talents, skills and competences.

BNP Paribas recruits, employs, trains, compensates and promotes regardless of race, religion, colour, national origin, sex, disability, age, and other protected status (Employment Equity Act and Canadian Human Right Act).

To learn more about our DE&I commitments,

About us

BNP Paribas is the top bank in the European Union and a major international banking establishment. Present in 65 countries, with more than 190,000 employees, the bank holds key positions in several areas of banking and financial services.

BNP Paribas' mission is to contribute to a responsible and sustainable economy by financing and advising its clients according to the highest ethical standards, while striving to respond to essential concerns in terms of the environment, regional development and social inclusion.

Since 1961, BNP Paribas has supported large Canadian companies and institutions in their business development by offering a full range of specialized financial services and investment products.

With over 1,200 employees, BNP Paribas in Canada continues to attract experts from diverse fields as well as ambitious young talent from around the world. We are proud to offer our employees a rewarding and international workplace where they can build their professional careers by honing their skills, meeting challenges and enriching their knowledge of the financial industry.

Our certifications and partnerships

• Montreal Top Employer 2022
• Women in Governance - Parity certified - Silver certification
• CCDI Consulting Inc. (Canadian Center for Diversity and Inclusion)
• Pride at Work Canada
• Rainbow Accreditation issued by Canada's LGBT+ Chamber of Commerce (CGLCC)
• ROSEPH - Grouping of specialized organizations for the employment of persons with disabilities
• IndigenousWorks

Do you want to discover other BNP Paribas offers in Canada?

Click here:

** Only selected applications that meet the requirements of the role will be contacted **