Data Analyst

3 weeks ago

Richmond, Canada OpenRoad Auto Group Full time

**UNLIMITED POSSIBILITIES AHEAD**

**Position**: Data Analyst

**Status**: Full-Time

**Location**:Head Office Richmond - 100% in office
**Department**:Information Technology

We believe in doing good for our customers and for ourselves. Whether it’s launching the most anticipated model of the year or purchasing a vehicle for your next adventure, great people and relationships are at every turn with OpenRoad.

We are proud of our forward-thinking culture developed over 40 years of continuous improvement initiatives. OpenRoad is one of the largest and fastest-growing automotive retail groups in the country (representing 20 automotive brands across 25 locations) with a shared vision to become the national automotive leader in customer experience. As one of Canada’s Best Employers and Best Managed Companies, we are looking for team players who are excited to continually learn, work hard, and take ownership of their roles.

A Career at OpenRoad Means You’ll Enjoy:

- Opportunity to work with a variety of OEM BRANDS: Acura, Audi, BMW, Genesis, Honda, Hyundai, Infiniti, Jaguar, Land Rover, Lexus, Mazda, Mercedes-Benz, MINI, Porsche, Rolls-Royce, Subaru, Toyota, Volkswagen
- Amazing Incentives include but not limited to Discounted Vehicle Purchasing Program, Computer Rebate Program, Employee Referral Program, Employer RRSP Matching
- Internal and External, Training & Development opportunities for skill development and growth
- Be part of a collaborative, friendly and progressive work culture with an emphasis on transparency, innovation, relationship, and empowerment
- Comprehensive Extended Health and Dental plan; tailored towards Associate wellness
- Recognition and Engagement Events

The **Data Analyst** is responsible for organizing, compiling, aggregating and summarizing data both internally and externally. This role will take raw source data from both internal and external stakeholders and turn it into useable information to then build reporting and analytics. This role will additionally support ad hoc analysis, reporting, and inquiries. This role requires high degree of accuracy and attention to detail to create and extract meaningful insights and trends from data, which can be used to improve business processes, optimize performance, and drive strategic decision-making. This role will also act as a liaison between Subject Matter Experts and the external data team.

**Role Responsibilities**:

- Perform data analysis, mining, and modelling to create routine, complex ad-hoc and custom queries.
- Drive the collection and organization of new data from both internal and external sources.
- Responsible for data preparation, quality checks and data cleanliness to prepare selection populations and samples.
- Work with departments to establish and prioritize business and information needs; and make recommendations about the methods and ways in which a company obtains and analyses data to improve quality and the efficiency of data systems.
- Develop and produce reports upon request including dashboards and report visualizations.
- Develop complex SQL queries (Stored procedures, triggers) to retrieve, manipulate, and transform data from various sources especially GCP BigQuery.
- Data Extraction and Visualization - Query data and build data visualizations of varying degrees of complexity in tools like Tableau, Tableau Prep, SQL, and GCP.
- Extract, prepare, clean and process large amounts of data to support various data analyses and projects.
- Ensure the quality, accuracy, reliability, and timeliness of the data and reports available within the BI environment through meticulous testing, automated and manual data reviews, performance monitoring, contingency planning, consistency reviews, and other methods as appropriate.
- Support the BI end-users through training sessions, user guides, one-on-one consultations, advice, workshops, troubleshooting, downtime procedures, and issue resolution.
- Process change requests on existing data sets.
- Maintain integrity of data and report as well as reinforce confidentiality of research.
- Perform other duties as assigned

**Qualifications/Skills/Job Requirements**:

