MicroStrategy/PowerBI Developer (223052)

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 requires familiarity with AutoSys and Unix/Window 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 Wed love to work with you if you have:

• Bachelors 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 an asset.
• Familiarity with Agile development methodologies.
• Background in financial and operational reporting.

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.
• Dynamic Ecosystem - Free tea & coffee universal washrooms and lots of space for team collaboration.
• Community Engagement - No matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons contests cooking with friends Humans of Digital and much more!

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 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.