🇺🇸 USAJobs.work

America's Job Portal

← Back to USA Jobs

Lead Data Developer

Company

Scotiabank

Location

Toronto, Ontario

Posted

March 22, 2026

Position Overview

Is this role right for you?

In this role, you will:


• Developing SQL queries / ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with SQL Server data warehouse.
• Design and develop physical data model structures in SQL Server
• Design and development of high-quality dashboards / reports using tools like Power BI, SSRS, Crystal Report, Excel/PowerPivot, and Tableau. Develop custom reports, analytics and KPI’s for the Business
• Builds and maintain proper documentation, data lineage and extract-transform-load (ETL) processes.
• Collecting business requirements / user stories while working in a lab with a product owner, Business Analyst, Scrum Master, and application developers.
• Developing SQL views to enable data consumers to read data from data warehouse also optimizing and enhancing current jobs performances metrics.
• Documenting databases, data process flows and maintain data dictionaries, support and onboarding...

Ready to Apply?

Join thousands of Americans building their careers

Apply Now