- Minimum one to three (1-3+) years experience working with data, numbers, statistics, analytics or related experience.
- Post secondary degree or diploma required.
- Degree in Information Systems or Data Analytics preferred.
- Advanced proficiency in cloud computing (GCP BigQuery), data science with python and/or Visual Studio.
- Advanced proficiency in Tableau and Tableau Prep.
- Advanced proficiency in Microsoft Office including Excel, Word, PowerPoint, Outlook.
- Advanced proficiency in SQL with the ability to write complex queries for data extraction and manipulation (CTEs, stored procedures, triggers) and knowledge in database management systems (e.g., SQL Server, MySQL, PostgreSQL) Self-reliant exploring, extracting, analyzing, and presenting information with Excel (PivotTables, writing VBA code, etc.).

  • Data Analyst

    3 days ago

    Richmond, British Columbia, Canada Sunwins Enterprise Ltd. Full time

    Sunwins Enterprise Ltd. is a Vancouver based real estate and lifestyle brand developer that focuses on residential, commercial and hospitality projects. Delivering innovative architectural solutions, engaging environments, and exceptional lifestyle experiences for our clients. We are currently looking for a Data Analyst to join our team.Title: Data...

  • Data Analyst

    3 weeks ago

    Richmond, Canada Piccolo Software Inc Full time

    This role will be responsible for performing the analysis on a variety of products. The Data Analyst will work to provide the data requested and needed to help the analysts and executives make their decisions. This position will support the CFO and COO by performing data analysis, assist in all accounting operations, and provide support and reports as...

  • Data Analyst Student

    3 weeks ago

    Richmond, Canada PCL Construction Full time

    **The future you want is within reach.** At PCL, we build the places where life happens and find camaraderie in the process. We're a community of builders committed to building better communities. That's why we're always looking ahead, and not just to the next project or what's next in our industry. We're also looking at what's next for you and how we can...

  • Junior Data Analyst

    3 weeks ago

    Richmond, Canada Oomomo Canada Ltd. Full time

    Oomomo is an authentic Japanese variety lifestyle brand launched Canada-wide. To cope with our business development, we are looking for enthusiastic, organized and self-motivated individuals who can work in a fast-paced environment to join our amazing team! - **Junior Data Analyst**_ - Assist in evaluating information from various sources, identifying key...

  • Financial Data Analyst

    3 weeks ago

    Richmond Hill, Canada Paymentus Full time

    Summary/ObjectiveThe Data Analyst collects, processes, and analyzes data to support business decision-making. This role involves working with large datasets, identifying trends, and delivering insights through reports and dashboards. The Data Analyst will require proficiency in SQL and Excel, with Python being preferred for advanced data analysis and...

  • Data Analyst

    3 weeks ago

    Richmond Hill, Canada Nova Vacation Homes Full time

    **Company Overview**: We are one of the top vacation home rental and management companies serving guests and clients in Orlando, Florida - operating from our office in Richmond Hill, Ontario. We’re currently seeking a Data Analyst with a strong focus on revenue and pricing to help optimize rental performance and achieve ambitious growth...

  • Data Quality Analyst

    7 days ago

    Richmond, Canada Ignite Technical Remote Work Freelance Full time

    On behalf of our Public Sector Client, Ignite Technical Resources is recruiting for two (2) Data Quality Analysts to join our Client's team on a 12-month contract with the possibility of extension. This role is hybrid, requiring three days per week onsite in Richmond, BC.Summary of the RoleThe Data Quality Analysts will play a key role in ensuring the...

  • Senior Business Analyst

    4 days ago

    Richmond, Canada Stellar Recruitment Inc. Full time

    One of Stellar's major clients is searching for an experienced and dynamic Senior Business Analyst – Data Analytics to join their team for a contract opportunity in the Lower Maindland. In this role, the successful candidate will be a driving force in shaping data strategies, optimizing operational processes, and ensuring seamless integration of data...

  • Senior Business Analyst

    5 days ago

    Richmond, Canada Stellar Recruitment Inc. Full time

    One of Stellar's major clients is searching for an experienced and dynamic Senior Business Analyst – Data Analytics to join their team for a contract opportunity in the Lower Maindland. In this role, the successful candidate will be a driving force in shaping data strategies, optimizing operational processes, and ensuring seamless integration of data...

  • Senior Business Analyst

    5 days ago

    Richmond, Canada Stellar Recruitment Inc. Full time

    One of Stellar's major clients is searching for an experienced and dynamic Senior Business Analyst – Data Analytics to join their team for a contract opportunity in the Lower Maindland. In this role, the successful candidate will be a driving force in shaping data strategies, optimizing operational processes, and ensuring seamless integration of data...

  • Senior Business Analyst

    3 days ago

    Richmond, Canada Stellar Recruitment Inc. Full time

    One of Stellar's major clients is searching for an experienced and dynamic Senior Business Analyst – Data Analytics to join their team for a contract opportunity in the Lower Maindland. In this role, the successful candidate will be a driving force in shaping data strategies, optimizing operational processes, and ensuring seamless integration of data...

  • Financial Data Analyst

    3 weeks ago

    Richmond Hill, Canada Paymentus Full time

    Summary/Objective The Data Analyst collects, processes, and analyzes data to support business decision-making. This role involves working with large datasets, identifying trends, and delivering insights through reports and dashboards. The Data Analyst will require proficiency in SQL and Excel, with Python being preferred for advanced data analysis and...

  • Financial Data Analyst

    3 weeks ago

    Richmond Hill, Canada Paymentus Full time

    Summary/Objective The Data Analyst collects, processes, and analyzes data to support business decision-making. This role involves working with large datasets, identifying trends, and delivering insights through reports and dashboards. The Data Analyst will require proficiency in SQL and Excel, with Python being preferred for advanced data analysis and...

  • Senior BI Analyst/Data Analyst

    4 days ago

    Richmond Hill, Ontario, Canada Onico Solutions Full time

    Senior Business Intelligence Analyst/DeveloperThe Senior BI Analyst/Developer will play a key role in developing strategic, high-profile executive-level dashboards and reports using Microsoft BI technologies. They will also assist businesses in developing business cases and forecasting/planning using data from data warehouses.Key Responsibilities:Design and...

  • Senior Business Analyst Data F/H

    3 days ago

    Richmond, Canada Stellar Recruitment Inc. Full time

    One of Stellar's major clients is searching for an experienced and dynamic Senior Business Analyst – Data Analytics to join their team for a contract opportunity in the Lower Maindland. In this role, the successful candidate will be a driving force in shaping data strategies, optimizing operational processes, and ensuring seamless integration of data...

  • Data Quality Analyst

    4 days ago

    Richmond, Canada New Value Solutions Full time

    New Value Solutions, a national IT consulting company, is seeking a Data Quality Analyst working with the Enterprise Data Strategy and Governance team. This role is critical in ensuring the accuracy, consistency, and reliability of data assets across the organization. The Data Quality Analyst will collaborate with data architects, data engineers, data...

  • Data Quality Analyst

    6 days ago

    Richmond, Canada New Value Solutions Full time

    New Value Solutions, a national IT consulting company, is seeking a Data Quality Analyst working with the Enterprise Data Strategy and Governance team. This role is critical in ensuring the accuracy, consistency, and reliability of data assets across the organization. The Data Quality Analyst will collaborate with data architects, data engineers, data...

  • Data Quality Analyst

    6 days ago

    Richmond, Canada New Value Solutions Full time

    New Value Solutions, a national IT consulting company, is seeking a Data Quality Analyst working with the Enterprise Data Strategy and Governance team. This role is critical in ensuring the accuracy, consistency, and reliability of data assets across the organization. The Data Quality Analyst will collaborate with data architects, data engineers, data...

  • Data Quality Analyst

    6 days ago

    Richmond, Canada New Value Solutions Full time

    New Value Solutions, a national IT consulting company, is seeking a Data Quality Analyst working with the Enterprise Data Strategy and Governance team. This role is critical in ensuring the accuracy, consistency, and reliability of data assets across the organization. The Data Quality Analyst will collaborate with data architects, data engineers, data...

  • Data Quality Analyst

    5 days ago

    Richmond, Canada New Value Solutions Full time

    New Value Solutions, a national IT consulting company, is seeking a Data Quality Analyst working with the Enterprise Data Strategy and Governance team. This role is critical in ensuring the accuracy, consistency, and reliability of data assets across the organization. The Data Quality Analyst will collaborate with data architects, data engineers, data...