Analyst, Business Intelligence Systems

3 weeks ago

Toronto, Canada Scotiabank Full time

Requisition ID: 194371

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

**What your role will be**

Analyst, Business Intelligence Systems

The Analyst, Business Intelligence Systems is responsible for administering subvention and performance reporting for the Automotive Finance OEM programs offered by Automotive Finance (AF) business line, and for providing support and service to AF management team on all matters related to AF data, data sources, and data extraction processes.

**What you'll be doing**
- Responsible for subvention program performance reporting process for all Automotive Finance partners and customers:

- Prepares and distributes subvention program reports (buying statistics, Loyalty Program, daily/monthly/YTD bookings, etc.) to all stakeholders.
- Responds to manufacturer representative inquiries on discrepancies and irregularities on manufacturer subvention program reports.
- Reviews manufacturer subvention program reports for consistency and accuracy, and provides recommendations to Manager, Integrated Systems Solutions on improving these reporting.
- Responsible for operating internal reports including for Audit, Finance and Risk Management.
- Supports the manufacturer subvention invoicing data preparation for all Automotive Finance partners (new loans, CPO, lease and sub-prime):

- Prepares the subvention invoicing data and flat files for the manufacturer partners.
- Assists Senior Analyst, Business Intelligence and Information Systems and Senior Analyst, Finance with manufacturer representative inquiries and disputed subvention amounts.
- Assists the administration and maintenance of AF and DMS databases used for manufacturer invoicing, manufacturer and AF management reporting processes, provides recommendations to the Manager, Integrated Systems Solutions on solutions to improve processes, makes changes to Access database scripts to accommodate manufacturer’s requests for changes in manufacturer reporting/invoicing.
- Assists the analysis of integrity of data used for manufacturer subvention invoicing and manufacturer reporting including periodic reconciliation of data sources, and provides resolution for data related issues & support to core constituents - AF Management team, Dealer Finance Centers and Canadian Dealer Lease Services Inc.
- Supports the finance planning team in running and maintenance of access databases to aid regular reporting activities.
- Assists the response to manufacturer representative’s requests for information on invoices, program performance reports, trend analysis, new initiatives/programs and any other data-related inquiries for OEM programs.
- Understand how the Bank’s risk appetite and risk culture should be considered in day-to-day activities and decisions.
- Actively pursues effective and efficient operations of his/her respective areas in accordance with Scotiabank’s Values, its Code of Conduct and the Global Sales Principles, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational, compliance, AML/ATF/sanctions and conduct risk.
- Champions a high-performance environment and contributes to an inclusive work environment.

**What you need to succeed**
- University degree in computer science, engineering, business or similar field is required.
- Database related (MS Access, SQL scripts) work experience preferred.
- Knowledge of and hands-on experience in the database management (design and analysis, SQL statements, macros, data import/export, VBA scripts).
- Knowledge of business-related computer software specifically MS Access, Excel, PowerPoint, and Word.
- Expertise with data analysis and programming
- Knowledge of financial management concepts and accounting principles.
- Strong customer service attitude.

