Analyst, Data Engineering & Business Intelligence (BI) Developer - Toronto, ON
Scotiabank•Toronto, ON
•Onsite
About The Position
The Analyst, Data Engineering & BI (Business Intelligence) Developer is part of the Client Insights & Analytics team within Global Banking and Markets. The role supports business strategy and decision-making by delivering end-to-end data and reporting solutions, including data modeling, data pipeline automation, and dashboard development. This position bridges business intelligence and data engineering, translating business needs into scalable data solutions and actionable insights that enhance reporting, client strategy, and business performance.
Requirements
- Undergraduate degree in a quantitative discipline (e.g., Economics, Mathematics, Computer Science, or related field)
- 2+ years of relevant experience in analytics, data engineering, reporting, or related fields
- Experience working with large, complex datasets and multiple data sources
- Demonstrated ability to analyze data, identify insights, and support business decision-making
- Strong communication skills with the ability to present complex information clearly
- Ability to work effectively in cross-functional and matrixed environments
- Power BI (dataflows, semantic models, DAX, Power Query, dashboards)
- SQL (advanced querying, data extraction, transformation)
- Data modeling (dimensional modeling, performance optimization)
- ETL / ELT processes and data pipeline development
- Excel (advanced data analysis and reporting)
- Data validation, reconciliation, and quality control technique
Nice To Haves
- Experience with Python or other programming languages.
- Knowledge of capital markets or financial services industry.
- Familiarity with CRM systems and client data platforms.
- Exposure to advanced analytics, algorithm design, or data science techniques.
Responsibilities
- Design, build, and maintain data pipelines to efficiently extract, transform, and load (ETL / ELT) data
- Develop and maintain robust data models to support analytics and reporting, ensuring consistency and reliability
- Perform data extraction, transformation, and mapping across multiple systems and large datasets
- Contribute to the development of analytical tools, models, and reusable data assets
- Validate, reconcile, and monitor data across systems to ensure accuracy and integrity
- Investigate and resolve data discrepancies in collaboration with cross-functional teams
- Drive improvements in data processes, controls, and automation
- Apply best practices in data governance, transformation, and modeling
- Design, develop, and maintain Power BI dashboards and reports to provide actionable insights to stakeholders
- Translate business requirements into scalable reporting and analytics solutions that support decision-making
- Conduct quantitative and qualitative analysis, interpret results, and present findings clearly
- Automate reporting processes and enhance reporting capabilities to improve efficiency and user adoption
- Partner with business stakeholders to gather requirements and translate them into technical solutions
- Support ad hoc requests from leadership and business partners with timely analytics and insights
- Leverage internal and external data to identify business opportunities and enhance client insights
- Contribute to a collaborative, high-performing team environment focused on delivering value-added analytics
Benefits
- flexible benefit programs are designed to help support your unique family, financial, physical, mental, and social health needs.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
