BI Developer (225819)

Requisition ID: 225819

Join a purpose driven winning team committed to results in an inclusive and high-performing culture.

The Team

Contributes to the overall success of the CBT data services in Canada ensuring specific individual goals plans initiatives are executed / delivered in support of the teams business strategies and objectives. Ensures all activities conducted are in compliance with governing regulations internal policies and procedures.

Reporting through a Director to the Vice President Revolving Credit Data and Transaction Canadian Banking Technology the BI Developer provides expertise in developing insights based on the operational data managed by the Canadian Banking Technology team in Revolving Credit Data and Transactions. The incumbent provides technical leadership and delivery excellence in tools such as Microsoft PowerBI and Talend.

Is this role right for you

• Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships systems and knowledge.
• Proven experience as a BI Developer Background in data warehouse design (e.g. dimensional modeling) In-depth understanding of database management systems online analytical processing (OLAP) and ETL (Extract transform load) framework Knowledge of SQL queries SQL Server Reporting Services (SSRS).
• Proven abilities to take initiative and be innovative Analytical mind with a problem-solving aptitude
• Experience creating Power BI reports based on business requirements with linked content drilldowns and nested parameters. Optimize PBI dashboards with a focus on usability performance flexibility and standardization. Design data architecture structures to support BI Initiatives
• Assists in developing Business Intelligence reports and Operational Analytics capabilities including but not limited to:
  • Canned reports
  • Interactive dashboards
  • Trending and projections of operational performance indicators (e.g. related to resource consumption utilization)
  • Data quality operational analytics (e.g. data quality measures metrics root cause analysis of subject areas such as customer)
• Develops the processes required to support above based on the DataOps principles including but not limited to:
  • Agile prototyping of dashboards to develop insights quickly
  • Automated environment commissioning and tear-down for self-serve analytics
  • Self-serve data provisioning
  • Automated data profiling
  • Identification of infrastructure requirements including Cloud capabilities
• Assists in developing templates / automated processes / toolkits to support above including but not limited to:
  • Standardized data profiling report
  • Automated data profiling for cyber/info security
  • Automated promotion of dashboard from development to higher environments
  • Automated data masking
• Carryout customer data quality analysis including but not limited to
  • Missing fields categorized by business mandatory and optional designation with focus on improving data quality for AML/KYC analysis and reducing false positives in naming screening
  • Domain analyses (unique non unique set)
  • Field validation (expected domain value address validation email validation telephone validation)
  • Intra field validation (postal code for Canadian addresses / accounts zip code for American addresses / accounts)
• Customer analysis and recommended actions including but not limited to:
  • Accounts with similar named parties and addresses
  • Parties with the same address or phone number
  • Parties with addresses in sanctioned countries
• Root cause analysis of sources of data quality issues
• Consult on BI capabilities recommend and execute solutions to address business needs and performance requirements.
• Previous experience developing Business Intelligence databases and systems that allow for the creation of Key Performance Indicators (KPIs) Scorecards and other reporting necessary to create meaningful results that can be used by our internal and external stakeholders at both the strategic and day-to-day level.
• Proven ability to model large quantities of data coming in from different data sources into BI technologies to build a large-scale enterprise reporting and self-service reporting by internal users.
• Understand how the Banks risk appetite and risk culture should be considered in day-to-day activities and decisions
• Actively pursues effective and efficient operations of his/her respective areas in accordance with Scotiabanks Values its Code of Conduct and the Global Sales Principles while ensuring the adequacy adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational compliance AML/ATF/sanctions and conduct risk
• Champions a high-performance environment and contributes to an inclusive work environment

Do you have the skills that will enable you to succeed in this role

• University degree in relevant STEM discipline (Science Technology Engineering and Mathematics) or equivalent.
• 5 years experience in data analytics & reporting related field
• Have a track record of remaining unbiased toward specific technologies or vendors
• Subject area experience with Financial Industry products and services preferred: Retail Banking/Lending Commercial Banking/Lending Capital Markets and Wealth Management
• Experience with innovation design thinking agile and the application of DataOps / DevOps
• Experience in data integration projects (ETL/ELT data design data governance data modelling data analysis)
• Deep experience in developing reporting business intelligence and analytics solutions
• Deep experience in developing valuable insights (from a business perspective)
• Experience with data visualization tools (e.g. PowerBI Tableau) Python
• Good knowledge of SQL

Whats in it for you

• Diversity Equity Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential respected for who they are and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities ethnicity race age ability & veterans.
• Accessibility and Workplace Accommodations - 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. Scotiabank continues to locate remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
• Upskilling through online courses cross-functional development opportunities and tuition assistance.
• Competitive Rewards program including bonus flexible vacation personal sick days and benefits will start on day one.
• Community Engagement - no matter where you choose to work from; we offer opportunities for community egagement & belonging with our various programs such as hackathonsand much more!

Work conditions: Hybrid

#LI-Hybrid

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.