Data Engineer

Carfax Canada is looking for a talented Data Engineer to join our team and build secure stable and scalable data pipelines that power our data-driven initiatives. If you have a passion for working with cutting-edge technologies to process large complex data sets to deliver reliable data solutions that drive business impact we want to hear from you!

Working Here

At CARFAX Canada were more than just obsessed with vehicles. Were obsessed with data and its potential to help millions of Canadians in buying selling and maintaining vehicles.

But heres what you really want to know about: the perks. Our team members enjoy weekly free catered lunches at the office flexible work that allows us to prioritize work-life balance 4-day summer work weeks and a state-of-the-art collaborative environment at our head office at 100 Kellogg Lane London Ontario. CARFAX Canada also offers competitive wages exceptional benefits and employee wellness funding a company matched pension program parental leave top-up benefits paid volunteer days and the list goes on!

Ultimately every day at CARFAX Canada provides you with the opportunity to engage in meaningful work alongside incredible colleagues. Its clearwere passionate about data and our people!

Key Information

Employment Status: Full-time permanent

Job Type: Hybrid In office with flexibility to manage your work schedule with up to 8 days per month to work from home.

Location: London Ontario

Please note that we have two operating entities in Canada CARFAX Inc. and CARFAX Canada. This position is with CARFAX Canada.

Job Details

We are seeking a highly skilled and experienced Data Engineer to join our data this role you will be responsible for designing building and maintaining secure stable and scalable data pipelines and infrastructure that power our data-driven products and analytics initiatives. You will work collaboratively with cross-functional teams including data analysts data scientists software engineers and product managers to ensure the seamless flow quality and accessibility of data across our organization. The ideal candidate will have a passion for working with large-scale datasets and will play a crucial role in transforming raw data into actionable insights that drive business decisions.

Position Responsibilities

• Design build and optimize scalable end-to-end data pipelines for processing large volumes of structured and unstructured data
• Develop robust ETL/ELT processes and API integrations to seamlessly integrate data from diverse sources
• Implement data validation quality frameworks and monitoring systems to ensure accuracy and reliability
• Define and maintain company data assets data models and associated Spark/SparkSQL jobs
• Design efficient data models schemas and database structures to support analytical and operational use cases
• Evaluate and implement data storage solutions including databases data lakes and cloud-based services
• Configure and manage data infrastructure components while optimizing for performance and scalability
• Develop long-term data platform architecture strategy and evaluate tools for data lineage and metadata management
• Build reliable integrations with internal/external data sources and develop RESTful APIs for data access
• Implement data security protocols access controls and governance policies
• Ensure system compatibility and interoperability across platforms
• Partner with cross-functional teams (data scientists analysts engineers product managers) to deliver tailored solutions
• Improve data models that feed BI tools to increase data accessibility across the organization
• Create technical documentation and provide troubleshooting support for data-related issues and maintain robust ETL/ELT pipelines to ingest transform and load data from various sources (e.g. DMV records insurance databases auction feeds).

Education and Experience Required:

• Bachelors or masters degree in computer science Engineering or related field
• 5 years of experience in data engineering software development or related roles
• Proficiency in programming languages commonly used in data engineering (e.g. Python Java Scala)
• Strong knowledge of database systems data modeling techniques normalization and performance optimization with advanced SQL proficiency
• Hands-on experience with ETL tools commonly used in data engineering (e.g. SSIS Databricks Azure Data Factory)
• Experience with big data technologies and frameworks (e.g. Hadoop Spark Kafka)
• Experience with cloud platforms and services (e.g. AWS Azure Google Cloud Platform)
• Experience with data warehousing solutions (e.g. Snowflake Redshift BigQuery)
• Excellent problem-solving skills and attention to detail
• Strong communication and collaboration skills in a team-oriented environment
• Experience with machine learning operations (MLOps) and supporting ML model deployment pipelines is considered an asset
• Knowledge of data governance frameworks and compliance requirements (GDPR CCPA etc.) is considered an asset
• Experience with containerization technologies (Docker Kubernetes) is considered an asset
• Experience with real-time streaming data processing is considered an asset
• Knowledge of data visualization tools and analytics platforms is considered an asset

Equal Opportunity Employer

CARFAX Canada is an equal opportunity employer and all qualified candidates will receive consideration for employment without regard to race/ethnicity color religion sex sexual orientation gender identity national origin age disability marital status military veteran status unemployment status or any other status protected by law.

Were committed to providing accommodations by request for candidates taking part in all aspects of the recruitment and selection process. For a confidential inquiry or to request an accommodation please contact your recruiter or email .

If you are interested in applying for this position please visit our website will be accepted until a suitable candidate is hired.

We thank all applicants for their interest; however only those selected for an interview will be contacted.

About Us

CARFAXs mission is to help millions of people shop buy service and sell used cars with more confidence. As a leader in vehicle history and valuation CARFAX provides impartial and comprehensive information for consumers and the automotive industry. CARFAXs Canadian headquarters in London Ontario supports Canadian and U.S. markets drawing on billions of data records from thousands of sources enabling used vehicle buyers and sellers to make informed decisions. CARFAX is consistently recognized as a top employer and business. CARFAX is a part of S&P Global (NYSE: SPGI). Find out more at and connect with CARFAX on Instagram Facebook and LinkedIn.

Our values serve as the foundation of our culture by helping inform the actions and behaviours that make us successful. We strive to integrate these values into how we collaborate navigate challenges and make decisions daily.

Objective Guided by facts driven by results.

Transparent Clarity through open and honest communication.

Customer advocate Putting the customer at the center of everything we do.

Solutions oriented Turning challenges into opportunities.

Integrity Where honesty meets action.

Required Experience:

Manager

Key Skills
Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala
Employment Type : Full-Time
Department / Functional Area: Product Management
Experience: years
Vacancy: 1