Logo of Huzzle

Senior Business Intelligence Analyst

image

TD Bank

Oct 16, 2024

  • Job
    Full-time
    Senior Level
  • Data
    Business, Operations & Strategy
  • Toronto
  • Quick Apply

AI generated summary

  • You must have 5+ years in analytics, strong SQL and Python skills, experience with Dashboards (Tableau/Power BI), ETL, big data, and effective communication with stakeholders.
  • You will analyze data, create reports and dashboards, collaborate with stakeholders, automate processes, ensure documentation, and provide insights to inform business decisions and enhance operations.

Requirements

  • Produce specialized reporting packages, dashboards and scorecards for businesses, with focus on the following functional areas: to understand objectives and deliver insights and commentary that can inform and shape product design and development, customer engagement, account management and business decision-making
  • Experience with enterprise RDBMS, Big Data management technology, Azure Cloud and the process of Extract Transform Load (ETL)
  • Solid programming principles with Python, SQL
  • Highly skilled in the use of visualization tools such as Tableau and Power BI to develop comprehensive frameworks for reporting packages and dashboards utilizing data infrastructure, tools and external data sources
  • Experience manipulating large volume of complex data from disparate sources
  • Adopt, implement and effectively evolve report automation standards
  • Identify, recommend and execute opportunities to eliminate or consolidate existing reports and leverage existing report usage tracking data
  • Work in a consultative role to provide “value-added” insights in the form of analysis, visualizations, interpretation and advice
  • Liaise with business stakeholders to conduct effective discussions on project/reporting needs, data specifications, priority and timeline to ensure timely and accurate deliveries.
  • Ensure the creation and ongoing maintenance of documentation for key BI & Reporting processes and deliverables.
  • Strong communicator with excellent oral, written skills and experience presenting to senior executives
  • Strong analytical and problem solving skills
  • Experience in project and software development life cycles in preparation of project artifacts (eg. business requirements, design specifications, test documents, etc)
  • Ability to work effectively in a fast-paced environment, multi-task and work independently with minimal supervision
  • Experience in data governance, data standard & policies an asset
  • Desire to keep current with industry best practices and search for new and innovative ways to manage and visually present data
  • Business Intelligence and Reporting experience (business-as-usual as well as ad-hoc)
  • Excellent communication skills to effectively engage with team members build strong relationships within and across teams, peers, and business partners
  • Adhere to internal policies /procedures and applicable regulatory guidelines, contribute to the review of internal processes and activities and assist in identifying potential opportunities to improve operational efficiencies
  • Identify variances and contribute to the analysis, due diligence and implementation of initiatives and/or business operations within defined area of responsibility
  • Support development and/or/implementation of standards, policies, procedures, and solutions that mitigate risk and maximize availability of service, efficiency and effectiveness.
  • 5+ years of relevant experience in a direct marketing, consulting, analytics, or agency-side role in financial services/telecom (or other high volume direct marketing industries)
  • Knowledge of SQL; knowledge of databases and data structures; knowledge of vendors and file format requirements
  • Experience designing successful direct marketing experiments
  • Degree in business, science, Engineering, or quantitative discipline
  • Graduate or undergraduate degree in quantitative discipline such as management analytics, statistics, mathematics, operations research, economics, computer science, or engineering
  • 5+ years of relevant experience in an Analytic role with a Financial Institution
  • Highly skilled in the use of statistical programming software including SQL and advanced data mining
  • Experience manipulating large volume of complex data from disparate sources

