Data Analyst
7 months ago
**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, 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...
-
Junior Data Analyst
3 months ago
Richmond, Canada Shipum Logistics Inc. Full timeShipum Logistics Inc. is a leading shipping and trucking company dedicated to providing efficient logistics solutions. We are seeking a motivated Junior Data Analyst to join our dynamic team in Richmond, BC. **Key Responsibilities**: - Assist in collecting, analyzing, and interpreting data to support operational decision-making. - Develop and maintain...
-
Data Reporting Analyst
1 day ago
Richmond, Canada UNFI Full time**Who are we?** **_UNFI Canada is the leading distributor of natural, organic, and specialty foods in North America! We transform the world of food for our associates, customers, and the families we serve everyday! Our mission is simple: to provide healthier food choices to people everywhere._** **_Better Food, Better Future!_** **_If YOU are an aspiring...
-
Data Analyst
4 days ago
Richmond Hill, Canada Jessica Dream Home Inc. Full time**Job Summary** **Responsibilities** - Analyze large datasets to identify trends, patterns, and insights that inform business decisions. - Collaborate with stakeholders to understand their data needs and provide tailored analytical solutions. - Utilize SQL for data extraction, manipulation, and reporting. - Develop and maintain dashboards using Power BI to...
-
Analyst, Data and Analytics
7 months ago
Richmond, Canada Harbour Air Group Full time**NOW HIRING!** **Analyst, Data and Analytics, Richmond** **Do you enjoy working with a close team of supportive professionals? Do you want to commit to an organization with an outstanding record for safety and reliability? Are you searching for an employer who provides amazing perks and works hard to provide a work-life balance for their employees? If so,...
-
Data Analyst Student
3 months 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...
-
Data Analyst Position in Vancouver
4 weeks ago
Richmond, British Columbia, Canada Precise Pipe Full timeJob SummaryWe are seeking a highly skilled Data Analyst to join our team at Precise Pipe, a leading multi-national steel manufacturer and distributor. This is an excellent opportunity for a detail-oriented individual with strong analytical skills to contribute to the success of our company.
-
Junior Data Analyst
3 months ago
Richmond, Canada Oomomo Canada Ltd. Full timeOomomo 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 Position
3 days ago
Richmond, British Columbia, Canada MANILA EXPRESS INC. Full timeThe financial data analyst role at Manila Express Inc. is a fantastic opportunity for those passionate about numbers and detail-oriented work.About the CompanyManila Express Inc. is a reputable organization that values precision and accuracy in its operations.Job DescriptionWe are seeking a highly skilled Financial Data Analyst to join our team. The...
-
Analyst - Master Data Management
2 weeks ago
Richmond Hill, Canada Staples Full time**Some of what you will do**: The MDM Analyst will play a critical role in maintaining and managing product and vendor master data within the organization. This individual will be responsible for ensuring data accuracy, integrity, and compliance with established data governance standards. The MDM Analyst will collaborate with cross-functional teams to...
-
Financial Data Analyst
5 days ago
Richmond Hill, Ontario, Canada UniUni Logistics Full timeJob DescriptionAt UniUni Logistics, we seek a skilled Financial Data Analyst to join our team.Key Responsibilities:Perform bookkeeping tasks, including accounts payable and receivable, as well as general ledger entries.Assist in preparing monthly financial statements and reconciling accounts with high accuracy.Manage and maintain financial records using...
-
Data Analyst
3 weeks ago
Richmond, British Columbia, Canada Precise Pipe Full timeJob Title: Data Analyst - Seamless Pipe Operations CoordinatorLocation: Vancouver, BC.Company Overview:Precise Pipe is a leading multi-national steel manufacturer and distributor. We own multiple seamless mills and maintain a half million metric ton inventory from reputable mills worldwide.Salary:$45,000 - $55,000 per year.Job Description:We are seeking an...
-
Data Analyst
7 months 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...
-
Data Scientist
5 days ago
Richmond Hill, Canada EnvAI Solutions Full timeIf you are a data scientist interested in working in a mission-driven startup working towards a greener economy, reach out to us! We are looking for a motivated individual to join our team as a data scientist to focus on natural language processing (NLP) processing pipelines, data curation and analysis. RESPONSIBILITIES - Create and contribute to NLP...
-
Laboratory Analyst
7 months 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...
-
Business Analyst
3 days ago
Richmond, Canada Openpath Security Inc. Full timeCompany Overview Motorola Solutions is there for our customers when everything is on the line. In extreme moments — when a hurricane lands or when a fire breaks out. And in everyday moments — when a package arrives just in time for the holiday or when a child doesn’t miss the school bus home. We unify voice, data, video and analytics in one...
-
Business Analyst Iii
3 months ago
Richmond, Canada ZEMA Global Data US, LLC Full time**The Opportunity** Zema is a global leader in the development of enterprise data management and analysis software. We design and develop Zema, a sophisticated suite of products that provide clients with powerful capabilities for data collection, process automation and business intelligence through web based analytical tools, services and dashboards. We...
-
Business Analyst Iii
3 weeks ago
Richmond, Canada ZEMA Global Data US, LLC Full time**The Opportunity** Zema is a global leader in the development of enterprise data management and analysis software. We design and develop Zema, a sophisticated suite of products that provide clients with powerful capabilities for data collection, process automation and business intelligence through web based analytical tools, services and dashboards. We...
-
Manager of Data Enablement
6 months ago
Richmond Hill, Canada Staples Full timeSome of what you will do: **Specifically, You Will**: **Data Enablement (40%)**: - Collaborate with IT and business stakeholders to capture requirements, ingest, and make data available in our data warehouse. - Play a vital role in data migration efforts to the Cloud, prioritizing existing data locations with business partners, aligning with IT Dev,...
-
Cost Analyst
3 months ago
Richmond, Canada Viva Pharmaceutical Inc. Full time**Job Overview** As a Cost Analyst, you will be responsible for gathering financial data (e.g. inventory purchases, labor costs) to analyze and evaluate it to support cost-effective decision-making within the organization. **Duties**: - Conduct cost analysis to identify and recommend cost-saving to reduce waste and increase profitability - Prepare detailed...