Data Analyst

As a data analyst for Ford Pro, you will be responsible for assisting with the monthly commissions process, workflow management, and performing a variety of different analyses to drive the business. This position works collaboratively with internal stakeholders such as Legal, Finance, Revenue Operations and Sales to ensure commissions are executed with efficiency and accuracy.

The primary responsibilities for this position include but are not limited to:

• Administer all sales variable payments, including commissions, draws, MBOs, and SPIFFs in accordance with processes
• Run analysis (SQL reports, excel) to compare variance at the time of termination.
• Ensure accurate and timely distribution of individual sales compensation documents to a global sales organization.
• Calculate and book monthly commission accruals.
• Resolve commissions disputes and inquiries and process corrections and adjustments.
• Understand and apply the commission plan consistently, ensuring commissions calculations comply with policies.
• Participate in building a global sales compensation team, administering appropriate technologies, and incorporating best practices.
• Support Sales leadership, Sales Operations, and Finance teams with compensation metrics and reporting
• Create and document business processes for monthly/quarterly close, commission accounting tasks, and audits; perform monthly audits and data reviews to ensure commission accuracy.
• Set up and maintain all commission plan participants, including new hires, terminations, and in-year and/or year-over-year changes.
• Assist with ad-hoc sales finance analysis as required.
• Proactively recommend and deliver process improvements.
• Coordinate, prepare, and analyze documents for SOX requirements and audits.
• Help meet SOX compliance by auditing bi-weekly commission statements and completing documentation for external auditors.
• Utilize the Salesforce tool to research commission data that has been provide by the sales team.

Required Skills & Qualifications:

Minimum Requirements:

• Bachelor’s degree (Successful candidates will be required to provide proof of degree completion for the highest level of education attained.  If the degree was obtained from a school outside of Canada, an Education Credential Assessment report showing Canadian equivalency is also required)
• 2+ years of experience with sales compensation and dealer payments. 
• 2+ years of experience in Data Analysis. 
• Experience in data analysis and some programming (e.g. SQL, python).

Preferred Requirements:

• Previous experience in a similar role (preferably, within an automotive company).
• Knowledge of data visualization tools (e.g. Power BI, Qlik Sense, Tableau, Looker, etc.).
• Experience with ad-hoc sales finance analysis. 
• Understanding of all sales variable payments, including commissions, draws, MBOs, and SPIFFs.
• Expert in attention to detail to ensure process and computational accuracy.
• Excellent organizational skills with the ability to manage multiple tasks simultaneously.
• Effective communication across multiple stakeholders and to drive commissions dispute resolution, inquiries and necessary adjustments.

We thank all applicants for their interest, but only those selected for an interview will be contacted.

Ford of Canada is an Equal Opportunity Employer and is committed to a culturally diverse workforce. Accommodations for applicants with disabilities throughout the recruitment, selection and / or assessment processes, where needed, are available upon request. Please inform Human Resources of the nature of any accommodation(s) that you may require.   

Candidates for this position must be legally entitled to work in Canada. Ford Motor Company of Canada, Limited does not sponsor work permit applications.