Data/Financial Analyst

Join our team at Trotman Auto Group as a Data / Financial Analyst!

We are seeking a detail-oriented and strategic Data / Financial Analyst to join our team on a full-time basis. This role is critical to building and optimizing our data and analytics infrastructure, enabling informed decision-making and driving financial performance across our dealership network. The ideal candidate will combine strong financial acumen with advanced data analytics skills to deliver actionable insights and scalable solutions.

Schedule: Full-time
Salary: $100,000 – $110,000 per year + 10% performance-based bonus

• Health & Dental Care and Employee Assistance Program: Access a wide range of medical, dental, and mental wellness services to keep you and your family healthy.
• RRSP: Secure your future with our retirement savings plan.
• Paid Time Off: Enjoy a balanced work-life schedule.
• Career Growth and Development: Access to paid training, NADA courses for various departments, and internal professional and career development opportunities.

• Design and implement a centralized data warehouse and reporting infrastructure
• Collect, clean, and analyze large datasets from multiple sources (sales, service, finance, CRM)
• Develop and maintain financial models, dashboards, and KPIs to support strategic decisions
• Perform budgeting, forecasting, and variance analysis for multiple business units
• Prepare detailed financial reports and presentations for senior leadership
• Identify trends and opportunities for cost optimization and revenue growth
• Collaborate with Finance, Operations, and Marketing teams to deliver actionable insights
• Ensure data integrity and compliance with accounting standards and internal controls

Technical Experience:

• Bachelor’s degree in Finance, Accounting, Economics, Data Science, or related field
• 3–5 years of experience in financial analysis, data analytics, or FP&A (automotive or retail industry experience is an asset)
• Advanced Excel skills (pivot tables, macros, financial modeling)
• Proficiency in SQL and Power BI or Tableau for data visualization
• Familiarity with ERP systems and CRM platforms
• Strong analytical and problem-solving skills with attention to detail
• Excellent communication skills to present complex data clearly
• Ability to work independently and manage multiple priorities in a fast-paced environment

Preferred Skills:

• MBA/CPA or CFA designation (or in progress) is an asset
• Knowledge of Canadian GAAP and IFRS
• Experience with predictive analytics or machine learning tools is a plus
• Collaborative mindset and adaptability to evolving business needs

Valid BC driver’s license and vehicle for travel to lower mainland dealerships when required.

Be part of an amazing team that lives their values out loud each day! Trotman Auto Group is a leading dealer group in British Columbia, representing fourteen major OEM brands through thirteen dealerships. Recognized as one of Canada’s Best Managed Companies, we excel in business performance, innovation, and growth, driven by our vibrant culture and world-class team of automotive professionals.

Trotman Auto Group is proudly an equal opportunity employer and welcomes all applications.

Please note: Only selected candidates will be contacted.
Trotman Auto Group does not offer sponsorship for foreign workers or facilitate Labour Market Impact Assessments (LMIAs) for this position. Applicants must be legally eligible to work in Canada at the time of application.