Responsibilities

  • Produce specialized reporting packages, dashboards and scorecards for businesses, with focus on the following functional areas: to understand objectives and deliver insights and commentary that can inform and shape product design and development, customer engagement, account management and business decision-making
  • Experience with enterprise RDBMS, Big Data management technology, Azure Cloud and the process of Extract Transform Load (ETL)
  • Solid programming principles with Python, SQL
  • Highly skilled in the use of visualization tools such as Tableau and Power BI to develop comprehensive frameworks for reporting packages and dashboards utilizing data infrastructure, tools and external data sources
  • Experience manipulating large volume of complex data from disparate sources
  • Adopt, implement and effectively evolve report automation standards
  • Identify, recommend and execute opportunities to eliminate or consolidate existing reports and leverage existing report usage tracking data
  • Work in a consultative role to provide “value-added” insights in the form of analysis, visualizations, interpretation and advice
  • Liaise with business stakeholders to conduct effective discussions on project/reporting needs, data specifications, priority and timeline to ensure timely and accurate deliveries.
  • Ensure the creation and ongoing maintenance of documentation for key BI & Reporting processes and deliverables.
  • Strong communicator with excellent oral, written skills and experience presenting to senior executives
  • Strong analytical and problem solving skills
  • Experience in project and software development life cycles in preparation of project artifacts (eg. business requirements, design specifications, test documents, etc)
  • Ability to work effectively in a fast-paced environment, multi-task and work independently with minimal supervision
  • Experience in data governance, data standard & policies an asset
  • Desire to keep current with industry best practices and search for new and innovative ways to manage and visually present data
  • Excellent communication skills to effectively engage with team members build strong relationships within and across teams, peers, and business partners
  • Adhere to internal policies /procedures and applicable regulatory guidelines, contribute to the review of internal processes and activities and assist in identifying potential opportunities to improve operational efficiencies
  • Identify variances and contribute to the analysis, due diligence and implementation of initiatives and/or business operations within defined area of responsibility
  • Support development and/or/implementation of standards, policies, procedures, and solutions that mitigate risk and maximize availability of service, efficiency and effectiveness.

FAQs

What is the work location for the Senior Business Intelligence Analyst position?

The work location is Canada.

What are the working hours for this role?

The working hours are 37.5 hours per week.

What is the line of business this role falls under?

This role falls under Analytics, Insights, & Artificial Intelligence.

How should candidates inquire about compensation details?

Candidates are encouraged to have an open dialogue with a member of the HR Team to ask compensation-related questions, including pay details for this role.

What type of experience is required for this position?

Candidates are expected to have 5+ years of relevant experience in a direct marketing, consulting, analytics, or agency-side role, preferably within financial services, telecom, or other high-volume direct marketing industries.

What technical skills are necessary for this role?

The role requires experience with enterprise RDBMS, Big Data management technology, Azure Cloud, ETL processes, as well as proficiency in Python and SQL.

What visualization tools should candidates be skilled in?

Candidates should be highly skilled in using visualization tools such as Tableau and Power BI.

Is experience with data governance and data policies an asset for this position?

Yes, experience in data governance, data standards, and policies is considered an asset.

What types of projects will the Senior Business Intelligence Analyst work on?

The analyst will work on producing specialized reporting packages, dashboards, and scorecards, as well as delivering insights and commentary to inform business decision-making.

What are the communication requirements for this role?

Candidates must be strong communicators with excellent oral and written skills and experience presenting to senior executives.

Will training and onboarding be provided for this role?

Yes, training and onboarding sessions will be provided to ensure new hires have everything they need to succeed in their roles.

Are there opportunities for career development in this position?

Yes, regular career and development conversations, along with access to training programs and mentoring, are provided to support colleagues' growth.

Can accommodations be requested during the interview process?

Yes, candidates are encouraged to request accommodations, such as accessible meeting rooms and captioning for virtual interviews, to help remove barriers throughout the interview process.

Finance
Industry
10,001+
Employees

Mission & Purpose

Headquartered in Toronto, Canada, the Toronto-Dominion Bank and its subsidiaries are collectively known as TD Bank Group (TD). TD had CDN$1.9 trillion in assets on July 31, 2023. TD also ranks among the world’s leading online financial services firms, with more than 16 million active online and mobile customers. TD offers a full range of financial products and services to over 27.5 million customers worldwide through four key business lines: - Canadian Personal and Commercial Banking including TD Canada Trust, Business Banking, and MBNA - U.S. Retail including TD Bank, America’s Most Convenient Bank, TD Auto Finance (U.S.), TD Wealth (U.S.) and TD’s investment in Schwab - Wealth Management & Insurance including TD Wealth (Canada), TD Direct Investing, and TD Insurance - Wholesale Banking including TD Securities and TD Cowen