Job Description

A growing global company. Endless career and development opportunities.

When you join Ritchie Bros., you'll be part of a diverse, global team that's focused on delivering great customer experiences. Our culture is centered around people and guided by our core values of Integrity, Unity and Vision. Learn more about our culture and commitment to diversity and inclusion at .

If you have an entrepreneurial spirit and are passionate about making a difference, we invite you to join our growing team. Whether you're out in the field or back at your office, you'll be helping us achieve our vision of becoming the trusted global marketplace for insights, services and transaction solutions for commercial assets.

We're looking for a Senior Data Engineer in North America. This position is eligible for a fully remote work arrangement.

The Opportunity:

Are you passionate about data? Do you get excited about optimizing data flows, giving Data Scientists and Analysts the power to predict the future? Do you have a thirst for learning, driving modernization and innovation in the data space? If this sounds like you, come join our team!

The Data Engineer is a key member of the Data Engineering team, responsible for the Cloud Data Warehouse, Enterprise Data Warehouse and Data Lake. The successful candidate will be responsible for the delivery of project objectives and work on various Data Engineering initiatives, including activities such as: reviewing user stories, analysis of corporate data, and designing, developing, and testing Data Analytics and other data management solutions. The individual will be self-motivated and like do a variety of things, is a quick learner and is good with, and enjoys working with, data. A focus on delivery of high value solutions to the business should be a key driver and motivator.

In this role you'll:

Work on building and architecting data pipelines for Data ingestion and transformation in Google Cloud Platform (GCP), AWS, and SQL Server

Build, maintain, and monitor batch, micro-batch and real-time ETL/ELT pipelines in a Google Cloud Platform architecture (BigQuery, Cloud Composer, Cloud DataFlow, Google Cloud functions, etc.)

Work closely with the Data Science and Analytics teams to develop a clear understanding of data and data infrastructure needs; assist with data-related technical issues

Research and evaluate various approaches to data architecture and applications, including big data and cloud technologies; review existing artifacts and recommend solutions and technologies to implement

Analyze corporate data, design and develop data analytics and other data management solutions

Perform data validation and quality assurance

Document requirements and business rules into appropriate technical specifications

Participate in work planning and estimation

Present technical solutions to various stakeholders

Provide day-to-day support of the CDW, EDW and DL environments, with excellent customer service to internal clients, monitor new deployments and services, escalating issues where appropriate

Create Tableau data sources and dashboards for various Business stakeholders

Actively support the RB Unreserved Commitment to Safety: to send everyone home, every day, the way they came to work, by taking personal responsibility for your safety and safety of your team, co-workers and customers.

Here's what you bring:

5+ years experience working in a directly comparable role responsible for cloud data warehouse and/or data lake development

2+ years experience with Google Cloud Platform (BigQuery, GCS, Cloud Functions, Cloud Dataflow, Pub/Sub, Cloud Shell, GSUTIL, BQ command line utilities, DataProc, Cloud Operations)

2+ years experience with other cloud data technologies such as AWS (S3, Glue, Lambda, Lake Formation, CloudFormation, Athena, Redshift)

5 years working directly with relational databases with strong SQL programming skills; experience with SQL Server (DBMS, SSAS Tabular Model, SSRS), including MDX and DAX

3 years experience designing, building, and optimizing 'big data' pipelines, architectures and data sets

3 years experience with modern programming languages (Python, PySpark, Java, etc.)

Experience with big data solutions (Kafka, Hadoop, Spark, etc.), including data stream processing

Experience designing a new data solution or new subject area

Understanding of dimensional modeling, star schemas, and associated Kimball methodology

Experience with data lakehouse and/or data mesh architectures a bonus

Excellent verbal and written skills in English

Exceptional attention to detail

Experience working on an Agile development team

Strong analytical, troubleshooting and problem-solving skills

A proven ability to effectively prioritize and execute tasks in a high-pressure environment

A strong work ethic without sacrificing your sense of humor or your ability to have fun on the job.

This job will require:

Occasional on-call availability. Occasional evening and weekend work to meet deadlines

What We Offer:

Our success is built on the drive and dedication of our people. As we grow around the globe, there will be many opportunities to advance your career - we've proven this throughout our 60+ years in business. And, we'll take care of you along the way. Here's how:

Base salary + performance bonus

Comprehensive medical and dental benefits.

RRSP / Pension plan and an Employee Share Plan, both with company match.

Ongoing training, professional development and tuition reimbursement.

A multi-award-winning LEED gold-certified facility, in an exceptional park-like setting, featuring:

A subsidized, multi-award-winning childcare centre.

A subsidized cafeteria, dry cleaning services, and free parking.

A workout facility, featuring advanced gym equipment, bike room, shower and changing facilities, and nutrition and fitness programs.

Proximity to miles of Fraser River walking paths, plus shops, restaurants and services.

Ritchie Bros. has grown from a small-town auctioneer to a global asset management and disposition company. Through , we help our customers buy and sell a wide range of used and unused equipment for construction, mining, transportation, agriculture, oil & gas, lifting & material handling, forestry & other industries.

Ritchie Bros. is an equal opportunity employer and ensures nondiscrimination in all activities in accordance with all applicable laws. This position is open to all qualified applicants who are legally entitled to work in the country in which this job is located. Candidate selection is made by Talent Acquisition. Only electronic applications can be accepted. No agency calls, please.

If you require any accommodation, please send an email to: .