Database Operations Engineer

Database Operations Engineer - CARFAX CANADA

CARFAX Canada is looking for an experienced Database Operations Engineer to help build and promote a DevOps culture in our Database Operations team! If you have a passion for cloud-based software, experience managing production databases and love a challenge, we want to hear from you!

Working Here

At CARFAX Canada, we’re more than just obsessed with vehicles. We’re obsessed with data and its potential to help millions of Canadians in buying, selling, and maintaining vehicles.

But here’s 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. It’s clear—we’re passionate about data and our people!

Key Information

Employment Status: Full Time

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, ON

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

Job Details

CARFAX Canada is excited to announce the position of Database Operations Engineer, reporting to our Manager of Database Operations.  The Database Operations Engineer will develop and deploy data structures supporting operational and analytical databases. As a Database Operations Engineer you will work closely with the Data Architect, to contribute to the design and implementation of data structures to facilitate the loading, transforming, and availability of data for analysis and product development. You will also support operational teams in maintaining and resolving data inconsistencies and compliance issues.  You will be asked to lead, manage, assess and implement structure, process and monitoring of our database systems. Providing feedback to all teams will be key to your team’s continuous improvement. You will be required to learn, research, pilot and recommend new tools and technologies that can be leveraged to improve the way we work.

Position Responsibilities

• Design, develop and maintain data pipelines using Azure Data Factory (ADF), and SSIS 
• Implement ETL processes to ensure efficient, timely and clean data flow and transformations 
• Develop and deploy Azure Functions running python and C# 
• Advise on, and implement best practices for monitoring, logging, and alerting 
• Collaborate with DBAs, Data Architect, Developers to optimize SQL code and database structures 
• Support the finance team with monthly billing activities 
• Create, maintain, support, and deploy ETL packages for data source intake 
• Review, automate and deploy schema changes 
• Document data flows and models 
• Implement testing to ensure data quality and integrity 
• Coordinate with Data Governance to ensure compliance with data regulations 
• Provide tier 3 support for ETL pipelines 
• Stay updated with emerging technologies and best practices in data 

Education and Experience Required

• 4+ years of experience as a Database Administrator, SQL Developer or Database Engineer 
• Experience with Azure Data Factory, Synapse, or SISS 
• Strong proficiency in SQL (T-SQL) 
• Proficient with Python, Pandas, NumPy, PySpark, Airflow, or C# 
• Experience with CI/CD preferred (Azure DevOps) 
• Experience with Azure and Application Insights 
• Proficient in version control systems and managing repositories/branches 
• Extensive experience working with SQL Server, Azure SQL Database, and Azure Managed Instance (MI) 
• Expert troubleshooting and investigation skills  
• Knowledge of database design methodologies (3rd normal form, star schema, etc) 
• Attention to detail and strong analytical skills  
• Ability to quickly adapt to new technologies and changing priorities

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.

We’re 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 hr@carfax.ca.

If you are interested in applying for this position, please visit our website https://www.carfax.ca/careers. Applications will be accepted until April 11, 2025.

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

About Us

CARFAX’s 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. CARFAX‘s 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 www.carfax.ca 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.