**What we’re offering **
- The opportunity to join a forward-thinking organization where you are surrounded by a collaborative team of innovative thinkers.
- A competitive compensation and benefits package.
- An organization committed to making a difference in our communities
- for you and our customers.
- You can expect to be recognized and rewarded for high-performance. You’ll be supported by leadership through meaningful development conversations that enable faster advancement and internal training to support your growth and development.
- You’ll receive clear, transparent criteria to progress in your career.

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.

  • Business Systems Analyst

    4 weeks ago

    Toronto, Ontario, C6A, Ontario, Canada Business Systems Analyst Full time

    Business Systems Analyst (Process Mapping & Controls Infrastructure)Client: Big 5 BankLocation: Downtown Toronto. 1-2 days per week in office.Duration of Contract/Perm: 6-month contract with potential to extend or convertHours/week: 37.5 hours/weekPosition Overview: We are seeking a highly skilled and versatile professional to place at our client. This...

  • Business Intelligence Analyst

    4 days ago

    Toronto, Ontario, Canada Apex Systems Full time

    Job OverviewApex Systems is a global IT services firm with a staffing practice that specializes in placing skilled professionals at top clients. As a Business Intelligence Analyst, you will play a key role in helping our client, a leading Big Five Bank, improve their business intelligence and data processes.Key ResponsibilitiesTranslate business needs into...

  • Business Systems Analyst

    4 weeks ago

    Toronto, Canada Business Systems Analyst (Process Mapping & Controls Infrastructure) Full time

    Business Systems Analyst (Process Mapping & Controls Infrastructure)Client: Big 5 BankLocation: Downtown Toronto. 1-2 days per week in office.Duration of Contract/Perm: 6-month contract with potential to extend or convertHours/week: 37.5 hours/weekPosition Overview: We are seeking a highly skilled and versatile professional to place at our client. This...

  • ▷ Urgent Search: Business Systems Analyst

    4 weeks ago

    Toronto, Canada Business Systems Analyst (Process Mapping & Controls Infrastructure) Full time

    Business Systems Analyst (Process Mapping & Controls Infrastructure) Client: Big 5 Bank Location: Downtown Toronto. 1-2 days per week in office. Duration of Contract/Perm: 6-month contract with potential to extend or convert Hours/week: 37.5 hours/week Position Overview: We are seeking a highly skilled and versatile professional to place at our client....

  • Business Systems Analyst

    4 weeks ago

    Toronto, Canada Business Systems Analyst (Process Mapping & Controls Infrastructure) Full time

    Business Systems Analyst (Process Mapping & Controls Infrastructure) Client: Big 5 Bank Location: Downtown Toronto. 1-2 days per week in office. Duration of Contract/Perm: 6-month contract with potential to extend or convert Hours/week: 37.5 hours/week Position Overview: We are seeking a highly skilled and versatile professional to place at our...

  • Business Systems Analyst

    4 weeks ago

    Toronto, Canada Business Systems Analyst (Process Mapping & Controls Infrastructure) Full time

    Business Systems Analyst (Process Mapping & Controls Infrastructure)Client: Big 5 BankLocation: Downtown Toronto. 1-2 days per week in office.Duration of Contract/Perm: 6-month contract with potential to extend or convertHours/week: 37.5 hours/weekPosition Overview: We are seeking a highly skilled and versatile professional to place at our client. This...

  • Business Systems Analyst

    4 weeks ago

    Toronto, Canada Business Systems Analyst (Process Mapping & Controls Infrastructure) Full time

    Business Systems Analyst (Process Mapping & Controls Infrastructure)Client: Big 5 BankLocation: Downtown Toronto. 1-2 days per week in office.Duration of Contract/Perm: 6-month contract with potential to extend or convertHours/week: 37.5 hours/weekPosition Overview: We are seeking a highly skilled and versatile professional to place at our client. This...

  • Business Systems Analyst

    4 weeks ago

    Toronto, Canada Business Systems Analyst (Process Mapping & Controls Infrastructure) Full time

    Business Systems Analyst (Process Mapping & Controls Infrastructure)Client: Big 5 BankLocation: Downtown Toronto. 1-2 days per week in office.Duration of Contract/Perm: 6-month contract with potential to extend or convertHours/week: 37.5 hours/weekPosition Overview: We are seeking a highly skilled and versatile professional to place at our client. This...

  • Business Systems Analyst

    3 weeks ago

    toronto, Canada Business Systems Analyst (Process Mapping & Controls Infrastructure) Full time

    Business Systems Analyst (Process Mapping & Controls Infrastructure)Client: Big 5 BankLocation: Downtown Toronto. 1-2 days per week in office.Duration of Contract/Perm: 6-month contract with potential to extend or convertHours/week: 37.5 hours/weekPosition Overview: We are seeking a highly skilled and versatile professional to place at our client. This...

  • Business Systems Analyst

    4 weeks ago

    Toronto, ON, Canada Business Systems Analyst (Process Mapping & Controls Infrastructure) Full time

    Business Systems Analyst (Process Mapping & Controls Infrastructure) Client: Big 5 Bank Location: Downtown Toronto. 1-2 days per week in office. Duration of Contract/Perm: 6-month contract with potential to extend or convert Hours/week: 37.5 hours/week Position Overview: We are seeking a highly skilled and versatile professional to place at our...

  • Business Intelligence Analyst

    1 day ago

    Toronto, Ontario, Canada Nexus Systems Group Inc. Full time

    Job Description:At Nexus Systems Group Inc., we are seeking a skilled Business Intelligence Analyst to join our dynamic team. The ideal candidate will be responsible for transforming raw data into meaningful insights through the development of interactive and visually appealing reports and dashboards using Microsoft Power BI.Our team focused on internal...

  • Business Intelligence Data Analyst

    4 days ago

    Toronto, Ontario, Canada Apex Systems Full time

    About the RoleWe are seeking a skilled Business Intelligence Data Analyst to join our team at Apex Systems. As a key member of our organization, you will be responsible for analyzing complex data sets and creating actionable insights to inform business decisions.The ideal candidate will have strong analytical skills, excellent communication abilities, and...

  • Business Intelligence Analyst

    2 weeks ago

    Toronto, Canada VIA HFR - VIA TGF Inc. Full time

    **Job Requirements **Would you like to be an active stakeholder in a major modernization project? VIA Rail is about to change all its reservation platform for all its systems throughout Canada and is looking for a Business Intelligence Analyst who would like to play an important role in an autonomous, efficient, and competent team. As a Business...

  • Business Intelligence Analyst

    3 weeks ago

    Toronto, Canada Cision Full time

    Cision employs the brightest, most passionate people in the tech industry. We’d love for you to join our growing team! We invest in our people through training and professional development while supporting you along the way—all so you can meet your career goals. To us, the most important measure of our success is yours. **Must reside in the Toronto, ON,...

  • Business Intelligence Analyst

    3 weeks ago

    Toronto, Canada Sinai Health System Foundation Full time

    **12 month contract** **Salary range**:$76,898 to $96,123 Sinai Health Foundation raises and stewards funds to support Sinai Health. Sinai Health is Canada’s leading integrated health system and comprises Circle of Care; Hennick Bridgepoint Hospital; Lunenfeld-Tanenbaum Research Institute; and Mount Sinai Hospital, Joseph & Wolf Lebovic Health Complex....

  • Business Intelligence Analyst

    1 week ago

    Toronto, Canada FLEETCOR Full time

    ROLE FUNCTION AND PURPOSE The Business Intelligence Analyst works closely with the business leaders and the Director, Sales Compensation to administer sales variable compensation calculations, modeling and ROI analysis, strategic partnership management, reporting deliverables including preparing management reports, presentations, and documenting business...

  • Business Intelligence Analyst

    2 weeks ago

    Toronto, Canada St. Louis Bar & Grill Full time

    **Business Intelligence Analyst** We are looking for an experienced Business Intelligence Analyst. In this BI Analyst role, you report directly to the VP, Business Intelligence, and work to support the BI Team at Aegis Brands Inc. (“Aegis”). Aegis is a consolidator of brands in the food & beverage space with the mission to allow for an independent...

  • Business Intelligence Analyst

    3 weeks ago

    Toronto, Canada Maximus Services, LLC Full time

    **Description & Requirements** **About Maximus** Maximus has been reinventing the way government agencies engage with citizens and are sought out by governments to solve complex problems. By supporting various Healthcare Administration, Employment and Citizen service programs worldwide in the United States, Australia, Saudi Arabia, Singapore, South Korea,...

  • Senior TM1 Systems Analyst

    2 weeks ago

    Toronto, Canada S.i. Systems Full time

    Our Public Sector Client requires aSenior TM1 Systems Analyst (10+ years) to create, design, and maintain TM1 business intelligence and financial solutions.Responsibilities to Include: Develop and maintain cubes to store business data to support querying and reporting Create rules to automate cube calculations (including forecasts and allocations) Create ETL...

  • Analyst, Business Intelligence

    4 days ago

    Toronto, Canada Great Canadian Full time

    **Position Summary**: Under the general direction of the Sr. Manager, Business Intelligence and Director, Data Product, the Analyst, Business Intelligence will develop analysis and reports to understand the company’s performance and areas of opportunity. They will work alongside the Data Product team to ensure robust pipelines. They will also develop...