Join Our Winning Team: Business Intelligence Developer at Scotiabank

Requisition ID: 195786

Be a part of a purpose-driven team committed to results within an inclusive and high-performing culture at Scotiabank. Our Global Compliance Technology team focuses on developing and supporting compliance and risk management data and reporting solutions within the Bank.

About the Role

We are seeking a Software Engineer to join our team of solution developers and architects. You will work with both on-premise and cloud data platforms used in compliance and risk management. Your responsibilities will include system integration, data ingestion, and dashboard/report development.

Key Responsibilities

• Lead data initiatives from intake to productionization of data processes.
• Direct a team of contractors and employees in enabling data processes.
• Implement data ingestion pipelines and DevOps for on-prem and Azure/GCP cloud platforms.
• Develop SQL queries and ETL packages to migrate data into our data warehouse.
• Ensure smooth transition to the Operations team for sustained process execution.
• Create high-quality dashboards/reports using tools like Power BI, SSRS, Excel/PowerPivot, and Tableau.
• Conduct thorough testing for quality assurance.
• Build SQL views to facilitate data consumption from the data warehouse.
• Integrate systems through REST API, database views, SharePoint lists, sFTP, and more.
• Document databases, data process flows, and maintain data dictionaries.
• Troubleshoot and resolve database and application issues promptly.
• Coordinate code deployments and production implementations.
• Train and assist users at all levels.

Qualifications

• Experience with Microsoft BI stack (SQL Server, T-SQL, SSRS, SSIS).
• Knowledge of Azure data solutions (SQL Managed Instance, Synapse Pipelines, Azure Data Factory) is a plus.
• Familiarity with GCP, Google Big Query, API Ingest, dbt (data build tool), Vertex AI, Looker is a plus.
• Experience in data warehousing, ETL, and SSIS for system integration.
• Proficiency in data visualization/BI tools like Power BI and SSRS.
• Excellent communication and interpersonal skills.
• Attention to detail and ability to rapidly implement client feedback on dashboards and reports.
• Experience with SDLC methodologies (Agile, Waterfall).
• Knowledge of banking or risk-related systems is advantageous.
• Experience developing code to consume REST API services is a plus.
• Familiarity with COTS software packages for system integration is a plus.
• Experience with DevOps and MS Azure Cloud services or Google Cloud Platform is a plus.
• Knowledge of web development (in .NET, SharePoint, Power Apps, Power Platform) is a plus.

What's in it for You?

• Diversity, Equity, Inclusion & Allyship: We create a culture where every employee is respected and empowered.
• Accessibility and Workplace Accommodations: Scotiabank is committed to maintaining an inclusive and accessible environment for everyone.
• Upskilling Opportunities: Access to online courses, cross-functional development, and tuition assistance.
• Competitive Rewards: Enjoy flexible vacation, personal/sick days, and benefits from day one.
• Community Engagement: Participate in diverse programs like hackathons, contests, and more.

Working Location Condition: Hybrid

#LI-Hybrid

Location: Ontario, Toronto, Canada

Scotiabank is a leading bank in the Americas. Guided by our purpose, "for every future," we help our customers, their families, and their communities achieve success through a wide range of financial services.

We value the unique skills and experiences each individual brings. If you require accommodation during the recruitment process, please let our Recruitment team know. Candidates must apply directly online to be considered