Reporting Analyst

AutoTrader.ca; Toronto; On-site; CAD 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a Reporting Analyst to enhance data-driven decision-making through insightful reporting and analysis. In this role, you will leverage your analytical skills to develop and maintain reports and dashboards, providing strategic insights that drive performance improvement across various departments. Your expertise in tools like Power BI and Excel will be crucial as you work with large datasets and automate reporting processes. This dynamic position offers an opportunity to collaborate with cross-functional teams, ensuring that data analysis supports business objectives. Join a forward-thinking company that values innovation and offers a supportive work environment with great benefits.

Benefits

Gym discounts

Local in-office free gyms

Employee and Family Assistance program

Weekly virtual wellness events

Conferences & training budget

Regular internal training programs

3% matching towards your pension

Annual bonus structure

Qualifications

• Bachelor’s degree required; 2-5 years of experience in reporting or data analysis.
• Proficiency in Excel and Power BI is essential for this role.

Responsibilities

• Analyze and report on key business data to provide actionable insights.
• Design and maintain reports and dashboards for business leaders.

Skills

Data Analysis

Reporting Automation

Excel

Power BI

SQL

Communication Skills

Problem-Solving

Education

Bachelor’s degree in Business, Data Science, Economics

Tools

Power BI

Excel

SQL

Salesforce

Tableau

Job description

TRADER Corporation is a trusted Canadian leader in online media, dealer and lender services. The company is comprised of AutoTrader.ca, AutoSync and Dealertrack Canada. AutoTrader.ca (AutoHebdo.net in Quebec) offers the largest inventory of new cars and used cars in Canada, receiving over 25 million monthly visits to its marketplace. With over 3,500 subscribers and counting, AutoSync is the largest and fastest growing dealer and OEM software provider in Canada. The platform's suite of connected automotive software solutions brings advertising, conversion and operational support together, synchronizing the entire retail process. AutoSync's diverse range of offerings includes: vAuto, EasyDeal, xtime, Motoinsight, Activix, TAdvantage and TRFFK. Dealertrack is Canada’s largest automotive financing portal, enhancing efficiency and profitability for all major segments of the automotive, marine, recreational vehicle, motorcycle and powersport retail industries. Over 6.5 million credit applications are submitted via the Dealertrack Canada portal each year. Collateral Management is a national, end-to-end, managed technology solution that offers industry insight and multi-channel collection strategies to maximize funds recovered. Collateral Management helps you remain compliant in all jurisdictions, alleviating your exposure to reputational and financial risks. Visit tradercorporation.com to learn more.

Experience leveraging AI, Generative AI (GenAI) to enhance engineering productivity, automate repetitive tasks, and optimize workflows. Candidates should demonstrate the ability to integrate AI-driven solutions into their daily work — such as code generation, debugging, reviews, documentation, and decision support—to improve efficiency for themselves and their teams. A proactive approach to exploring and implementing AI tools that drive innovation and streamline development processes is highly valued.

The Reporting Analyst is responsible for the design, development, and maintenance of reports and dashboards, assisting with the analysis and reporting of business data across various departments. This role will focus on data analysis, reporting automation, and delivering actionable insights to support decision-making and performance improvement. The position is responsible for analyzing and reporting on performance to improve results and facilitate future goal setting as well as reviewing current processes to improve efficiency, quality, and accuracy. Proficiency in Power BI is required, and experience with SQL is preferred, as the role involves working with large datasets and optimizing data retrieval. The position also requires expertise in Excel, data visualization tools, and an understanding of business data from CRMs like Salesforce, as well as the ability to produce polished reports that provide valuable business insights.

Key Responsibilities:

1. Data Analysis & Reporting: Responsible for gathering, analyzing, and reporting on key business data to provide insights that drive strategic decisions. This includes data cleaning, trend identification, and performance analysis across various departments and business functions.
2. Report Development & Maintenance: Design, develop, and maintain routine and ad-hoc reports for business leaders and teams. Ensure reports are clear, accurate, and aligned with business objectives. Provide actionable insights through Excel, Power BI, Tableau, or other data visualization tools.
3. Dashboard & Data Visualization: Build and maintain interactive dashboards to provide real-time business data insights through CRM reporting or Data visualization tools like Power BI, Tableau, etc. Collaborate with stakeholders to understand reporting needs and deliver tailored dashboards to track business performance.
4. Process Improvement & Automation: Identify opportunities for automating reporting processes and improving data accuracy and efficiency. Develop automated reporting systems that reduce manual efforts and improve data accessibility.
5. Performance Analysis & Reporting: Monitor key performance indicators (KPIs) and metrics across business units. Provide regular updates on performance, highlight trends, and identify areas for improvement. Use advanced Excel functions, SQL queries, and other tools to analyze large datasets and draw actionable conclusions.
6. Collaboration & Support: Work closely with cross-functional teams (e.g., IT, Finance, Marketing) to gather data requirements and deliver reports that align with business needs. Provide training and support to team members on report interpretation and usage.
7. Ad-hoc Reporting & Projects: Manage ad-hoc reporting and analytical projects as needed by the business. Collaborate with other departments to ensure data analysis supports project objectives and problem resolution. Provide insights that drive process improvement and strategic decision-making.

Job Requirements:

1. Please indicate if required (R), preferred (P) or asset (A)
2. - Bachelor’s degree in Business, Data Science, Economics, or a related field (R)
3. - Minimum 2-5 years of experience in a reporting or data analyst role (R)
4. - Strong analytical and computer skills with proficiency in Excel (pivot tables, vlookups, macros, other formulas) and data visualization tools (e.g., Power BI) (R)
5. - Experience with SQL or other data querying languages (P)
6. - Experience with CRM systems (e.g., Salesforce) is an asset (P)
7. - Familiarity with cloud platforms (e.g., AWS, Google Cloud) is desirable (P)
8. - Experience with programming languages (e.g., Python or R) is a plus (A)
9. - Strong communication skills, both oral and written, with the ability to present complex data in an understandable format.
10. - Ability to prioritize tasks, manage deadlines, and work in a fast-paced environment.
11. - Ability to work with minimal supervision and collaborate across teams.
12. - Strong problem-solving and critical thinking skills.
13. - Demonstrated ability to analyze data and provide actionable insights.

What’s in it for you…

We understand that there is life at work and life outside of work. Here are a few benefits we all benefit from that support us to be our creative best.

Fitness and wellness:

- We provide discounts to nation-wide gyms, onsite gyms (when we’re in the office), an Employee and Family Assistance Program, as well as a virtual wellness program.

Benefits from Day 1:

• - Gym discounts
• - Local in-office free gyms
• - Employee and Family Assistance program
• - Weekly virtual wellness events
• - Conferences & training budget
• - Regular internal training programs

Financial planning:

- Let us help you invest in your future with 3% matching towards your pension and multiple forms of income protection.

Competitive salary:

- Annual bonus structure

- 3% CPP matching