Trotman Auto Group · 11 hours ago
Data/Financial Analyst
Auto, WV
Full-time
Onsite
Mid Level
$100K/yr - $110K/yr
3+ years expTrotman Auto Group is a leading dealer group in British Columbia, recognized as one of Canada’s Best Managed Companies. They are seeking a detail-oriented Data / Financial Analyst to optimize their data and analytics infrastructure, enabling informed decision-making and driving financial performance across their dealership network.
AutomotiveCustomer ServiceRetail
No H1B
Responsibilities
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
Qualification
Required
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
Valid BC driver's license and vehicle for travel to lower mainland dealerships when required
Preferred
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
Benefits
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.
Company
Trotman Auto Group
Trotman Auto Group is an automotive dealership and service center.
501-1000 employees
Funding
Current Stage
Late StageCompany data provided by crunchbase