BI Developer

Scotiabank; Toronto; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

Scotiabank is looking for a BI Developer who will be responsible for developing business intelligence insights and optimizing reporting capabilities. The successful candidate will need to have strong technical skills in SQL and familiarity with tools like Power BI, alongside a solid background in data analytics and a commitment to a customer-focused culture.

Benefits

Diversity and Inclusion initiatives

Tuition assistance

Flexible vacation policies

Competitive rewards program

Workplace accommodations

Qualifications

• 5 years experience in data analytics & reporting.
• Knowledge of SQL queries and database management systems.
• Proven ability to innovate and take initiative.

Responsibilities

• Develop insights based on operational data.
• Create and optimize Power BI reports.
• Conduct customer data quality analysis and recommend actions.

Skills

Data analytics

Reporting

Problem-solving

Agile methodologies

Data visualization

SQL

ETL

Education

University degree in relevant STEM discipline

Tools

Power BI

SQL Server

Talend

Job description

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert:

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 team’s 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 Bank’s 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 Scotiabank’s 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
• 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

What's 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.