Senior Business Intelligence Analyst

TD•Toronto, ON

1d•CA$81,600 - CA$115,200•Onsite

About The Position

Join Our Business Intelligence and Insights (BII) Team within the Monitoring Coverage and Capabilities, where you will play a pivotal role in advancing our Financial Crime and Risk Management (FCRM) initiatives. Become a key player in our BII team, where you will help design robust data platforms, transform data into actionable insights, support critical investigations with analytics expertise, and drive innovation by developing cutting-edge tools and technologies. Make a real impact on how our organization leverages data to inform strategic decisions and accelerate growth. This role requires strong experience in SQL, Oracle development, Microsoft Azure Cloud (Rahona), Python, PowerBI and Databricks. May be considered a subject matter expert in BI and Reporting. Accountable for the development, adoption and ongoing evolution of a best-in-class reporting and/or BI capability and may deliver on ad-hoc projects as assigned.

Requirements

2-3 years of hands-on experience in SQL and Oracle development.
Proficiency with Microsoft Azure (Rahona), Databricks, Python, and Power BI.
Strong analytical and problem-solving skills, with the ability to interpret complex data sets
Ability to automate manual processes using scripting or workflow tools.

Nice To Haves

2+ years of experience working with Tableau.
Background in financial crime investigation or risk/compliance analytics.
Experience with Case Management systems, like Oracle FCCM (Financial Crime and Compliance Management Cloud Service), supporting risk and investigative functions.

Responsibilities

Produce specialized reporting packages, dashboards and scorecards for businesses, with focus on understanding objectives and delivering insights for: (1) product design and development; (2) customer engagement; (3) account management; and (4) business decision making.
Use various methodologies to rapidly generate impactful interactive visualizations or tools.
Lead the implementation of initiatives in support of overall business/function strategy.
Conduct analysis to provide enhanced BI to inform management leadership team.
Create complex and comprehensive BI reporting packages and dashboards utilizing data infrastructure, localized DataMart's and external data sources and transform into visual stories using appropriate systems to support client objectives.
Identify and propose data presentations to meet evolving business's needs; utilize various technology/ applications/ methodologies to rapidly generate impactful visualizations.
Build basic layouts and templates to be utilized by internal partners.
Validate the quality and integrity of the data included in the Reporting Packages and Dashboards
Develop meaningful and insightful commentary/ insights on new and existing reporting packages.
Work with business partners to understand business objectives and develop value-added reporting and provide ad-hoc data extracts.
Adopt, implement and effectively evolve report automation and/or visualization standards.
May as a subject matter expert, to provide advisory or consultative services for supported colleagues and/or businesses regarding multi-format data visualization techniques
Adhere to enterprise frameworks or methodologies that relate to activities for our business area.
Consistently exercise discretion in managing correspondence, information and all matters of confidentiality; escalate issues where appropriate.
Ensure business operations are in compliance with applicable internal and external requirements (e.g. financial controls, segregation of duties, transaction approvals and physical control of assets)
Participate in cross-functional / enterprise / initiatives as a subject matter expert helping to identify risk / provide guidance for complex situations.
Conduct internal and external research projects; support the development/ delivery of presentations / communications to management or broader audience.
Conduct meaningful analysis at the functional or enterprise level using results to draw conclusions, make recommendations, assess the effectiveness of programs/ policies/ practices.
Monitor service, productivity and assess efficiency levels within own function and implement continuous process / performance improvements where opportunities exist.
Lead / facilitate and/or implement actions / remediation plans to address performance / risk /governance issues.
Actively manage relationships within and across various business lines, corporate and/or control functions and ensure alignment with enterprise and/or regulatory requirements.
Maintain a culture of risk management and control, supported by effective processes in alignment with risk appetite.
Participate fully as a member of the team, support a positive work environment that promotes service to the business, quality, innovation and teamwork and ensure timely communication of issues/ points of interest.
Provide thought leadership and/ or industry knowledge for own area of expertise in own area and participate in knowledge transfer within the team and business unit.
Keep current on emerging trends/ developments and grow knowledge of the business, related tools and techniques.
Participate in personal performance management and development activities, including cross training within own team.
Keep others informed and up to date about the status / progress of projects and / or all relevant or useful information related to day-to-day activities.
Contribute to team development of skills and capabilities through mentorship of others, by sharing knowledge and experiences and leveraging best practices.
Lead, motivate and develop relationships with internal and external business partners / stakeholders to develop productive working relationships.
Contribute to a fair, positive and equitable environment that supports a diverse workforce.
Act as a brand ambassador for your business area/function and the bank, both internally and/or externally
Work independently as the senior analyst / subject matter expert and may provide technical support to others.
Requires advanced knowledge of reporting and BI platforms, tools and techniques, and ability to effectively leverage it to support diverse reporting and BI functions.
Considered a subject matter expert within a given area.
Expert knowledge of all main data sources for the data used within the business unit and ability to effectively utilize these data sources for reporting purposes.
Experienced professional role providing specialized data visualizations to support business needs.
May be expected to have a knowledge of broader enterprise reporting platforms and data sources and ability to integrate data across the enterprise.
May be expected to present to senior management or executives.
Oversee and/or independently perform tasks from end to end.
Generally, focus on broad range of moderately complex issues that may span from short to medium term (e.g. monthly-quarterly), Generally, reports to a Senior / Manager role