Senior Business Intelligence Developer

Scotiabank   •  

Toronto, ON

5 - 7 years

Posted 239 days ago

This job is no longer available.


We are looking for a Senior Programmer / Business Intelligence (BI) Developer to create and manage BI and analytics solutions that turn data into knowledge.

In this role, you should have a strong background in data and business analysis. You should be analytical and an excellent communicator. If you also have a business acumen and problem-solving aptitude, we’d like to meet you.

Ultimately, you will enhance our business intelligence ecosystem to help our business lines make better decisions.

The incumbent will have at least 5-10 years of progressive IT experience, preferable to the financial industry, the ability to work on deliverables related to Analytics and Business Intelligence technology and the ability to work on multiple projects concurrently.  Risk background and Strong knowledge in Hadoop eco-system would be an asset.

The incumbent should also have a strong Project Management & Technical Support background. The individual must thrive on challenge, be proactive and dynamic, and demonstrate initiative and eagerness to learn while working on multiple projects at any given time. The Incumbent must have a complete view of the SDLC and Agile framework.

Key Job Accountabilities:

Reporting to the Senior Manager Development, the individual will be responsible for:

•Translating business needs to technical specifications (Nice to have: Familiar with the Credit Risk Business specifically Non Retail Credit Risk)

•Designing, building and deploying BI solutions (e.g. reporting tools like Cognos, Power BI, Axiom SL)

•Maintaining and support data analytics platforms (e.g. Datameer)

•Creating tools to store data (e.g. OLAP cubes, MS SQL Server)

•Conducting unit testing and troubleshooting & application analysis

•Evaluating and improve existing BI systems

•Collaborating with teams to integrate systems

•Developing and execute database queries and conduct analyses

•Creating visualizations and reports for requested projects

•Developing and update technical documentation


Proven experience as a BI Developer or Data Scientist

•Industry experience is preferred

•Background in data warehouse design (e.g. dimensional modeling) and data mining

•In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework

•Familiarity with BI technologies (e.g. Microsoft Power BI, Tableau, Cognos)

•Familiar with SQL, SQL Server Integration Services (SSIS)

•Involved in .net application development & platform migration

•Proven abilities to take initiative and be innovative

•Analytical mind with a problem-solving aptitude

•BSc/BA in Computer Science, Engineering or relevant field

•Exceptional written and oral communication skills.

•Strong Business Intelligence and Reporting skills

•Strong knowledge in Hadoop eco-system.


- Computer Science or Engineering Degree or Community College equivalent.

- Must have a good understanding of the business and business systems supported.

Requisition ID: 20571