Requisition ID: 103536Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
Overview
Within Scotiabanks Global Compliance department, the Data Analytics team is looking to hire Business Intelligence Analyst who will work closely with business partners, technology teams, engineering teams, data architects, data modelers and other analytics teams in the Bank to unlock the power of data and draw impactful insights to support decision-making and day-to-day operations in compliance.
We are looking for individuals who never settle, are always looking for new ways to solve big problems. The incumbent should demonstrate the ability to collaborate effectively with internal and external partnersincluding technologists, product managers, engineers, designers and senior leadership. The Business Intelligence Developer will contribute to the overall success of the global compliance team in protecting the Banks customers thereby keeping their trust in our ability to provide excellent services all the time
Responsibilities
Be hands-on. Design, Prototype and Productionize reports and dashboards for leadership, management and compliance operations teams.
Be an owner. Ensure accuracy, timeliness and traceability of metrics generated and published in official dashboards.
Be a trainer. Design and deliver training to various users of reports and dashboards.
Be agile. Design, implement, iterate.
Develops and maintains ETL processes in accordance to data standards and defined requirements.
Ability to respond and deliver on ad-hoc requests in a timely and efficient manner.
Participates in the design of logical data model and implements physical operational data stores and data marts.
Influences teammates and stakeholders to understand data from a compliance perspective.
Drives consensus across teams to achieve consistency in data, reporting methodology and metric calculations.
Builds and maintains proper documentation, data lineage and extract-transform-load (ETL) processes.
Participate in planning and retrospective sessions, attend stand-ups, etc.
Maintains a good understanding of the Bank’s business strategies, policies, risk management and IT processes and disciplines. Requirements
University degree in relevant STEM discipline (Computer Sciences, Electrical/Computer/Software Engineering, Mathematics)
At least 3 years of hands-on programming experience and advanced knowledge of SQL and Python.
At least 3 years of experience in implementing and managing visualization tools such as Power BI, or Tableau.
SQL Server and SSIS expertise is highly desirable.
2+ years of experience in cleaning, transforming and visualizing data sets. working from various data formats (e.g. unstructured logs, XML, JSON, flat files)
Experience with agile methodologies, source control management and building processes.
Excellent communication skills, with a strong customer-focus.
Nice-to-have experience with statistical analysis and machine learning with common machine learning libraries in R or Python.
Location(s): Canada : Ontario : Toronto 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 broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets. At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance, please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.