Excel Specialist / Accounting Expert

We are a small IT company in Canada. We are seeking a detail-oriented and highly organized Excel Specialist to join our team. If you are skilled in Microsoft Excel, Accounting, Bookkeeping and building reports, we want to hear from you. Looking for a team member to join us and work 9AM – 5PM EST (Eastern Time Zone)

Key Responsibilities:

-Proficiently use Microsoft Excel to create, maintain, and analyze financial reports and data. (MUST KNOW how to use formulas such as index, vlookup, countif, sumif, if statements, and it will be added-value if you can use VBA macro)
-Reconcile bank records with vendor bills to ensure accuracy and completeness of financial records using Accounting software such as Dext or using Excel.
-Perform data entry tasks related to financial transactions, maintaining precision and attention to detail.
-Manage bookkeeping activities to keep financial records organized and up-to-date.
-Generate and send invoices to clients, ensuring all necessary information is included and accurate.
-Generate Charts, Pivot Tables, Graphs and Tables for Business Analysis. Such as PNL reports.
-Collaborate with team members to gather and input financial data into various systems.
-Assist with general administrative tasks, utilizing Microsoft 365 for communication and document management.
-Collaborate with the finance team to develop comprehensive financial reports using Excel.
-Contribute with process improvements and developing SOPs.

Qualifications:

Strong proficiency in Microsoft Excel, including the ability to create complex formulas, pivot tables, and graphs.
Previous experience in report development using Excel.
Proficiency in using Microsoft 365 tools, including Outlook, Word, and Teams.
Previous experience working with Accounting, Finance, and Quickbooks would be preferred.
Excellent organizational skills and a high level of attention to detail.
Understanding of basic accounting principles and bookkeeping practices.
Remote access via VPN to work is required
Strong analytical skills and the ability to generate meaningful insights from financial data.
Exceptional communication skills, both written and verbal.
Strong problem-solving skills and the ability to adapt to changing priorities.

How TO APPLY (MUST REQUIRE):
-Please provide a link to your resume and a 30 seconds short voice clip introducing yourself. Also, fee free to share as much experience you have with Building Reports using Excel or developing Macros using Excel with us.