Data Analyst

3 weeks ago

Richmond, Canada OpenRoad Auto Group Full time

**UNLIMITED POSSIBILITIES AHEAD**

**Position**: Data Analyst

**Status**: Full-Time

**Dealership**:Head 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.
- Develop and produce reports upon request including dashboards and report visualizations.
- 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.
- Build and support Excel based tools.
- 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 Microsoft Office including Excel, Word, PowerPoint, Outlook.
- Advanced experience with SQL and ability to create complex queries and joins.
- Self-reliant exploring, extracting, analyzing, and presenting information with Excel (PivotTables, writing VBA code, etc.) and Tableau.
- Demonstrated ability to provide meaningful analytics and visualizations.
- Strong communication skills; ability to effectively communicate with internal and external teams.
- Advanced analytical and problem solving skills to gather operational requirements and recommend innovative solutions.
- Demonstrated ability to develop and organize documentation at a variety of levels including business requirements, technical documents, and user documents.
- Advanced knowledge of relational and multi-dimensional (OLAP) data models and ETL tools.
- Ability to understand complex statistical concepts and translate them to technical requirements.
- Understanding of the Systems Development Life Cycle and project management methodology.
- Strong written and verbal communication skills in English including the ability to expres

  • Data Analyst

    4 days ago

    Richmond, Canada Flair Airlines Ltd. Full time

    **Want to be part of a team that's changing the way Canada travels?** As Canada’s largest independent ultra-low-cost airline, that’s exactly what we’re doing at Flair Airlines. By consistently offering airfares that are a fraction of the ticket prices of “those other airlines”, we are making air travel an affordable option for millions of...

  • Operational Performance Data Analyst

    4 weeks ago

    Richmond, Canada Flair Airlines Ltd. Full time

    **Want to be part of a team that's changing the way Canada travels?** As Canada’s largest independent ultra-low-cost airline, that’s exactly what we’re doing at Flair Airlines. By consistently offering airfares that are a fraction of the ticket prices of “those other airlines”, we are making air travel an affordable option for millions of...

  • Data and Analytics Analyst

    4 days ago

    Richmond Hill, Canada City of Richmond Hill Full time

    Posting Id- 2330- Department- Corporate and Financial Services- Division- Information Technology- Section- Geospatial Information System (GIS)- Job Grade- SEA35 Grade 06- Rate of Pay- $76,516.00 - $90,012.00 Annual- Job Type- Permanent Full Time- Employee Group- SEA- Replacement/New Position- Replacement- Posting Type- Internal and External- Posting Date-...

  • Laboratory Analyst

    4 weeks ago

    Richmond, Canada CARO Analytical Services Full time

    **CARO Analytical Services **is an employee-owned environmental and food laboratory that provides professional analytical testing services to public and private clients throughout Western Canada. Whether supporting a client cleaning up a contaminated site, providing water quality data to ensure Canadians have access to clean water, or supporting the...

  • ESG Analyst

    2 days ago

    Richmond, Canada Premium Brands Holdings Corporation Full time

    Based in the Head Office of Premium Brands, the ESG Analyst is a key part of the Corporate ESG team. They will have a wide range of duties to support the success of the Corporate environmental, social, and governance (ESG) program. The ESG Analyst will contribute to ESG reporting, consolidation, and analysis in a fast-paced environment and help coordinate...

  • Ancillary Revenue Analyst

    4 days ago

    Richmond, Canada Flair Airlines Ltd. Full time

    **Want to be part of a team that's changing the way Canada travels?** As Canada’s largest independent ultra-low-cost airline, that’s exactly what we’re doing at Flair Airlines. By consistently offering airfares that are a fraction of the ticket prices of “those other airlines”, we are making air travel an affordable option for millions of...

  • ESG Analyst

    2 days ago

    Richmond, Canada Premium Brands Holdings Corporation Full time

    Based in the Head Office of Premium Brands, the ESG Analyst is a key part of the Corporate ESG team. They will have a wide range of duties to support the success of the Corporate environmental, social, and governance (ESG) program. The ESG Analyst will contribute to ESG reporting, consolidation, and analysis in a fast-paced environment and help coordinate...

  • ESG Analyst

    3 days ago

    Richmond, Canada Premium Brands Holdings Corporation Full time

    Based in the Head Office of Premium Brands, the ESG Analyst is a key part of the Corporate ESG team. They will have a wide range of duties to support the success of the Corporate environmental, social, and governance (ESG) program. The ESG Analyst will contribute to ESG reporting, consolidation, and analysis in a fast-paced environment and help coordinate...

  • ESG Analyst

    2 days ago

    Richmond, Canada Premium Brands Holdings Corporation Full time

    Based in the Head Office of Premium Brands, the ESG Analyst is a key part of the Corporate ESG team. They will have a wide range of duties to support the success of the Corporate environmental, social, and governance (ESG) program. The ESG Analyst will contribute to ESG reporting, consolidation, and analysis in a fast-paced environment and help coordinate...

  • Financial Analyst

    4 weeks ago

    Richmond, Canada China National Forest Products North America Corporation Full time

    **Financial Analyst Job duties** - Participate in compensation management, semi-annual incentive compensation payments. Provide financial and analytical support for the incentive compensation accounting and forecasting processes. Respond to ad-hoc projects related to incentive compensation program - Assist with the new business process and working with...

  • Laboratory Analyst

    2 weeks ago

    Richmond, Canada CARO Analytical Services Full time

    CARO Analytical Servicesis an environmental and food laboratory that provides professional analytical testing services to public and private clients throughout Western Canada. Whether supporting a client cleaning up a contaminated site, providing water quality data to ensure Canadians have access to clean water, or supporting the government in testing our...

  • Budget Analyst

    4 days ago

    Richmond, Canada School District #38 (Richmond) Full time

    Budget Analyst Recognized for its diversity, dedication to inclusion, and strong partnerships with the community, the Richmond School District is among one of the largest districts in British Columbia with some of the highest graduation rates in the province. With a long history of providing high quality experiences for students, the Richmond School...

  • Business Analyst

    4 weeks ago

    Richmond, Canada Aversan Full time

    **Business Analyst** **Location**:Richmond, BC **Schedule**: HYBRID (2 days in office) **Description** Business Analysts are facilitators who bridge the gap between business and technology, they help inform decisions and deliver value by researching and understanding a business domain, eliciting & documenting needs, requirements & processes, defining &...

  • Reporting Analyst

    4 weeks ago

    Richmond Hill, Canada Smiles First Corp Full time

    Smiles First Corporation is seeking an Entry Level Reporting Analyst to join our team! The Reporting Analyst will be responsible for maintaining our company’s Data and Reporting needs daily. This role will build strong proficiencies in data management practices and Microsoft office, specifically Excel and PowerPoint **Position Responsibilities** -...

  • Analyst, Manufacturing

    6 days ago

    Richmond, Canada Coca-Cola Canada Bottling Limited Full time

    Facility Location - Richmond Work Location - Posting Locations - Richmond Department - Richmond Production Job Function - Manufacturing/Production Operations Employee Type - Regular Employee FT Salaried Shift/Hours - **About Us**: Proudly Canadian and Independently Owned, we are Coke Canada Bottling! Coke Canada Bottling is Canada's premier bottling...

  • Logistics Analyst

    4 days ago

    Richmond, Canada Paper Excellence Full time

    Reporting to the Logistics Manager, the Logistics Analyst is responsible for providing analytical support to the development and management of a list of strategic distribution initiatives and other network maintenance improvement deliverables. This position is a temporary position relating to Maternity Leave coverage scheduled from April 1st, 2023 until...

  • Business Analyst

    4 days ago

    Richmond, Canada Solution SFT Full time

    Hybrid Role: There may be on site presence required (2 days per week). Your mission: Business Analysts are facilitators who bridge the gap between business and technology, they help inform decisions and deliver value by researching and understanding a business domain, eliciting & documenting needs, requirements & processes, defining & validating solutions,...

  • Budget Analyst

    4 days ago

    Richmond, Canada School District #38 (Richmond) Full time

    Recognized for its diversity, dedication to inclusion, and strong partnerships with the community, the Richmond School District is among one of the largest districts in British Columbia with some of the highest graduation rates in the province. With a long history of providing high quality experiences for students, the Richmond School District strives to be...

  • SEO Analyst

    4 weeks ago

    Richmond, Canada eMonster Solutions Ltd. Full time

    eMonster Solutions is one of the leading IT consulting companies with the best reputation in Vancouver. We are aiming at creating customizing solutions to fit every single clients’ need as well as providing professional services on eBusiness buildup and marketing strategies. We helped countless clients to build their eBusiness successfully in the past...

  • Fleet Reliability Analyst

    6 days ago

    Richmond, Canada PACIFIC COASTAL AIRLINES LIMITED Full time

    JOIN OUR TEAM Pacific Coastal Airlines (PCA) is looking for a Fleet Reliability Analyst! This position is based out of a hanger located near the South Terminal at the Vancouver International Airport in Richmond. Pacific Coastal Airlines is headquartered at the South Terminal building at Vancouver International Airport. We fly scheduled and charter service...