Business Intelligence Analyst

Looking for a great opportunity to work in Canada’s largest Automotive Group? Join the Family today, the Dilawri Lifestyle is waiting for you!

Dilawri life is full of excitement, click here for a glimpse into the road ahead. 

Dilawri Group of Companies is currently looking to fill the position of a Business Intelligence Analyst.

Under the supervision of the National Manager, Application Development and Data Intelligence, the Business Intelligence (BI) Analyst is responsible for supporting financial and operational reporting needs through hands-on data analysis, dashboard development, and process improvement. This role requires strong technical skills in working with databases, reporting platforms, and data visualization tools to deliver accurate, timely, and actionable insights. The BI Analyst will collaborate with stakeholders across the business to gather requirements, design and maintain dashboards, and perform in-depth analysis to identify trends, interpret results, and recommend enhancements. This is a hands-on role focused on building, maintaining, and optimizing BI solutions to support informed decision-making at all levels of the organization.

Essential Duties:

• Develop, consolidate, and streamline dashboards to deliver enhanced analytics and actionable insights across the organization.
• Design and build operational and financial reports and dashboards (charts, graphs, visualizations) using reporting platforms such as GCP, BigQuery, Looker (LookML), and other ERP or financial systems.
• Support implementation, maintenance, and optimization of financial databases and ETL (Extract, Transform, Load) processes.
• Assess existing data structures, identify limitations, and propose improvements or new solutions in collaboration with the National Development Team.
• Configure and maintain data interfaces to ensure complete and accurate data exchange between the company’s ERP system, data warehouse, and reporting tools.
• Partner with the national development team to help define and execute a sustainable data strategy to support organizational growth.
• Perform in-depth data analysis and translate findings into clear, concise recommendations for business stakeholders.
• Communicate complex analytics in a simple, actionable way to non-technical audiences through strong presentation and storytelling skills.
• Define, document, and maintain data governance practices, assumptions, and procedures to ensure reporting accuracy and reliability.
• Perform other related duties as assigned.

Qualifications:

• University or post-secondary degree in Business, Finance, Computer Science and/or related discipline along with reporting / technological accreditation.
• Minimum of 5 years experience in a financial or operational data role with proven leadership in data-driven projects.
• Understanding of finance and accounting concepts and principles.
• Broad experience with techniques in collecting data, analyzing information, generating reports and database principles.
• Ability to design, develop and deploy financial reports with any of the reporting platforms with strong knowledge of SQL (Tableau, Looker, Power BI, Domo or Cognos etc.)
• Strong analytical skills and accounting technical knowledge
• Ability to work in a fast-paced high-pressure environment
• Reliable, self-motivated, and self-disciplined
• Capability of managing multiple projects simultaneously
• Valid Driver’s License
• Industry related training and certification as required

Experience:

• Demonstrated experience working with financial principles, technology and reporting development in an automotive industry or a similar retail / finance environment
• SQL, data modeling, data mining, database management and analysis knowledge
• Understanding of automotive retail management systems (a.k.a., dealer management systems), CRM, inventory management, financial reporting and related technologies is considered an asset
• Experience in finance related information-intensive industries
• Experience of working through business change or business transformation
• Salary for this position is based on the candidate’s experience, skills, and qualifications. The range provided is intended as a guideline and may vary depending on individual background and expertise.

Advantages of the Dilawri Lifestyle 

• First hand mentoring from auto industry leaders
• Innovative, exciting work environment
• Employee discounts on vehicle purchases and leases
• Employee discounts on service and parts
• Career growth opportunities
• Competitive compensation
• Generous benefit package
• Exclusive Dilawri offers
• A true Family culture 

Dilawri Group of Companies is Canada’s largest automotive group with 75 + franchised dealerships representing 35+ automotive brands throughout Quebec, Ontario, Saskatchewan, Alberta, British Columbia and Washington D.C. Privately owned and operated by the Dilawri family since 1985, the company continues to expand its footprint in Canada, building on its history of excellence in the automotive industry. With more than 4,000 employees, Dilawri Group of Companies is proud to offer exceptional products and customer service in every dealership.

Dilawri Group of Companies is not only a leader in the automotive industry, it is also a leader in the communities it serves, having established The Dilawri Foundation in 2002. The Dilawri Foundation has contributed tens of millions of dollars throughout Canada supporting a variety of charitable causes.

Go to our website to see more about our company and the many reasons why you will want to work for us!

We do thank all applicants in advance, but only those selected for an interview will be contacted. Thank you for your interest!