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

**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 serv