Finance and operations analyst, HD foundation

With a career at The Home Depot, you can be yourself and also be part of something bigger.

Position Purpose:

Reporting to the Sr. Manager Community Investment, the Finance and Operations Analyst is responsible for the financial accountability, reporting and tracking for The Home Depot Canada Foundation. Managing the Foundation’s day-to-day financial operations and leveraging key data to provide insights and metrics to increase the Foundation’s overall impact and fundraising capabilities. This role is also responsible for financial disbursements (grants), accurate maintenance of financial records and leading the Home Depot Canada Foundation’s annual audit.

The Analyst will be responsible for the project management and system administration of the Foundation’s granting and CRM system.

Position Responsibilities:

• Manage and oversee all The Home Depot Canada Foundation’s financial operations, including accounting, budgeting, forecasting and financial analysis
• Support monthly, quarterly, and annual financial reporting requirements to the Foundation’s treasurer and Board
• Use superior Excel skills to analyze data and build insightful reports for senior leaders to identify greatest fundraising opportunities
• Provide key business analysis and support ad-hoc reporting requests
• Support budget planning and financial forecasting processes
• Maintain data governance to ensure consistency and accuracy in reporting as well as to identify and solve any discrepancies that arise
• Build strong working relationships with key stakeholders in order to understand the business and the business needs
• SmartSimple system administration
• Process financial requisitions, tracking and reconciliation of expenses. This includes processing all invoices, cheque requisitions, in-kind donations, wire transfers, expense forms, and grant allocations for external partners
• Maintain accurate account payables and receivables ledger to ensure internal/external donations and invoices are accurately recorded
• Support relationship with bookkeeper by providing information as it relates to payables/receivables, banking and monthly reconciliation
• Process incoming donations, sorted by campaign, and prepare deposits
• Run monthly reconciliation reports to verify with accounting records
• Generate segmented tax receipts for processed donations
• Maintain record-keeping procedures, returned mail/tax receipt coding and donor information
• Supports other Foundation strategies and initiatives as required

Education and Professional Skills/Knowledge

Bachelor’s degree in accounting, finance, business management or other related field

• 3-4 years of experience in financial analysis & reporting
• Advanced Microsoft Excel skills
• Strong data collection and analytical skills including the ability to manage, manipulate and streamline large volumes of data
• Must have a Bachelor’s degree in Accounting, Computer Science, Finance, Business or equivalent.
• Accounting designation (CPA or CFA) is an asset but is not required
• Working knowledge of SmartSimple granting system is an asset but is not required
• Demonstrate expertise in business analysis and financial modeling
• Excellent attention to detail is required
• Strong analytical and problem solving skills
• Experience in a non-profit organization and understanding of CRA regulations considered a strong asset
• Highly organized with a proven ability to manage projects, multi-task and operate under pressure with competing deadlines
• Ability to design and utilize diverse communications methods and tools to effectively target messages to key stakeholders and clearly convey thoughts, concepts and direction
• Strong work ethic and sense of responsibility and confidentiality