BI Report Developer/Analyst

Scotiabank; Toronto; Hybrid; CAD 60,000 - 100,000; Full time

Job summary

An established industry player is on the lookout for a talented BI Report Developer/Analyst who can transform complex data into actionable insights. This role offers the opportunity to design and optimize BI solutions, ensuring data integrity and usability while collaborating with various stakeholders. The ideal candidate will thrive in a dynamic environment, utilizing cutting-edge BI tools and methodologies. With a commitment to diversity and inclusion, this organization fosters a culture where every employee can reach their full potential. If you are passionate about data and eager to make a meaningful impact, this role is perfect for you!

Benefits

Diversity and Inclusion Programs

Tuition Assistance

Flexible Vacation

Competitive Rewards Program

Community Engagement Opportunities

Free Tea & Coffee

Online Courses for Upskilling

Accessible Work Environment

Qualifications

• Strong background in BI solutions and data analysis.
• Experience with BI tools and SQL databases.
• Familiarity with data visualization best practices.

Responsibilities

• Develop and maintain BI models, reports, and dashboards.
• Extract and analyze data to provide business insights.
• Collaborate with stakeholders to translate requirements into reports.

Skills

Data Analysis

Data Visualization

SQL

PL/SQL

ETL Processes

BI Tools

Scripting (Unix/Windows)

Agile Methodologies

Education

Bachelor's degree in Computer Science

Bachelor's degree in Data Analytics

Bachelor's degree in Information Systems

Tools

MicroStrategy BI

Power BI

Oracle

SQL Server

Snowflake

AutoSys

Google Cloud

Job description

Title: BI Report Developer/Analyst

Requisition ID: 223052

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

We are seeking a skilled BI Reporting Analyst and Developer to design, develop, and maintain business intelligence (BI) solutions that transform data into actionable insights. The ideal candidate will have a strong background in data analysis, visualization, and reporting, with experience in BI tools like MicroStrategy BI and Power BI. This role involves working closely with stakeholders to understand reporting needs and ensure data accuracy and usability.

Is this role right for you? In this role you will:

• Develop, maintain, and optimize BI models, reports, dashboards, and data visualizations and batch processes. Support for batch processes will require familiarity with AutoSys and Unix/Windows scripting.
• Extract, clean, and analyze large datasets from multiple sources to provide business insights.
• Collaborate with business users to gather requirements and translate them into meaningful reports.
• Design and develop PL/SQL queries, stored procedures, and ETL processes for data transformation.
• Ensure data integrity, accuracy, and security across all reporting platforms.
• Automate reporting processes to improve efficiency and reduce manual effort.
• Stay updated on BI trends and recommend best practices for reporting and analytics.

Do you have the skills that will enable you to succeed in this role? We'd love to work with you if you have:

• Bachelor's degree in Computer Science, Data Analytics, Information Systems, or a related field.
• Proficiency in BI tools such as MicroStrategy BI and Power BI.
• Strong SQL skills and experience with databases like Oracle, SQL Server, or Snowflake.
• Experience in working with Windows Server and Linux/Unix OSes.
• Experience with ETL tools and data warehousing concepts.
• Experience with scheduling tools, specifically AutoSys.
• Understanding of data visualization best practices.
• Experience with Windows/Linux/Unix scripting.
• Knowledge of PL/SQL and Oracle databases. Knowledge of Google Cloud is an asset.
• Familiarity with Agile development methodologies.
• Background in financial and operational reporting.

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 embraced through bias-free practices and inclusive values across Scotiabank.
• 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.
• 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.
• Dynamic Ecosystem - Free tea & coffee, universal washrooms, and lots of space for team collaboration.
• Community Engagement - We offer opportunities for community engagement & belonging with our various programs.

Working location condition: 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.

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 during the recruitment and selection process, please let our Recruitment team know. 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.