BI Report Developer / Analyst (microstrategy BI)

Scotiabank; Canada; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

A leading bank in the Americas is seeking a skilled BI Reporting Analyst and Developer to design and maintain business intelligence solutions. The role involves optimizing BI models, collaborating with stakeholders, and ensuring data integrity. Join a hybrid team in Toronto, Ontario, and contribute to a diverse and inclusive workplace that values employee growth and community engagement.

Benefits

Diversity, Equity, Inclusion & Allyship

Tuition Assistance

Flexible Vacation

Comprehensive Benefits

Free Beverages

Qualifications

• Strong background in data analysis, visualization, and reporting.
• Experience with BI tools and SQL.

Responsibilities

• Develop and optimize BI models, reports, and dashboards.
• Collaborate with business users to gather reporting requirements.
• Ensure data accuracy and integrity across platforms.

Skills

Data Analysis

Data Visualization

SQL

PL/SQL

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

ETL tools

Google Cloud

Job description

Requisition ID: #

Join a purpose-driven, high-performing team committed to results

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 collaborating with stakeholders to understand reporting needs and ensuring data accuracy and usability.

Responsibilities

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

Qualifications

1. Bachelor's degree in Computer Science, Data Analytics, Information Systems, or related field.
2. Proficiency in BI tools such as MicroStrategy BI and Power BI.
3. Strong SQL skills with experience in Oracle, SQL Server, or Snowflake.
4. Experience with Windows Server and Linux/Unix OS.
5. Experience with ETL tools and data warehousing concepts.
6. Experience with scheduling tools like AutoSys.
7. Understanding of data visualization best practices.
8. Knowledge of PL/SQL and Oracle databases; familiarity with Google Cloud is a plus.
9. Experience with scripting on Windows/Linux/Unix platforms.
10. Familiarity with Agile methodologies and a background in financial and operational reporting.

What We Offer

• Inclusive culture emphasizing Diversity, Equity, Inclusion & Allyship, with Employee Resource Groups (ERGs).
• Accessible and accommodating workplace environment.
• Opportunities for upskilling through online courses, cross-functional development, and tuition assistance.
• Competitive rewards including bonuses, flexible vacation, and comprehensive benefits.
• Dynamic workspace with amenities like free beverages and collaborative spaces.
• Community engagement programs and events.

Work Location

Hybrid model in Toronto, Ontario, Canada.

#LI-Hybrid

About Scotiabank

Scotiabank is a leading bank in the Americas, guided by our purpose: "for every future." We strive to create an inclusive environment and provide accommodations for candidates requiring support during the recruitment process.

Interested candidates must apply online. We thank all applicants; only those selected for an interview will be contacted.